EDI Manager Integrity
The following table describes the audit queries and resolutions for this area:
| Query | Description | Resolution |
|---|---|---|
|
ECINMPFL-1 |
Inbound work records that are not found in the PSRECDEFN table. |
Either modify the inbound map definition to not use the Inbound Row ID Work Record (ECINMAPFILE), or create the Work Record Definition. |
|
ECINMPFL-2 |
Inbound work record EC Map ID is not found in the PS_ECMAPDEFN table. |
Create an entry in the map definition table (ECMAPDEFN). |
|
ECINMPFD-1 |
Inbound work record fields are not found with valid EC Map ID and EC File Row ID combination from the PS_ECINMAPFILE table |
Either remove the invalid map ID from the Inbound Work Record (ECINMAPFLD), or create an Inbound Row ID Work Record entry. |
|
ECINMPFD-2 |
Inbound work record fields from PS_ECINMAPFLD are not found in PSRECFIELD |
Either remove the invalid entry in the inbound work record or create the record/field definition. |
|
ECINMPRC-1 |
Target inbound records are not found in the PSRECDEFN table |
Either modify the inbound map definition to not use the Inbound Row ID Target Record (ECINMAPREC), or create the Work Record Definition. |
|
ECINMPRC-2 |
Target inbound EC Map ID is not found in the PS_ECMAPDEFN table |
Either remove the invalid map ID from the Inbound Row ID Target Record or create an entry in the Map Definition table. |
|
ECINMPRF-1 |
EC Map ID/EC File Row ID combination is not found in PS_ECINMAPREC for the target inbound record field in PS_ECINMAPRECFLD |
Remove the invalid map ID from the Inbound Target Record. |
|
ECINMPRF-2 |
A Field for a Record in PS_ECINMAPRECFLD was not found in PSRECFIELD |
Create the appropriate definitions in PSRECFIELD or remove the invalid map ID from the Inbound Target Record. |
|
ECINMPRF-4 |
A related record in PS_ECINMAPRECFLD is not found in PSRECDEFN |
Either create the record definition or remove the reference to the related record in the Inbound Target Record. |
|
ECINMPRF-5 |
An EC Related Record in PS_ECINMAPRECFLD does not have a valid EC Related Row ID from PS_ECINMAPREC |
Either remove the reference to the related record from the Inbound Target Record or create an appropriate entry in the Inbound Row ID Target Record. |
|
ECINMPRF-6 |
A related field in PS_ECINMAPRECFLD is not found in PSRECFIELD |
Either remove or correct the reference to the related field record from the Inbound Target Record or create the correct definition in PSRECFIELD. |
|
ECOTMPRC-1 |
Target outbound records are not found in the PSRECDEFN table |
Either modify the outbound map definition to not use the Outbound Target Record, or create the record definition. |
|
ECOTMPRC-2 |
Outbound work record EC Map ID is not found in the PS_ECMAPDEFN table |
Create an entry in the map definition table. |
|
ECOTMPRC-3 |
Parent records from the outbound work record are not found in the PSRECDEFN table |
Remove the reference to the parent record or create a record definition for the parent. |
|
ECOTMPRC-4 |
File records from the outbound work record are not found in the PSRECDEFN table |
Create a record definition for the file record. |
|
ECOTMPFD-1 |
Outbound work record fields are not found with a valid EC Map ID and EC File Row ID combination from the PS_ECOUTMAPREC table |
Either remove the entry from the Outbound Work Record (ECOUTMAPFLD) or create an entry in the Outbound Target Record (ECOUTMAPREC). |
|
ECOTMPFD-2 |
Outbound work record fields from PS_ECOUTMAPFLD are not found in PSRECFIELD |
Create the appropriate definitions in PSRECFIELD or remove the invalid map ID from the Outbound Work Record. |
|
SYSECMGR-1 |
Inbound work record field does not exist in the type definitions in PSDBFIELD |
Select, PeopleTools, EDI Manager, Setup Trading Partners, Remove EDI Manager Objects. In the Delete EC Map field, delete all maps except the following:
|