Within Oracle AIA this mechnism is one of the technical foundation on which AIA runs.
The documentaion was limited on this functionality. Some core functions used in stylesheets were explained. Popular cross-reference functions are:
- xref:populateXRefRow() - Insert a record in the XRef table
- xref:markForDelete() - Delete a record from the XRef table
Since Oracle SOA Suite 10.1.3.4, the documentation has improved dramaticly. Detailes description and examples are now documented. It can be found here:
From conceptualpoint of view and almost technical it can be used a reference documentation in olde versions 10.1.3.3 and AIA 2.0.x.
Note that there are some challenges when you use the cross-reference table.
Check that the table has is optimzed for perfomance. That is has to correct indexes and contraints. The latest patches of the Oracle SOA Suite, applies these indexes and contraints.
One question on this cross-reference table is the date format. The table contains two columns that specifies the date since 1 january 1970. You can obtain the correct format as follows:
+ last_modified/86400000), 'dd-mm-yyyy hh24:mi:ss')
+ last_accessed/86400000), 'dd-mm-yyyy hh24:mi:ss')