EBS Customizations (MOSC)

MOSC Banner

routing resource batch registration

edited Jun 10, 2025 3:37PM in EBS Customizations (MOSC) 3 commentsAnswered ✓

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;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center