Unable to reserve PO or Release, after attempting to approve the status remain 'Pre-approved'
Last updated on OCTOBER 25, 2017
Applies to:Oracle Purchasing - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
On : 12.1.3 version, Approvals - Req, PO
When trying to approve the the standard PO or Release, the documents struck in 'Pre-Approved' because unable to reserve for these documents.
This issue is occurring for all standard PO or Release.
The issue can be reproduced at will with the following steps:
1. Create a PO or Release
2. Submit it for approve
3. The approver approved it
4. There is no specific error in the window but the document status changes to 'Pre-Approved'
The system can't reserve the PO.
We can see the following information in the output of wfstatus.sql for 'Pre-Approved' PO.
27-FEB-13 16:10:16 Reserve Before Approve/Start COMPLETE #NULL
27-FEB-13 16:10:16 Reserve Before Approve/Is Encumbrance On and COMPLETE Y
Is Document Not Reserved?
27-FEB-13 16:10:16 Reserve Before Approve/Document Reserve Subpr COMPLETE N
27-FEB-13 16:10:16 Document Reserve Subprocess/Start COMPLETE #NULL
27-FEB-13 16:10:16 Document Reserve Subprocess/Reserve Document COMPLETE N
27-FEB-13 16:10:16 Document Reserve Subprocess/End COMPLETE #NULL
27-FEB-13 16:10:16 Reserve Before Approve/Is Submitter Last Appr COMPLETE Y
27-FEB-13 16:10:16 Reserve Before Approve/Get Approver Notificat COMPLETE ACTIVITY_PERFOR
ion Attribute MED
27-FEB-13 16:10:16 Reserve Before Approve/Unable To Reserve Docu NOTIFIED CNSKOS
<FND Debug log>
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "-: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program xla_accounting_pkg.print_logfile. ORA-20100: Error: FND_FILE failure.
Unable to create file, o0022215.tmp in the directory, /usr/tmp. You will find more information in the request log.."
xla.plsql.xla_accounting_pkg.AAD_dbase_invalid xla_exceptions_pkg.application_exception: AAD_dbase_invalid
xla.plsql.xla_accounting_pkg.ValidateAAD xla_exceptions_pkg.application_exception: ValidateAAD
xla.plsql.xla_accounting_pkg.accounting_program_events "An internal error occurred. Please inform your system administrator or support representative that:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms