1. Implementing Goal Management
  2. Extract Performance Goals Transaction Data from Approvals Cache

Extract Performance Goals Transaction Data from Approvals Cache

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.

  1. Run the Extract Goals Transaction Data from Cache process.
  2. Specify the transaction ID of the transaction that you want to recover.
    Tip: You can find the transaction ID in the transaction console.
  3. Submit the process.
  4. When the process completes successfully, open the process log.
  5. The log file has the HDL script with the goal details. Copy this to a .dat file and save it.
  6. Review the .dat file:
    1. You can remove attributes that have no value.
    2. If a CLOB (character large object) field value’s content is greater than 4000 characters, do these steps:
      1. Move the content to a text file.
      2. 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.
      3. Include the text file name in the value of the CLOB field attribute.
    3. 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.

    4. Save your changes.
  7. Generate a .zip file for your .dat file.
  8. Discard the performance goal changes or terminate the submitted goal transaction.
  9. Import the generated .zip file using HDL Import.
    1. 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.
    2. Click Import File.
    3. In the Import File dialog box, click Browse to search for and select the generated .zip file.
    4. Click Submit Now.
  10. If the HDL import and load process completes successfully, validate the imported goals data on the Goals page.