Unable to reserve PO or Release, after attempting to approve the status remain 'Pre-approved' (Doc ID 1535437.1)

Last updated on JULY 14, 2016

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.

Symptoms

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.

STEPS
-----------------------
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.

<wfstatus.sql output>

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
                                ocess

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
                                over?

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
                                ment


<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:

Cause

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