ORA-01422: Not Able To Create Return Order Via Copy Function - Multiple Price Adjustment
(Doc ID 2763891.1)
Last updated on AUGUST 18, 2021
Applies to:Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.
When attempting to copy an order to an RMA, an error is occurring and users are not able to continue.
EXITING PROCESS_ADJUSTMENTS WITH EXC ERROR with rollback
EXITING PRICE_LINE WITH EXC ERROR
Setting prcing error flag for mass change
In Update Request Line Status : FAILURE
old SP :11335.38
new SP :10924.38
Exceptions have occured, Continuing with the update statement.
SQLERRM: ORA-01422: exact fetch returns more than requested number of rows
LEAVING OE_MSG_PUB.COUNT_AND_GET 0
RETURN STATUS AFTER CALL TO PO E
FAILED TO COPY ORDER
The issue can be reproduced at will with the following steps:
1. Order Management Responsibility
2. Navigation:Orders,Returns > Order Organizer
3. Query Order:Actions > Copy
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document