Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
DocumentsOfRecordEO psValue Meaning/ Mapping
Summary:
Mapping/ Meaning for DocumentsOfRecordEO psValue
Content:
Support doc https://support.oracle.com/epmos/faces/DocumentDisplay?id=2692905.1 refers to different functions to extract data from the XML_DATA_CACHE. Specifically we are looking at extracting documents of records data and using a statement like
<SELECT * FROM TABLE(per_bipntf_utility.extractXMLSequenceForEO(transaction_id, 'DocumentsOfRecordEO', psvalue))>
For this we need to determine which psvalue to use in the statement and we would need to understand what the psValues maps to logically. E.g. what does a psValue of 0 or 2 represent. We are thus looking for a mapping of psValue to more meaningful values.
1