Order Management - EBS (MOSC)

MOSC Banner

Order Import Erred when same orig_sys_document_ref been used in mutiple Orders

edited Sep 4, 2019 7:27AM in Order Management - EBS (MOSC) 6 commentsAnswered ✓

I'm using Order interface to update a booked order, the orig_sys_document_ref on the order has been used in 5 orders, the same error : "You are trying to insert an existing order or update an order that does not exist.  Please enter a correct operation code."  was showing in every interface lines. I also get error:"ORA-01422: exact fetch returns more than requested number of rows in Package OE_ORDER_IMPORT_SPECIFIC_PVT Procedure Pre_Process.header_change_sequence_validation"

I attached the log file in the order import and child order import program, please help to figure out how can I update an order with orig_sys_document_ref has been used in many orders under the same order source and operating unit. Thanks.

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