My Oracle Support Banner

Error: ORA-20004 - When Trying To Approve Prospective Supplier Registration. (Doc ID 2251311.1)

Last updated on JANUARY 11, 2018

Applies to:

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

Symptoms

When trying to approve prospective supplier registration the following error occurs:

ERROR
ORA-20004: error in step create supplier business classification: ORA-20090: ORA-06512:
at "APPS.POS_PROFILE_CHANGE_REQUEST_PKG", line 1421 ORA-01407: cannot update ("AP"."AP_SUPPLIERS"."LAST_UPDATED_BY") to NULL ORA-06512:
at "APPS.POS_VENDOR_REG_PKG", line 1402 ORA-20090:
at "APPS.POS_PROFILE_CHAGE_REQUEST_PKG", line 1421 ORA-01407: cannot update ("AP"."AP_SUPPLIERS"."LAST_UPDATED_BY") to NULL ORA-06512:
at "APPS.POS_SUPP_APPR", line 2801 ORA-06512: at line 1

STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
Sign on to Application
Select Responsibility: Supplier Management Administrator
Navigation: Supplier Home ->> Locate Header: New Supplier Requests ->>
Click: "Prospective Supplier Registrations" ->> Locate Supplier Name: "ABC123 Corp"
Actions: Select ->> "Approve" Click: "Go"
Receive Error: ORA-20004: error in step create supplier business classification: ORA-20090: ORA-06512:
at "APPS.POS_PROFILE_CHANGE_REQUEST_PKG", line 1421 ORA-01407: cannot update ("AP"."AP_SUPPLIERS"."LAST_UPDATED_BY") to NULL ORA-06512:
at "APPS.POS_VENDOR_REG_PKG", line 1402 ORA-20090:
at "APPS.POS_PROFILE_CHAGE_REQUEST_PKG", line 1421 ORA-01407: cannot update ("AP"."AP_SUPPLIERS"."LAST_UPDATED_BY") to NULL ORA-06512:
at "APPS.POS_SUPP_APPR", line 2801 ORA-06512: at line 1

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot Approver Supplier Registrations without Error.

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


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