Blanket Release document stuck in PRE-APPROVED status PSA_FUNDS_CHECKER_PKG.budgetary_control failed XLA-95103 (Doc ID 1521098.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Approvals - Req, PO

When approving a Blanket Release with funds check, the status remains stuck in PRE-APPROVED.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. From the Purchasing responsibility.

2. Query the related Release in Purchase Order Summary.

3. Choose 'Tools > 'Check Funds' and the following message displays: Your budgetary control action completed with exceptions.(OK &View Results buttons).

4. Choose OK and the following displays -No results found, perform Funds check/reserve to view the results (OK buttons).

5. Choose OK and the Release automatically moves to the Approve documents workbench for approval.

6. Requery the document and it remains at pre-approved status.

Additionally the following error is shown in the Trace File & Log File:

FileName
----------------
FND_LOG_MESSAGE_PO_20130107.xlsx

FileComment
----------------------
APPLICATION_ID = 201 ,  EVENT_ID = 43129 ,  EVENT_DATE = 07-JAN-13 ,  EVENT_TYPE_CODE = RELEASE_RESERVED ,  REFERENCE_NUM_1 =
BCTRL -> XLA_PSA_BC_LINES_V DUMP
---------------------------------------
BCTRL -> PSA_BC_ALLOC_GT DUMP
---------------------------------------
XLA_PSA_BC_LINES_V returns 0 rows.
Error: Populated 0 rows in gl_bc_packets.
RETURN -> FALSE
ERROR: PSA_FUNDS_CHECKER_PKG.budgetary_control failed
"-: XLA-95103: An internal error occurred.  Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_je_validation_pkg.budgetary_control.  PSA_FUNDS_CHECK_PKG.budgetary_control failed."
"Error. = ORA-20001: -: XLA-95103: An internal error occurred.  Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_je_validation_pkg.budgetary_control.  PSA_FUNDS_CHECK_PKG.budgetary_control failed."
"An internal error occurred.  Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_je_validation_pkg.budgetary_control.  PSA_FUNDS_CHECK_PKG.budgetary_control failed."


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Users are unable to approve the blanket release.

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