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 APRIL 19, 2017

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:17049323: (Bulk CALCULATE) END SYSDATE
 21-JAN-2014 15:51:53 AP.PLSQL.AP_APPROVAL_PKG.Batch_Approval Rows fetched from GT is 1 fnd.plsql.fnd_file.PUT_LINE sid:17049323: fnd.plsql.fnd_file.PUT_LINE sid:17049323: 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 = 6551584, 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


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