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:
For more information about cross-references, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack.
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. |