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

CX SaIes CDM: Is it possible to create a custom table in backend

in Reporting & Analytics for Sales 3 comments

Summary:

We have a requirement in CDM to create a custom table in ERP backend in order to maintain a relationship which currently does not exist in ERP.

If this is possible, how do we insert/select/update into this custom table?

Requirement:

Customers/Suppliers are created in HZ_PARTIES table by a bulk upload through the import management tool. The similar parties are merged together through Duplication identification and merge CDM out of the box functionality. But, post the merge the losing parties "source system" and "source system reference" go missing (This is an expected funtionality in CDM as per Oracle). There is a requirement from the source system to capture the "source system" and "source system reference". As per oracle support, this isnt supported as of now. Hence as a workaround having a custom table is an potential solution, but we wanted

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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