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

How to Import Customer Accounts, Sites, Site uses for an existing Organization Party in Fusion

Question
12
Views
0
Comments
edited Apr 26, 2022 11:35PM in Receivables & Collections

Summary: We have a scenario where Customers are created in Oracle Sales cloud as a SALES_PROSPECT but doesn't have accounts. But now we are migrating the Customer Account, Account Sites, Account Site uses, etc for those customers from a legacy EBS system using Customer Import FBDI. Getting the following Error: The reference to the party is invalid, or the party doesn't exist. Import program is unable to identify the Party ORIG_SYSTEM_REFERENCE value passed in the Account Import interface table.


Content (required):

There is no entry for those Parties in HZ_ORIG_SYS_REFERENCES table. We are using ORIG_SYSTEM_REFERENCE from HZ_PARTIES of Fusion as Party Original System Reference and FUSION as the value for Party Original System fields in iHZ_IMP_ACCOUNTS_T to import the respective Customer Account.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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