Attribute Phone Country Code Showing An Error Importing Suppliers (Doc ID 1593584.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle Fusion Supplier Model - Version 11.1.5.0.0 to 11.1.5.0.0 [Release 1.0]
Oracle Fusion Supplier Model Cloud Service - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Symptoms

Attribute Phone Country Code showing an error while supplier import:

Error Message

Rejection Reason Attribute Value
----------------------------------------------------------------- ------------------ ----------
Value provided is inactive or invalid. PHONE_COUNTRY_CODE +33
Attribute Phone Country Code cannot be null.
message due to error java.lang.IllegalArgumentException: can't +33
 parse argument number TABLE_NAME. Use the exception stack trace
 and error code to investigate the root cause of this exception.
 Root cause error code is JBOHZ::: HZ_INVALID_PHONECOUNTRYCODE.
 Error message parameters are {0=Entity Object, 1=PhoneEO,
 2=PhoneCountryCode, 3=+33}

JBO-29115 Unable to construct the error
Attribute Phone Country Code cannot be null.
JBO-29115 Unable to construct the error PHONE_COUNTRY_CODE +33
 message due to error java.lang.IllegalArgumentException: can't
 parse argument number TABLE_NAME. Use the exception stack
 trace and error code to investigate the root cause of this
 exception. Root cause error code is JBOHZ:::
 HZ_INVALID_PHONECOUNTRYCODE. Error message parameters are
 {0=Entity Object, 1=PhoneEO, 2=PhoneCountryCode, 3=+33}


Steps To Reproduce
1. Insert data using insert script for supplier interface tables like poz_suppliers_int, poz_supplier_sites_int
2. Run the Import Suppliers/Import Supplier Sites scheduled process.
3. Find Sites are REJECTED due to PHONE_COUNTRY_CODE

Business Impact
Due to this issue, users cannot migrate Supplier data to Fusion

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