Invoice Validation Process Fails With Exception Errors (Doc ID 2022437.1)

Last updated on APRIL 17, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Payables - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

1. DESCRIPTION OF THE LOSS OF FUNCTIONALITY
------------------------------------------------------
In Oracle Payables, when a user attempts to validate invoice using the APPRVL module: Invoice Validation the following error occurs:

ERROR
-------

Enter Password:
MSG-00101: Error occured in BATCH_APPROVAL()
MSG-00102: Error Code : -20001
MSG-00103: Error Message : ORA-20001:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_APPROVAL_PKG", line 11267
MSG-00000: When Others:User-Defined Exception
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-00101: Error occured in BATCH_APPROVAL()
MSG-00102: Error Code : -20001
MSG-00103: Error Message : ORA-20001:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_APPROVAL_PKG", line 11267
MSG-00000: When Others:User-Defined Exception
REP-1419: 'beforereport': PL/SQL program aborted.


Report Builder: Release 10.1.2.3.0 - Production on Mon Dec 29 11:57:13 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.


+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
(Bulk CALCULATE) START SYSDATE 29-DEC-2014 11:57:14
Transfer_Mode: TAB
ZX_API_PUB.Calculate.Statistics Start Time:29-12-2014 11:57:15
ZX_API_PUB.Calculate.Statistics End Time:29-12-2014 11:58:43
ZX_API_PUB.Calculate.Statistics Total Time:0:1:28
ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :18
ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :26
(Bulk CALCULATE) END SYSDATE 29-DEC-2014 11:58:43
(Bulk DISTRIBUTE) START SYSDATE 29-DEC-2014 11:58:43
ZX_API_PUB.Determine_recovery.Statistics Start Time:29-12-2014 11:58:44
ZX_API_PUB.Determine_recovery.Statistics End Time:29-12-2014 11:58:45
ZX_API_PUB.Determine_recovery.Statistics Total Time:0:0:1
ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRX_HEADERS_GT :18
ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :26
(Bulk DISTRIBUTE) END SYSDATE 29-DEC-2014 11:58:45
PO_ACTIONS-065: Subroutine CLOSE_AUTO() returned error

Cause: Subroutine CLOSE_AUTO() returned an internal error.

Action: Note this error number and the actions you are trying to perform. Contact your system administrator for assistance.

ORA-20001: APP-PO-14144: PO_ACTIONS-065: Subroutine CLOSE_AUTO() returned error

Cause: Subroutine CLOSE_AUTO() returned an internal error.

Action: Note this error number and the actions you are trying to perform. Contact your system administrator for assistance.


2. BUSINESS IMPACT
----------------------
Due to this issue, users cannot pay supplier on-time. Late payments affect the payment terms established by suppliers and consequently disrupts the business continuity of the organization. Moreover, the current payables accounting period cannot be closed. Problematic transactions will have to be swept to the following period, which is not in agreement with the date in which the transactions occurred.


3. STEPS OR EVENTS THAT LEAD TO THE ISSUE OCCURRING
----------------------------------------------------------------
The issue can be reproduced at will with the following steps:

1. Using Payables Manager responsibility

2. Navigate to Other > Requests

3. Click on Single Request

4. Enter Request Name (APPRVL module: Invoice Validation)

5. Enter Parameters

6. Click Ok

7. Click on Submit

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