Sunday, June 15, 2014

Query to find the orig system reference for a Customer/Party and other TCA entities

9:34 PM  ,  1 comment
If the data was imported into the EBS system from ABC system and ABC's party id was used as the cross system , the below query can be used to cross-link them

select ORIG_SYSTEM_REFERENCE from apps.HZ_ORIG_SYS_REFERENCES where owner_table_name = 'HZ_PARTIES' and ORIG_SYSTEM = ‘ABC’ and OWNER_TABLE_ID = <party_id in EBS>

ORIG_SYSTEM_REFERENCE = PARTY_ID in ABC

ORIG_SYSTEM = ABC

OWNER_TABLE_ID = Party ID in EBS

OWNER_TABLE_NAME = HZ_PARTIES

1 comments:

  1. Anonymous_AbhiSeptember 3, 2015 at 11:45 PM

    How is data loaded into hz_orig_sys_references. Is there a standard program to load data

    ReplyDelete

Subscribe to: Post Comments (Atom)