POS_VENDOR_REG_PKG PKG, POS_SPM_WF_PKG1 and POS_SUPP_APPR Are Invalid After Applying Patch 19297000:R12.POS.D (Doc ID 2057699.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle iSupplier Portal - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

In Oracle iSupplier Portal, Release 12.2.3, there are some invalid objects after applying Patch 19297000:R12.POS.D.
The issue does not occur on Release 12.2.4 and later.

 

Errors for PACKAGE BODY POS_SPM_WF_PKG1:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1877/4 PL/SQL: Statement ignored
1880/45 PLS-00313: 'GET_SUPP_REJECT_NOTIF_SUBJECT' not declared in this scope
3038/4 PL/SQL: Statement ignored
3038/23 PLS-00302: component 'GET_EMPLOYEEID' must be declared
3039/4 PL/SQL: Statement ignored
3039/23 PLS-00302: component 'UPDATE_REG_ACTION_HIST' must be declared
3140/4 PL/SQL: Statement ignored
3143/45 PLS-00313: 'GET_SUPP_REOPEN_NOTIF_SUBJECT' not declared in this scope
3254/4 PL/SQL: Statement ignored
3257/45 PLS-00313: 'GET_SUPP_LINK_NOTIF_SUBJECT' not declared in this scope
3366/4 PL/SQL: Statement ignored
3369/45 PLS-00313: 'GET_SUPP_SAVE_NOTIF_SUBJECT' not declared in this scope
3479/4 PL/SQL: Statement ignored
3482/45 PLS-00313: 'GET_SUPP_SUBMIT_NOTIF_SUBJECT' not declared in this scope
3582/4 PL/SQL: Statement ignored
3585/45 PLS-00313: 'GET_SUPP_RETURN_NOTIF_SUBJECT' not declared in this scope
3608/3 PL/SQL: Statement ignored
3608/22 PLS-00302: component 'GET_EMPLOYEEID' must be declared
3610/3 PL/SQL: Statement ignored
3611/82 PLS-00302: component 'ACTN_RETURN_TO_SUPP' must be declared


Errors for PACKAGE BODY POS_SUPP_APPR:

LINE/COL ERROR
-------- ----------------------------------------------------------
668/3 PL/SQL: Statement ignored
668/78 PLS-00302: component 'ACTN_PENDING' must be declared
1002/3 PL/SQL: Statement ignored
1003/80 PLS-00302: component 'ACTN_APPROVE' must be declared
1362/4 PL/SQL: Statement ignored
1363/75 PLS-00302: component 'ACTN_RETURN_TO_SUPP' must be declare
1480/3 PL/SQL: Statement ignored
1481/75 PLS-00302: component 'ACTN_FORWARD' must be declared
1801/3 PL/SQL: SQL Statement ignored
1802/16 PL/SQL: ORA-02289: sequence does not exist
2206/5 PL/SQL: SQL Statement ignored
2208/18 PL/SQL: ORA-02289: sequence does not exist
2320/7 PL/SQL: Statement ignored
2321/65 PLS-00302: component 'ACTN_PENDING' must be declared
2329/7 PL/SQL: Statement ignored
2330/65 PLS-00302: component 'ACTN_FYI' must be declared
2762/9 PL/SQL: SQL Statement ignored
2766/18 PL/SQL: ORA-00942: table or view does not exist
2834/13 PL/SQL: Statement ignored
2835/91 PLS-00302: component 'ACTN_NO_ACTION' must be declared


Errors for PACKAGE BODY POS_VENDOR_REG_PKG:

LINE/COL ERROR
-------- ----------------------------------------------------------
883/20 PLS-00302: component 'NOTIFY_SUPP_APPR_NO_USER_ACC' must be declared
1565/4 PLS-00313: 'GET_EMPLOYEEID' not declared in this scope
1567/82 PLS-00302: component 'ACTN_REJECT' must be declared
1683/20 PLS-00302: component 'SEND_SUPPLIER_REG_SUBMIT_NTF' must be declared
1686/4 PLS-00313: 'GET_EMPLOYEEID' not declared in this scope
1688/44 PLS-00201: identifier 'ACTN_SUBMIT' must be declared
1843/4 PLS-00313: 'GET_EMPLOYEEID' not declared in this scope
1845/44 PLS-00201: identifier 'ACTN_SAVE' must be declared
1868/20 PLS-00302: component 'SEND_SUPPLIER_REG_LINK_NTF' must be declared
1894/9 PL/SQL: ORA-00942: table or view does not exist

 


Business Impact

Due to this issue, users are getting errors and unable to create suppliers manually though Supplier Pages in Oracle Payables responsibility.



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