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.
How to get Total Compensation Statement values through a BI Report
Summary:
We are trying to build a BI Report to get the Total Compensation Statement values which are defined in the system. We need to fetch the details in a Tree structure (Statement -> Categories -> Sub Categories -> Items) same as defined in the system.
We tried below tables to get the Statement and Categories details. But we are not able to fetch the Categories which are linked under the Statement as defined in frontend.
CMP_TCS_STMT_CAT
CMP_TCS_STMT_VL
CMP_TCS_CAT_VL
CMP_TCS_PER_PERD_STMT_XML
Please let us know if there is a way to find which categories are tagged under which Statements and which Items are tagged under which Categories through BI Report.
0