My Oracle Support Banner

R12 AP: APXPAWKB Get Compilation Errors (Doc ID 859137.1)

Last updated on JANUARY 16, 2018

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.