11 Working with Cross-References

Cross-references map and connect the records within the application network and enable these applications to communicate in the same language. The integration server stores the relationship in a persistent way so that others can refer to it.

This chapter includes the following section:

• Section 11.1, "Oracle Financial Management Cross-References"

For more information about cross-references, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack.

11.1 Oracle Financial Management Cross-References

Table 11-1 lists the Oracle Financial Management cross-references for accounting.

Table 11-1 Oracle Financial Management Cross-References for Accounting

Name	Column	Description
ACCOUNTINGENTRY_ACCOUNTINGENTRY ID	OTM_01, COMMON, EBIZ_01	To maintain the cross-reference between OTM and Oracle E-Business Suite AccountingEntryID. OTM_01 - <Domain>::<AccrualXid> COMMON AIA GUID
ACCOUNTINGENTRY_ACCOUNTINGENTRY ID	OTM_01, COMMON, EBIZ_01	To maintain the cross-reference between OTM and Oracle E-Business Suite AccountingEntryID. OTM_01 - <Domain>::<AccrualXid> COMMON AIA GUID EBIZ_01 - ACCRUAL_ID
CURRENCYEXCHANGE_ID	EBIZ_01, COMMON, OTM_01	This is used to store the cross-reference for the exchange rates among the different applications. Cross-reference value for Oracle E-Business Suite and OTM is concatenation of FromCurrency, ToCurrency, CurrencyExchangeRateType, and ConversionDate with ::" separating them. GUID is a common value.
INVOICE_INVOICEID	OTM_01, COMMON, EBIZ_01	To maintain the cross-reference between OTM and Oracle E-Business Suite Invoice ID. OTM_01 - <Domain>::<BillingXid> COMMON AIA GUID EBIZ_01 - INVOICE_ID
INVOICE_INVOICEID	OTM_01, COMMON, EBIZ_01	To maintain the cross-reference between OTM and Oracle E-Business Suite Invoice ID. OTM_01 - <Domain>::<BillingXid> COMMON AIA GUID EBIZ_01 - INVOICE_ID
ORGANIZATION_ID	EBIZ_01, COMMON, OTM_01	This is used to look up the cross-reference values for the Operating Unit / Business Unit / Domain information of supplier. Common - GUID. OTM -Domain names EBIZ - ORG_ID
PAYABLEINVOICE_PAYABLEINVOICEID	OTM_01, COMMON, EBIZ_01	To maintain the cross-reference between the PayableInvoice ID between OTM and E-Business Suite. Cross-reference value for Oracle E-Business Suite and OTM is concatenation of FromCurrency, ToCurrency, CurrencyExchangeRateType and ConversionDate with ::" separating them. GUID is a common value.
PAYABLENVOICE_PAYABLEINVOICEID	OTM_01, COMMON, EBIZ_01	To maintain the cross-reference between OTM and Oracle E-Business Suite PayableInvoiceID. OTM_01 - <Domain>::<VoucherXid> COMMON AIA GUID EBIZ_01 - INVOICE_ID
PAYABLENVOICE_PAYABLEINVOICEID	OTM_01, COMMON, EBIZ_01	To maintain the cross-reference between OTM and Oracle E-Business Suite PayableInvoiceID. OTM_01 - <Domain>::<VoucherXid> COMMON AIA GUID EBIZ_01 - INVOICE_ID
PAYMENTTERM_ID	EBIZ_01,Common,	This is used to look up the cross-reference values for the payment terms ID. This is used for Retek enhancement.
SUPPLIERPARTY_ADDRESS_ID	EBIZ_01, COMMON	This is used to store the cross-reference for the Address information that exists for a supplier. Common - GUID Oracle E-Business Suite - Site ADDRESS ID. OTM does not have any specific ID for address
SUPPLIERPARTY_CONTACT_ID	EBIZ_01, COMMON, OTM_01	This is used to store the cross-reference for contact information of a supplier. Common - GUID OTM is - Location/Contact/ContactGid/Gid/Xid Oracle E-Business Suite - VENDOR_Contact_ID
SUPPLIERPARTY_ID	EBIZ_01, COMMON, OTM_01	This is used to store the cross-reference for the Supplier ID among the different applications. Common - GUID OTM - LocationGid/DomainName and LocationGid/Xid. EBIZ_01 - VENDOR ID
SUPPLIERPARTY_LOCATION_ID	EBIZ_01, COMMON, OTM_01	This is used to store the cross-reference for Sites that belong to a supplier. Common - GUID, Oracle E-Business Suite - VENDOR_SITE_ID OTM - LocationGid/DomainName and LocationGid/Xid

Table 11-2 lists the Oracle Financial Management cross-references for Customer Party web service.

Table 11-2 Financial Management Cross-References for Customer Party

Name	Column	Description
CUSTOMERPARTY_ACCOUNTID	SEBL_01, COMMON, OTM_01, EBIZ _01	Common is a GUID generated by Business Process Execution Language (BPEL). cross-reference value for OTM is concatenation of common and Domain",::" separating them.
CUSTOMERPARTY_ADDRESSID	SEBL_01, COMMON, OTM_01, BIZ _01	Common is a GUID generated by BPEL. cross-reference value for OTM is concatenation of common and Domain,"::" separating them.
CUSTOMERPARTY_CONTACT_COMMID	SEBL_01, COMMON, OTM_01, EBIZ _01	Common is a GUID generated by BPEL. cross-reference value for OTM is concatenation of common and UseCode,"::" separating them.
CUSTOMERPARTY_CONTACTID	SEBL_01, COMMON, OTM_01, EBIZ _01	Common is a GUID generated by BPEL. cross-reference value for OTM is concatenation of common and Domain,"::" separating them.
CUSTOMERPARTY_LOCATIONREFID	SEBL_01, COMMON, OTM_01, EBIZ _01	Common is a GUID generated by BPEL. cross-reference value for OTM is concatenation of common and Domain,"::" separating them.
CUSTOMERPARTY_PARTYCONTACTID	SEBL_01, COMMON, OTM_01, EBIZ _01	Common is a GUID generated by BPEL. cross-reference value for OTM is concatenation of common and UseCode,"::" separating them.
CUSTOMERPARTY_PARTYID	SEBL_01, COMMON, OTM_01, EBIZ_01	Common is a GUID generated by BPEL. cross-reference value for OTM is concatenation of common and Domain,"::" separating them.
ORGANIZATION_ID	SEBL_01, COMMON, OTM_01, EBIZ_01	This table is used to determine the domain value in OTM from the ORG_ID that is being sent from Oracle E-Business Suite.
PAYMENTTERM_ID	COMMON, OTM_01, EBIZ 01, RETL_01	Common is a GUID generated by BPEL. cross-reference value. TBD. Payment Code is the value of EBIZ_01.