My Oracle Support Banner

Unexpected Error Encountered While Registering The Supplier (Doc ID 472633.1)

Last updated on FEBRUARY 19, 2021

Applies to:

Oracle Sourcing - Version 12.0.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:
EBS 12 in Production:

On the iSupplier Portal Registration page, when banking details are filled out by the supplier
through the iSupplier page and the supplier submits form, the following error occurs:

ERROR:
java.sql.SQLException: ORA-20018: Failure at step 4 ORA-20026: Failure at step 20 ORA-20049: Failure
at step 1ORA-01400: cannot insert NULL into ("POS"."POS_ACNT_ADDR_SUMM_REQ"."EXT_BANK_ACCOUNT_ID")
ORA-06512: at "APPS.POS_SBD_TBL_PKG", line 312
ORA-01400: cannot insert NULL into ("POS"."POS_ACNT_ADDR_SUMM_REQ"."EXT_BANK_ACCOUNT_ID")
ORA-06512: at "APPS.POS_SBD_PKG", line 2217
ORA-20049: Failure at step 1 ORA-01400: cannot insert NULL into
("POS"."POS_ACNT_ADDR_SUMM_REQ"."EXT_BANK_ACCOUNT_ID")
ORA-06512: at "APPS.POS_SBD_TBL_PKG", line 312
ORA-01400: cannot
ORA-06512: at "APPS.POS_SBD_PKG", line 576
ORA-20026: Failure at step 20 ORA-20049: Failure at step 1 ORA-01400: cannot insert NULL into
("POS"."POS_ACNT_ADDR_SUMM_REQ"."EXT_BANK_ACCOUNT_ID")
ORA-06512: at "APPS.POS_SBD_TBL_PKG", line 312
ORA-01400: cannot insert NULL into ("POS"."POS_ACNT_ADDR_SUMM_REQ"."EXT_BANK_ACCOUNT_ID")
ORA-06512: at "APPS.POS_SBD_PKG", line 2217
ORA-20049: Failure at step 1 ORA-01400: cannot insert NULL into
("POS"."POS_ACNT_ADDR_SUMM_REQ"."EXT_BANK_ACCOUNT_ID")
ORA-06512: at "APPS.POS_SBD_TBL_PKG", line 312
ORA-01400: cannot insert NULL into ("POS"."POS_ACNT_ADDR_SUMM_REQ"."EXT_BANK_ACCOUNT_ID")
ORA-06512: at line 1
...

Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Create RFI from Oracle Sourcing
2. Create Prospective Supplier from Oracle Sourcing
3. Create New Supplier Request and press the Register Button, the application displays the error page

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.