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 03, 2025

Applies to:

Symptoms

OA release 12 - Invoice Validation program

When attempting to validate invoices using the Validation Program, the following error occurs.

ERROR
-----------------------
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

Changes

Cause

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