R12 AP: APXPAWKB Get Compilation Errors (Doc ID 859137.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.
***Checked for relevance on 08-Jan-2016***

Symptoms


When  compiling APXPAWKB the form will not re-generate and receive errors.

Compiling package body PAY_SUM_FOLDER_ITEM_VENDOR...
Compilation error on package body PAY_SUM_FOLDER_ITEM_VENDOR:
PL/SQL ERROR 201 at line 384, column 10
identifier 'IBY_EXT_PAYEE_RELSHIPS_PKG.DEFAULT_EXT_PAYEE_RELATIONSHIP' must be declared
PL/SQL ERROR 0 at line 384, column 10
Statement ignored
PL/SQL ERROR 302 at line 449, column 26
component 'GET_BANK_DETAILS' must be declared
PL/SQL ERROR 0 at line 449, column 2
Statement ignored
PL/SQL ERROR 201 at line 950, column 8
identifier 'IBY_EXT_PAYEE_RELATIONSHIPS' must be declared
PL/SQL ERROR 0 at line 948, column 3
SQL Statement ignored
PL/SQL ERROR 201 at line 967, column 9
identifier 'IBY_EXT_PAYEE_RELATIONSHIPS' must be declared
PL/SQL ERROR 0 at line 959, column 4
SQL Statement ignored
PL/SQL ERROR 201 at line 980, column 9
identifier 'IBY_EXT_PAYEE_RELATIONSHIPS' must be declared
PL/SQL ERROR 0 at line 978, column 4
SQL Statement ignored
PL/SQL ERROR 201 at line 999, column 10
identifier 'IBY_EXT_PAYEE_RELATIONSHIPS' must be declared
PL/SQL ERROR 0 at line 991, column 5
SQL Statement ignored
PL/SQL ERROR 201 at line 1019, column 10
identifier 'IBY_EXT_PAYEE_RELATIONSHIPS' must be declared
PL/SQL ERROR 0 at line 1011, column 5
SQL Statement ignored
PL/SQL ERROR 302 at line 1134, column 31
component 'GET_BANK_DETAILS' must be declared
PL/SQL ERROR 0 at line 1134, column 7
Statement ignored


Compiling package body PAY_ACTIONS_MAIN...
Compilation error on package body PAY_ACTIONS_MAIN:
PL/SQL ERROR 30 6 at line 32, column 5
wrong number or types of arguments in call to 'REPLACE_CHECK'
PL/SQL ERROR 0 at line 32, column 5
Statement ignored

Compiling package body PAY_ACTIONS_REISSUE...
Compilation error on package body PAY_ACTIONS_REISSUE:
PL/SQL ERROR 302 at line 284, column 36
component 'VALIDATE_PAYMENT_DOCUMENT' must be declared
PL/SQL ERROR 0 at line 284, column 8
Statement ignored

Compiling package body ADJ_INV_PAY_PROCEDURE...
Compilation error on package body ADJ_INV_PAY_PROCEDURE:
PL/SQL ERROR 414 at line 254, column 12
no column 'PAY_AWT_GROUP_ID' in table
PL/SQL ERROR 0 at line 246, column 3
SQL Statement ignored


Compiling package body PAY_SUM_FOLDER_ITEM_DATE...
Compilation error on package body PAY_SUM_FOLDER_ITEM_DATE:
PL/SQL ERROR 201 at line 311, column 10
identifier 'IBY_EXT_PAYEE_RELSHIPS_PKG.DEFAULT_EXT_PAYEE_RELATIONSHIP' must be declared
PL/SQL ERROR 0 at line 311, column 10
Statement ignored
PL/SQL ERROR 302 at line 365, column 26
component 'GET_BANK_DETAILS' must be declared
PL/SQL ERROR 0 at line 365, column 2
Statement ignored

Compiling package body APXPAWKB2...
Compilation error on package body APXPAWKB2:
PL/SQL ERROR 306 at line 260, column 5
wrong number or types of arguments in call to 'AP_LOCK_INVOICES'
PL/SQL ERROR 0 at line 260, column 5
Statement ignored

Compiling package body MO_FUNCTIONS...
Compilation error on package body MO_FUNCTIONS:
PL/SQL ERROR 302 at line 65, column 55
component 'SP_ALLOW_PYMT_THIRD_PARTY_OVRD' must be declared
PL/SQL ERROR 0 at line 65, column 8
Statement ignored


Compiling package body PAY_SUM_FOLDER_ITEM_IBY...
Compilation error on package body PAY_SUM_FOLDER_ITEM_IBY:
PL/SQL ERROR 302 at line 594, column 36
component 'VALIDATE_PAYMENT_DOCUMENT' must be declared
PL/SQL ERROR 0 at line 594, column 8
Statement ignored
PL/SQL ERROR 201 at line 1020, column 9
identifier 'REMIT_TO_SUPPLIER_SITE_ID' must be declared
PL/SQL ERROR 0 at line 1020, column 2
SQL Statement ignored


Compiling package body PAY_SUM_FOLDER_PKG_DL...
Compilation error on package body PAY_SUM_FOLDER_PKG_DL:
PL/SQL ERROR 306 at line 17, column 7
wrong number or types of arguments in call to 'LOCK_ROW'
PL/SQL ERROR 0 at line 17, column 7
Statement ignored

Compiling package body PAY_SUM_FOLDER_PKG_I...
Compilation error on package body PAY_SUM_FOLDER_PKG_I:
PL/SQL ERROR 306 at line 10, column 3
wrong number or types of arguments in call to 'INSERT_ROW'
PL/SQL ERROR 0 at line 10, column 3
Statement ignored

Compiling package body PAY_SUM_FOLDER_PKG_U...
Compilation error on package body PAY_SUM_FOLDER_PKG_U:
PL/SQL ERROR 306 at line 23, column 3
wrong number or types of arguments in call to 'UPDATE_ROW'
PL/SQL ERROR 0 at line 23, column 3
Statement ignored

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