You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

While importing the customers, we are getting error messages however customer get created successful

in ERP Integrations 1 comment

Summary:

Error Message:

The value in the {ATTRIBUTE1} column isn't valid. You must enter a value of {ATTRIBUTE2} from the {ATTRIBUTE3} table

INTERFACE_TABLE_NAME: 'HZ_IMP_ROLERESP'


Content (please ensure you mask any confidential information):


Query Used:

SELECT
ha.account_number,
hps.party_site_number as "party_site_number",
hie.INTERFACE_TABLE_NAME,
fnm.MESSAGE_TEXT as "error_msg",
hie.MESSAGE_NAME,
hie.ERROR_MSG_TEXT,
hie.CREATED_BY,
hrr.load_request_id
,(hie.token1_name || NVL2(hie.token1_value, '-', '') || hie.token1_value || NVL2(hie.token1_value, ',', '') || hie.token2_name || NVL2(hie.token2_value, '-', '') || hie.token2_value || NVL2(hie.token2_value, ',', '') || hie.token3_name || NVL2(hie.token3_value, '-', '') || hie.token3_value || '.' || fnm.message_text) error_message

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!