Oracle EBs Apps Blog of Mahfuz, OPM and OBIEE Consultant

Wednesday, 17 December 2025

Isolated  Item delete form system:

-SET DEFINE OFF;
Insert into BOM_DELETE_ENTITIES
   (DELETE_ENTITY_SEQUENCE_ID, DELETE_GROUP_SEQUENCE_ID, DELETE_ENTITY_TYPE, BILL_SEQUENCE_ID, ROUTING_SEQUENCE_ID, 
    INVENTORY_ITEM_ID, ORGANIZATION_ID, ALTERNATE_DESIGNATOR, ITEM_DESCRIPTION, ITEM_CONCAT_SEGMENTS, 
    DELETE_STATUS_TYPE, DELETE_DATE, PRIOR_PROCESS_FLAG, PRIOR_COMMIT_FLAG, LAST_UPDATE_DATE, 
    LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, 
    PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE)
 Values
   (BOM_DELETE_ENTITIES_S.nextval, 455045 -- group id from BOM_DELETE_GROUPS
   , 1, NULL, NULL
   , 5051658 -- inventory item id
     ,102 -- Org id
     , NULL
     , 'COP PUSH BUTTON BLACK MIRROR 36MM DIA WITH CABLE -1' -- item name
     , '0500031025' -- item code
     , 1, null, 1, 1, TO_DATE('07/Dec/22 6:02:52 PM', 'DD/MON/YY HH:MI:SS AM'), 
    1187, TO_DATE('07/Dec/22 6:02:38 PM', 'DD/MON/YY HH:MI:SS AM'), 1187, null, null, 
    null, null, null);
    
     

Isolated  Item delete form system: -SET DEFINE OFF; Insert into BOM_DELETE_ENTITIES    (DELETE_ENTITY_SEQUENCE_ID, DELETE_GROUP_SEQUENCE_ID,...