My Oracle Support Banner

R12/AP: Invalid ZX Objects: Wrong Number or Types of Arguments in Call to 'GET_PROCESS_FOR_APPL_FLG' (Doc ID 2242551.1)

Last updated on JULY 16, 2019

Applies to:

Oracle Payables - Version 12.2.6 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Invalid ZX objects after applying <patch 24571454:R12.AP.C>.

ZX_SRVC_TYP_PKG PACKAGE BODY INVALID
ZX_TDS_CALC_SERVICES_PUB_PKG PACKAGE BODY INVALID
ZX_TPI_SERVICES_PKG PACKAGE BODY INVALID

Below, the errors compiling invalid packages:

SQL> alter package ZX_SRVC_TYP_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY ZX_SRVC_TYP_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
5805/6 PL/SQL: SQL Statement ignored
6401/9 PL/SQL: ORA-00904: "L"."PRVDR_REC_RATE": invalid identifier
11875/9 PL/SQL: Statement ignored
11875/9 PLS-00306: wrong number or types of arguments in call to
  'GET_PROCESS_FOR_APPL_FLG'

12415/16 PL/SQL: Statement ignored
12415/16 PLS-00313: 'UPDATE_EXTN_ATTRS' not declared in this scope
12625/19 PL/SQL: Statement ignored
12625/19 PLS-00306: wrong number or types of arguments in call to
  'GET_PROCESS_FOR_APPL_FLG'

LINE/COL ERROR
-------- -----------------------------------------------------------------

12906/9 PL/SQL: Statement ignored
12906/9 PLS-00306: wrong number or types of arguments in call to
  'DETERMINE_EFFECTIVE_DATE'

13005/10 PL/SQL: Statement ignored
13005/10 PLS-00313: 'UPDATE_EXTN_ATTRS' not declared in this scope
13407/13 PL/SQL: Statement ignored
13407/13 PLS-00306: wrong number or types of arguments in call to
  'GET_PROCESS_FOR_APPL_FLG'


LINE/COL ERROR
-------- -----------------------------------------------------------------
13460/11 PL/SQL: Statement ignored
13460/11 PLS-00313: 'UPDATE_EXTN_ATTRS' not declared in this scope
14553/13 PL/SQL: Statement ignored
14553/13 PLS-00313: 'UPDATE_EXTN_ATTRS' not declared in this scope
14691/13 PL/SQL: Statement ignored
14691/13 PLS-00306: wrong number or types of arguments in call to
  'GET_PROCESS_FOR_APPL_FLG'


SQL> alter package ZX_TDS_CALC_SERVICES_PUB_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY ZX_TDS_CALC_SERVICES_PUB_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
283/11 PLS-00323: subprogram or cursor 'GET_PROCESS_FOR_APPL_FLG' is
  declared in a package specification and must be defined in the
  package body

2639/9 PL/SQL: SQL Statement ignored
2951/21 PL/SQL: ORA-00904: "PRVDR_REC_RATE": invalid identifier
3262/21 PLS-00382: expression is of wrong type
3262/60 PLS-00302: component 'PRVDR_REC_RATE_CODE' must be declared
3263/21 PLS-00382: expression is of wrong type
3263/60 PLS-00302: component 'PRVDR_REC_RATE' must be declared
3277/9 PL/SQL: SQL Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
3589/21 PL/SQL: ORA-00904: "PRVDR_REC_RATE": invalid identifier
3900/21 PLS-00382: expression is of wrong type
3900/60 PLS-00302: component 'PRVDR_REC_RATE_CODE' must be declared
3901/21 PLS-00382: expression is of wrong type
3901/60 PLS-00302: component 'PRVDR_REC_RATE' must be declared

SQL> alter package ZX_TPI_SERVICES_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY ZX_TPI_SERVICES_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
607/4 PL/SQL: Statement ignored
607/59 PLS-00302: component 'PRVDR_REC_RATE_CODE' must be declared
610/4 PL/SQL: Statement ignored
610/59 PLS-00302: component 'PRVDR_REC_RATE' must be declared
1328/4 PL/SQL: Statement ignored
1333/81 PLS-00302: component 'SBC_START_DATE' must be declared
3014/9 PL/SQL: SQL Statement ignored
3251/64 PLS-00302: component 'PRVDR_REC_RATE_CODE' must be declared
3252/16 PL/SQL: ORA-00904:
  "ZX_PTNR_SRVC_INTGRTN_PKG"."G_TAX_LINES_RESULT_TBL"."PRVDR_REC_RA
  TE": invalid identifier

LINE/COL ERROR
-------- -----------------------------------------------------------------

3252/64 PLS-00302: component 'PRVDR_REC_RATE' must be declared
3252/64 PLS-00302: component 'PRVDR_REC_RATE' must be declared

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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