Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 data from an xmltype column

in Reporting and Analytics for ERP 5 comments

Summary:

How to extract data from an xmltype column that is in the table ZX_CONDITIONS

Content (please ensure you mask any confidential information):

I am trying to put in place a datamodel that reads off the ZX_CONDITIONS table. I need to have the columns CONDITION_GROUP_CODE and the <value> that lies within the XMLTYPE coumn .FLEX_FILTER_VALUE. How do I write the sql statement that will pull out these two columns

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Application 23C (11.13.23.07.0)

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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