My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.