Cross references are used to dynamically populate, maintain and map values for equivalent entities created by different applications.
Create New SOA Project
Create Cross Reference (XREF)
Create Above Table Structure In SOA-INFRA DB
Create BPEL Process
MODE: ADD & LINK
ADD: Used to add the new row.
LINK: Used to link the extra column to existing column based on Primary Key.
Testing:
Fetch Existing Data
Testing:
MODE: UPDATE
Testing:
Create New SOA Project
Create Cross Reference (XREF)
Create Above Table Structure In SOA-INFRA DB
Create BPEL Process
MODE: ADD & LINK
ADD: Used to add the new row.
LINK: Used to link the extra column to existing column based on Primary Key.
Testing:
Fetch Existing Data
Testing:
MODE: UPDATE
Testing:
I have followed exact steps but getting this error: {"RestFaultElement":{"summary":"An error occurs while processing the XPath expression; the expression is xref:populateXRefRow(\"MyXref.xref\",\"tokenType\",\"EBS100\", \"Token\",\"CM001\",\"ADD\")","code":"XPath expression failed to execute","detail":"XPath expression failed to execute.\nAn error occurs while processing the XPath expression; the expression is xref:populateXRefRow(\"MyXref.xref\",\"tokenType\",\"EBS100\", \"Token\",\"CM001\",\"ADD\")\nThe XPath expression failed to execute; the reason was: oracle.fabric.common.xml.xpath.XPathFunctionException: Invalid metadata for Cross Reference Table \"MyXref.xref\"\nPlease ensure the metadata confirms to the XSD.\nCheck the detailed root cause described in the exception message text and verify that the XPath query is correct.\n"}}
ReplyDelete