routing resource batch registration
oracle forms 6i, db 10g, oracle app (ebs) 11i
I am trying to batch register a large amount of routing-related data according to the sequence in the source code below. However, in step 7 (RESOURCE), when I execute the import, the data is not registered and remains in the interface table. How can I solve this issue?
-- 5) Routing Header Interface
SELECT ORGANIZATION_ID,
ASSEMBLY_ITEM_NUMBER,
ALTERNATE_ROUTING_DESIGNATOR,
ROUTING_TYPE,
TRANSACTION_TYPE,
PROCESS_FLAG,
COMPLETION_SUBINVENTORY
FROM BOM_OP_ROUTINGS_INTERFACE
FOR UPDATE;
-- and then routing import in oracle erp
/** Endig of Routing Header Import **/
SELECT * FROM BOM_OP_ROUTINGS_INTERFACE;