When a workflow transaction is successfully processed, information stored in the interface table is not deleted, and no additional action is required. Users can view the results of the transaction through the workflow transaction interface report. Successful transactions are deleted from the interface table daily.
For users that fail to import, you should:
Examine the audit report from the open interface report.
Identify the failed records and the specific reasons for each failure.
(Optionally) Depending on the reasons, correct the problem as necessary.
Failures may be due to:
A mapping problem between the source data and existing data in PPM.
Missing information that cannot be defaulted.
Other configuration and mapping problems in either the source or in PPM or could be the result of errors in the custom loading program.
For example, if a workflow step is not provided for an execution, the records will fail validation. To correct this, the custom program or procedure that inserts records into the interface table needs to be modified to include this required data.
Note: During the initial implementation of the open interface, the mapping between the third-party source and PPM should be thoroughly reviewed and the load programs thoroughly tested in a testing instance.
It is good practice to monitor executions of the open interface and periodically monitor the import of desired data into PPM.