ERPstuff - Oracle EBS Community

Hi All,

We got a business requirement where we need to do perform merge scenario through interface.

We are aware of fronted Merge Activity. Can any one advice/suggest how to accomplish merge programatically. Are there any merge interface tables and Programs which can be called through Pl/sql code.

Please share your thoughts

Hi,


May i know why you want a Interface for Standard process Customet merge. what is you requirement exactly.


Regards
Anjan

Hi Anjan,

Thanks for your response.

Our business requirement is like this:
CMF is a Customer/party database hub. When ever customer/party is created,updated,merged , details will be sent across to ERP.

At erp end, we have custom tables where these data are stored, TCA-API's will pick these unprocessed records and populate into TCA base tables like HZ_PARTIES,HZ_CUST_ACCOUNTS etc..

Now we need to work on merge, when ever customer/party is merged, record is sent across from cmf with specific columns which has details of from and to merge.

I am looking for some logic how to approach merge concept.

inserting data into RA_CUSTOMER_MERGES then call 'RAXMRG' customer merge program.


can you please advice if u are aware.