My Oracle Support Banner

In Edit Requisition Flow, Change Charge Account And Apply To All Requisition Lines Gets ORA-20000: Exception at POR_UTL_PKG.restore_working_copy (Doc ID 2037321.1)

Last updated on MAY 06, 2024

Applies to:

Oracle iProcurement - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Oracle Purchasing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


On Applications 12.1.3 - 12.2.4 :
During Edit requisition flow, change charge account and apply to all and submit gets ORA-20000: Exception at POR_UTL_PKG.restore_working_copy

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20000: Exception at POR_UTL_PKG.restore_working_copy(p_origHeaderId:#######,p_tempHeaderId:#######) 010 SQLERRM:ORA-01403: no data found
ORA-06512: at "APPS.POR_UTIL_PKG", line 1453
ORA-06512: at line 1

What is working
If the charge account is changed for each line and then submitted there is no error

The issue can be reproduced at will with the following steps.
1. Preparer creates the requisition with multiple lines and submits for approval.
2. Approver opens the notification, choose edit requisition, change the charge account for first line, and check the box to apply the changes to all the lines.
3. Submit the requisition change and see the errors.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.