Reviewing Transformation Error Information
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
FT_ERR_LOG_REVIEW |
Review transformation errors for inbound and outbound processes. |
|
|
FT_ERR_DATA_REVIEW |
Review the details for a specific error. |
|
|
FT_ERR_LOG_RPT |
Generate reports listing the errors for a specific transformation process instance. |
Use the Transformation Error Review - Error Summary page (FT_ERR_LOG_REVIEW) to review transformation errors for inbound and outbound processes.
Navigation
Image: Transformation Error Review - Error Summary Page
This example illustrates the fields and controls on the Transformation Error Review - Error Summary page.
Display Criteria
Use the fields in this group box to filter and sort the errors that the system displays in the Error Summary group box.
|
Field or Control |
Definition |
|---|---|
| Integration Type |
Select whether you want to view errors for Inbound or Outbound processes. If you select Inbound, the Run ID field becomes available. |
| Run ID |
Enter a specific run ID for which you want to view errors. Note: This field applies to inbound errors only. It represents the Fusion Workforce Compensation process run ID. |
| Run Control ID |
Enter a specific run control ID for which you want to view errors. |
| Process Instance |
Enter a specific process instance for which you want to view errors. |
| Error Type |
Select the type of errors you want to view. Possible values are: Unable to load DVM map Duplicate Content Item Name Unable to map the DVM value(s) Employee with multiple jobs Entire object bypassed Missing reference object Multiple Salary Bases Position override Reference to object in error Unable to load XREF map Unable to map the XREF |
| Map Name |
Enter a specific value map for which you want to view errors. |
| Show Summary by Object |
Select to group the errors in the Error Summary group box by Integration Object. This check box is selected by default. If you deselect it, the system groups the errors by Map Name and Source Value(s). In addition, deselecting this check box causes the Integration Object and Show Required Fields Only to become unavailable. |
| Integration Object |
Select a specific integration object for which you want to view errors. |
| Show Required Fields Only |
Select to view only those errors that have a value of Yes in the Required column. |
| Display Summary |
Click to display the errors that meet your selected display criteria. |
| Clear Display |
Click to hide the Error Summary group box. |
Error Summary
This group box displays all errors that meet your selected display criteria when you click the Display Summary button.
|
Field or Control |
Definition |
|---|---|
| Error Type |
Lists the type of error. Possible values are: Unable to load DVM map Duplicate Content Item Name Unable to map the DVM value(s) Employee with multiple jobs Entire object bypassed Missing reference object Multiple Salary Bases Position override Reference to object in error Unable to load XREF map Unable to map the XREF |
| Map Name |
Lists the name of the value map associated with the error. If this name is displayed as a link, you can click it to access the Domain Value Map Page. |
| Source Value(s) |
Lists the original source value associated with the error. |
| Integration Object |
Lists the integration object associated with the error. The integration object represents the type of data being processed and whether it was outbound or inbound. |
| Source Record |
Lists the table that originally contained the data associated with the error. |
| Required |
Indicates whether the error row is associated with data that is required in order for the integration object to be sent to Fusion. If the value for a row is No, the system sets the target value to Null and allows the associated integration object to be sent to Fusion. Rows with a value of Yes (sometimes referred to as “hard errors”) prevent the system from sending the associated integration object to Fusion. |
| Error Count |
Lists the actual number of errors associated with an error row in the summary. |
| Error Data |
Click this link for an error row to access the Error Data page. |
Understanding Transformation Errors
The following table provides explanations of the transformation errors that the FT_EXTRACT process can generate.
|
Transformation Error |
Explanation |
|---|---|
|
Unable to load DVM map |
This error type is for future use. |
|
Duplicate Content Item Name |
Two JPM Catalog Item rows have the same Catalog Item Type (JPM_CAT_TYPE) value. The system bypassed these rows and did not send them to Fusion. |
|
Unable to map the DVM value(s) |
While loading data into the .DAT output files, the process found no Fusion DVM map values that corresponded to the values set in the Populate Domain Value Maps page for a PeopleSoft object value. For example, let us assume that the LEGAL_ENTITY_XREF DVM has map values defined for the following companies: PSI, CWB, HX1, and GBI. While loading the .DAT files, the FT_EXTRACT process encounters a row of data with a company value of ACC. The process logs this row of data with the Unable to map the DVM value(s) error type. |
|
Employee with multiple jobs |
The process encountered an employee with two or more active jobs (PeopleSoft HCM accommodates employees with multiple jobs, but Fusion does not). |
|
Entire object bypassed |
One of the object rows, for example, Department, Location, or Assignment contained an error that forced the process to bypass it. Fusion cannot load incomplete data, so even if only one of the object rows contained an error, the system bypassed the entire object and all of its rows to avoid sending incomplete data to Fusion. |
|
Missing reference object |
The process encountered an object that references another object that is missing and/or has not been part of the migration process. |
|
Multiple Salary Bases |
An employee’s current active row included two or more compensation rows (PeopleSoft HCM accommodates employees with multiple compensation rows, but Fusion does not). |
|
Termination row updates |
The process encountered an employee with an action row before a termination row on the same day. In this case, the process sends only the termination row to Fusion. |
|
Position override |
The process encountered an employee with overridden Position data. |
|
Reference to object in error |
A current row for an object contained a reference to an object that is to be bypassed and there is a reference to this object in another object. |
|
Unable to load XREF map |
This error type is for future use. |
|
Unable to map the XREF |
While loading data into the .DAT output files for an object the process found no GUID for an object referenced by the original object. |
Use the Transformation Error Review - Error Data page (FT_ERR_DATA_REVIEW) to review the details for a specific error.
Navigation
Click an Error Data link on the Transformation Error Review - Error Summary page.
Image: Transformation Error Review - Error Data Page
This example illustrates the fields and controls on the Transformation Error Review - Error Data page.
This page displays all of the information displayed on the Error Summary page for the error row along with the Source Key Value(s) for the error, which you can use to locate the row in the source record.
Use the Transformation Error Report page (FT_ERR_LOG_RPT) to generate reports listing the errors for a specific transformation process instance.
Navigation
Image: Transformation Error Report Page
This example illustrates the fields and controls on the Transformation Error Report page.
|
Field or Control |
Definition |
|---|---|
| Integration Type |
Select whether you want to generate a report for an Inbound or Outbound integration. |
| Process Instance |
Enter the instance number of the process for which you are generating an error report. |
| Error Type |
Select the Error Type for which you want to generate the report. Only error types logged for the selected process instance are available to select. |
| Group By |
Select whether you want the report to group your results by Business Unit, Department, or Location. This field is available only if you select a report type of Detail. |
Report Type
You can use this page to generate two types of reports: Summary or Detail.
|
Field or Control |
Definition |
|---|---|
| Summary |
Select to generate a report that lists the error types that the process generated along with counts of rows that resulted in errors. |
| Detail |
Select to generate a report that provides detailed information on all of the entities that generated errors. |