Sometimes a performance goal transaction that’s submitted for approval may get stuck.
As administrators, you can recover data of such goal transactions from the approvals cache.
You need to run the Extract Goals Transaction Data from Cache
process which generates an HCM Data Loader (HDL) script. You can copy this to a
.dat
file. Review the .dat
file and update the
success criteria and comments data if needed. Upload the file to recover the goals
transaction data.
-
Run the Extract Goals Transaction Data from Cache
process.
-
Specify the transaction ID of the transaction that you want to recover.
Tip: You can find the transaction ID in the transaction console.
-
Submit the process.
-
When the process completes successfully, open the process log.
-
The log file has the HDL script with the goal details. Copy this to a
.dat
file and save it.
-
Review the
.dat
file:
-
You can remove attributes that have no value.
-
If a CLOB (character large object) field value’s content is greater
than 4000 characters, do these steps:
- Move the content to a text file.
- Change the field name in the METADATA line to the corresponding
Goal business object attribute name for the CLOB field. For
example. change
CommentsText
to
CommentsFile
,
SuccessCriteriaText
to
SuccessCriteriaFile
, and
LongDescription
to
LongDescriptionFile
.
- Include the text file name in the value of the CLOB field
attribute.
-
If a CLOB field value’s content is less than 4000 characters, you can
change the CLOB column field names in header to the corresponding
non-CLOB column field name. For example, you can change
CommentsText
to Comments
and
SuccessCriteriaText
to
SuccessCriteria
.
For LongDescription
, because
Description
is already an attribute, treat it
as a CLOB field with greater than 4000 characters and do the steps
outlined in Step 6b.
-
Save your changes.
-
Generate a
.zip
file for your .dat
file.
-
Discard the performance goal changes or terminate the submitted goal
transaction.
-
Import the generated
.zip
file using HDL Import.
-
On the Tasks panel tab of the Data Exchange work area, select
Import and Load Data.
You can see the Import and Load Data page.
-
Click Import File.
-
In the Import File dialog box, click Browse to
search for and select the generated
.zip
file.
-
Click Submit Now.
-
If the HDL import and load process completes successfully, validate the
imported goals data on the Goals page.