You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to extract "XML Delivery Status" of "Manage Transactions" Screen in an SQL query

edited Oct 5, 2023 7:50AM in Receivables & Collections 4 comments

Hi,


I need to extract the information of the "XML Delivery Status" that is in "Manage Transactions" Screen in SQL for a customised report.

I have not found it in any Oracle documentation, although I have already found many other useful information.

I only found by myself that the possible values of this field are in the lookup called XML_DELIVERY_STATUS.


For example, for the transaction in screenshot, I get some information of the transaction header with :

select * from ra_customer_trx_all where trx_number ='23079714389'.


But this does not provide the "XML Delivery Status".

Can you tell me where this information is stored for a given transaction ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!