OIC XSLT - Dynamic XPath Mapping in Oracle Integration: Handling Nested Transactions | use of current() function

Use Case Description:

Scenario:

In an integration process, we need to map and extract the ChequeNumber from a specific PaymentRecord dynamically based on the TransactionNumber of the stub account record. The mapping ensures that the correct record is retrieved by comparing the current TransactionNumber in context with the corresponding field in the source data.

Challenge:

Accurately identify and map the ChequeNumber when dealing with nested data structures, ensuring consistency and correctness in dynamic XPath expressions.

Solution:

Use the following XPath expression to achieve this:

$ReadSourceFile/nsmp0:ReadResponse/ns25:Payments/ns25:PaymentRecord[ns25:TransactionNumber=current()/ns25:TransactionNumber]/ns25:ChequeNumber

This approach ensures that the integration maps only the ChequeNumber for the record where the TransactionNumber matches the current context.

Note:

within a template, current() allows you to explicitly reference the node that is being processed without needing to specify its path. This can be helpful when working with recursive templates or when you want to access the current node while traversing through XML documents.