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

When approved goal is edited Goal Id in not available in XML_DATA_CACHE of Approval Workflow table

Received Response


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

Howdy, Stranger!

Log In

To view full details, sign in.


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