Build bip template when xml have nested levels

Question

Summary

Content

Hi All

I am trying to build an age analysis template from the Aging from the Aging - 7 Buckets - By Account Report. The xml is attached and the template thus far built. The results of the template as it stands now is correct however I only want data extracted for two of the INV_TID. I am getting all the records for all INV_TID's (Accounts).

The problem is that the INV_TID values lies in an upper level in the xml layout and it is only presented once for each INV_TID (Account)

You will see there are multiple INV_TID's and for each one the listed customers and there balances. As example I only want all the customer data as in my template that relate to INV_TID 01 00 00 000 60150 000 000 and 01 00 00 000 60154 000 000.

All other records should not pull into the data results.

How can I achieve this?

Any help would be most appreciated.

Thanks

Cheryl

Version

BIP 12.2.1.4.0

Age Analysis v2.rtf

Chez · Answer

Thank you for your post Suresh. I was however able to achieve what I wanted with the following command. <?if:number(../../SORT_FIELD2)<2000 and TOTAL_CUST_AMT != ''?>

Regards

Cheryl

User910243567 · Answer

You can try Conditional Formatting and use IF Condition to display only values corresponding to INV_TID values you desire. Though INV_TID is at higher level you can fetch value for the same into your for each group. Something like this... Fields you want to display Refer below for this https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-04477E49-F671-4BF1-8353-06A7CDEAD2CC.htm#BIPRD2481