Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Transaction data without approval not fetching all the data

Received Response
31
Views
2
Comments
Prerna Singhania-88645
Prerna Singhania-88645 Rank 1 - Community Starter
in Oracle Analytics Forum

Summary

Transaction data without approval not fetching all the data

Content

Hi All

We are fetching data from xml using hrc_txn_data .

We are using below mwthod to extract value from the xml for each attributes , but sometimes it is giving data and sometimes for few transaction it is giving null even if data exists in the table.

extractvalue( xmltype('<root>'||txndata.data_cache||'</root>'),

'root/TRANSACTION[1]/BUSINESSDATA[1]/AM[1]/TXN[1]/EO[1]/PeriodOfServiceEORow[1]/CEO[1]/EO[1]/EmployeeTermsDEORow[1]/CEO[1]/EO[1]/EmployeeAssignmentDEORow[1]/ActionCode[1]/DATA[1]')

Please advise urgently!

Thanks

Answers

  • timdexter
    timdexter Rank 6 - Analytics & AI Lead

    Hi

    Is this in the context of a BI Publisher report? If so, does the query work outside of BIP consistently?

    Can you reproduce the issue at will ie with a specific transaction?

    All BIP is doing at runtime is handing the query over to the DB for execution. Its prolly worth running the report with the debugger on to see whats going on.

    Regards

    Tim

  • Prerna Singhania-88645
    Prerna Singhania-88645 Rank 1 - Community Starter

    Hi Tim

    yes this is related to BIP Reports, I am not sure if this is working outside BIP as I dont have access to check that.

    Do we have any specific format which is valid for BIP?

    Thanks