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

Last updated on AUGUST 23, 2017

Applies to:

Oracle iSupplier Portal - Version 12.2.4 and later
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
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Suppliers: Home --> Prospective Supplier Registrations
2. Try to approve supplier request
3. Getting Error


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