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.
When approved goal is edited Goal Id in not available in XML_DATA_CACHE of Approval Workflow table
Summary:
Content (required):
Hi Team, we have a requirement to pull the approval status of the goal from transaction console when edited (i.e., A goal is already approved and has entry in HRG_GOALS table. The same goal is now edited once again and it is either in Draft Status or AWAITING APPROVAL status). I have attached xml_data_cache extracted using the below query. It doesn't show goal id. So, question is since xml_data_cahce doesn't have GOAL_ID there is no unique way to identify which goal is edited. DO you have any suggestions?
SELECT a.object_id, a.transaction_id,a.xml_data_cache
Tagged:
0