My Oracle Support Banner

party_site_number must have a value Error while Approving Supplier Registration (Doc ID 2819873.1)

Last updated on NOVEMBER 11, 2021

Applies to:

Oracle iSupplier Portal - Version 12.1.3 and later
Oracle Supplier Lifecycle Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version, Supplier Registration Issues

When attempting to approve supplier registration, the following error occurs.

ERROR
-----------------------
Error Name = -20001 Error Message = ORA-20001: Failed to approve the registration request: Column party_site_number must have a value. Error Stack = Wf_Engine_Util.Function_Call(POS_SUPP_APPR.PROCESS_SUPP_REG, POSSPAPP, 100533, 297427, RUN)



Steps To Reproduce:
----------------------------
 1. Supplier Management Administrator > Register a supplier from "Register New Supplier" 
 2. Submit the supplier registration
 3. Workflow send the registration to approver 1 for approval.
 4. Approver 1 approves the registration from worklist or supplier profile administrator responsibility or email.
 5. Workflow send the notification to approver 2 for approval.
 6. Approver 2 approves the registration from work list or supplier profile administrator responsibility or email.
 7. Workflow ends in error. Error Message = ORA-20001: Failed to approve the registration request: Column party_site_number must have a value 

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.