AP_RETRO_PRICING_PKG is Invalid Due To 'DETAIL_TAX_DIST_ID' (Doc ID 1934306.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

AP_RETRO_PRICING_PKG is Invalid After Patching

ERRORS
---------
 Errors for PACKAGE BODY AP_RETRO_PRICING_PKG:

 LINE/COL ERROR
 -------- -----------------------------------------------------------------
 1025/16 PL/SQL: SQL Statement ignored
 1025/28 PL/SQL: ORA-00913: too many values
 1606/1 PL/SQL: SQL Statement ignored
 1715/9 PL/SQL: ORA-00904: "DETAIL_TAX_DIST_ID": invalid identifier
 1823/10 PL/SQL: SQL Statement ignored
 1823/22 PL/SQL: ORA-00913: too many values
 2373/11 PL/SQL: SQL Statement ignored
 2373/23 PL/SQL: ORA-00913: too many values
 2906/11 PL/SQL: SQL Statement ignored
 2906/23 PL/SQL: ORA-00913: too many values
 3440/10 PL/SQL: SQL Statement ignored
 3440/22 PL/SQL: ORA-00913: too many values
 4582/7 PL/SQL: SQL Statement ignored
 4790/16 PL/SQL: ORA-00904: "D"."DETAIL_TAX_DIST_ID": invalid id



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