Confirmation Notification For Prospective Supplier Registration Gets Error: ORA-20002: 3240: Error '-6550 - ORA-06550: line 1, column 23: PLS-00302: component 'GET_APPRV_SUPPLIER_BODY' must be declared (Doc ID 2000811.1)

Last updated on AUGUST 05, 2015

Applies to:

Oracle iSupplier Portal - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Supplier Registration Issues

When the supplier is attempting to view notifications in iSupplier,
the following error occurs.

ERROR
-----------------------

ORA-20002: 3240: Error '-6550 - ORA-06550: line 1, column 23: PLS-00302: component 'GET_APPRV_SUPPLIER_BODY' must be declared
ORA-06550: line 1, column 7: PL/SQL: Statement ignored ' in 'PLSQLCLOB' API 'pos_spm_wf_pkg1.GET_APPRV_SUPPLIER_BODY'
ORA-06512: at "APPS.WF_NOTIFICATION", line 5628 ORA-06512: at line 6


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Log into iSupplier Portal as external supplier user
2. Click on a notification like - Supplier Collaboration Network: Registration Approval
- see the errors

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