R12: AP: Invoice Validation program (APPRVL) finishes in Error status. ORA-01086 in AP_APPROVAL_PKG_SP_ETAX error message displayed
(Doc ID 1616309.1)
Last updated on DECEMBER 15, 2020
Applies to:Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.
OA release 12 - Invoice Validation program
When attempting to validate invoices using the Validation Program, the following error occurs.
AP.PLSQL.AP_ETAX_UTILITY_PKG.GET_CCID_FROM_PROJECTS : Error encountered in pa_flexbuild
AP.PLSQL.AP_ETAX_SERVICES_PKG.Populate_Lines_GT Error while retriving the ccid from projects
fnd.plsql.fnd_file.PUT_LINE sid:xxxxxx: (Bulk CALCULATE) END SYSDATE
DD-MMM-YYY 00:00:00 AP.PLSQL.AP_APPROVAL_PKG.Batch_Approval Rows fetched from GT is 1 fnd.plsql.fnd_file.PUT_LINE sid:xxxxxx: fnd.plsql.fnd_file.PUT_LINE sid:xxxxxx: ORA-01086: savepoint 'AP_APPROVAL_PKG_SP_ETAX' never
established in this session or is invalid AP.PLSQL.AP_APPROVAL_PKG.Batch_Approval Others: Exception: ORA-01086: savepoint 'AP_APPROVAL_PKG_SP_ETAX' never
established in this session or is invalid fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log APP-SQLAP-10000: ORA-01086: savepoint 'AP_APPROVAL_PKG_SP_ETAX' never
established in this session or is invalid occurred in
with parameters (Run Option = All,
Batch Id = , Begin Date = , End Date = , Vendor Id = , Pay Group = , Invoice
Id = , Entered By = , Concurrent Request Id = yyyyyyy, Org Id = )
while performing the following operation: &DEBUG_INFO
Steps to reproduce
The issue can be reproduced at will with the following steps:
1. Login to Payables Responsibility
2. Run the Invoice Validation Program
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