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.
BIP Report - Goals - Employee Sumbission Date and Manager Approval Date
Summary:
Customer asks to modify existing BIP GOAL report by adding two more columns with values New Goal Submission date of Employee and Manager approval Date of this goal.
Content (required):
I would like to ask you, if there is existing report or any manual how to map Goals to these two dates information. I tried to use tables HRC_TXN_HEADER TRR, HRC_TXN_DATA, HRC_TXN_HEADER_ARCHIVE, HRC_TXN_DATA_ARCHIVE. I found the dates in HRC_TXN_DATA and HRC_TXN_DATA_ARCHIVE as submission_date and completed_date however I faced here two complications:
- I do not know how to uniquely specify record in HRC_TXN_DATA so I used Subject_ID from HRC_TXN_HEADER and Goal_ID as Extractvalue from HRC_TXN_HEADER.XML_DATA_CACHE column. Is this correct approach ? The reason why I done this is that Object_ID and Subject_ID in HRC_TXN_HEADER are both filled by person_id.
Tagged:
0