BI Publisher (MOSC)

MOSC Banner

Otherwise in Oracle BI Publisher not Working

edited Nov 29, 2019 4:06AM in BI Publisher (MOSC) 2 commentsAnswered

I have the following XML structure from My Data Set:

<DATA_DS<G_1><INVOICE_NUMBER>20005</INVOICE_NUMBER><BATCH_SOURCE_NAME>MIGRATION</BATCH_SOURCE_NAME><CT_REFERENCE/></G_1><G_1><INVOICE_NUMBER>454162</INVOICE_NUMBER><BATCH_SOURCE_NAME>FM Source Number</BATCH_SOURCE_NAME><CT_REFERENCE>454162</CT_REFERENCE></G_1><G_1><INVOICE_NUMBER>455920</INVOICE_NUMBER><BATCH_SOURCE_NAME>FM Source Number</BATCH_SOURCE_NAME><CT_REFERENCE>455920</CT_REFERENCE></G_1></DATA_DS>

I have put the following logic in my RTF Template inside a FOR-EACH in a Table:

<?choose:?><?when://BATCH_SOURCE_NAME='FreightMaster'?><?CT_REFERENCE?><?end when?><?when://BATCH_SOURCE_NAME='FreightMaster-deactivated'?><?CT_REFERENCE?><?end when?><?when://BATCH_SOURCE_NAME='FM Source Number'?><?CT_REFERENCE?><?end when?><?otherwise:?><?INVOICE_NUMBER?><?end otherwise?><?end choose?>
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center