Transaction data without approval not fetching all the data

Question

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(''||txndata.data_cache||''), '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

Prerna Singhania-88645 · Answer

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

timdexter · Answer

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