Storing the Cross reference data to a custom table - Oracle SOA Suite:
Cross references enable you to dynamically map values for
equivalent entities created in different applications. Cross references are
stored in the form of tables.
Oracle SOA Suite 11g provides the new feature to store the cross
reference data to a custom table instead of storing to a standard XREF_DATA
table, this feature enable as to manage the data properly.
Different tables can be created based on the data like order
data can be stored in XREF_ORDER table and account data can be stored in the
XREF_ACCOUNT. This will improve the performance of populating and looking up
the data whenever the volume of the data is more.
- Right-click the project and select New.
- Select SOA Tier from the Categories section, and then select Transformations.
- Select Cross Reference (XREF) from the Items section.
The screen is different in Oracle SOA Suite 12c to create the custom XREF.
- Click OK.
- In the File Name field, specify the name of the cross reference file.
- In the End System fields, enter the end system names.
- Click OK.