Purge Maintenance Records from Interface
External Data Integration Services for Oracle is used to load data into the interface tables of Oracle Fusion Applications from external sources, such as legacy systems and third-party applications.
You can use file-based data import (FBDI) templates to define the data, create an import file, load, and process the imported data. For Oracle Maintenance, this includes data such as installed base assets, maintenance work orders, maintenance work definitions, and product genealogy.
During the upload and import of data into the interface tables, there's a chance that these processes could end in a warning or error status due to issues within the data. The Purge Maintenance Records from Interface process provides the capability to purge this data from the interface tables.
When to Use
The Load Interface File for Import scheduled process is used to load the FBDI derived .ZIP data file into the interface tables. During upload, there could be errors due to required fields, incorrect lookup values, conditional data, and incorrect data format. When this occurs, the data can't be further processed from the interface tables and will remain there until manually purged. The Purge Maintenance Records from Interface process provides the capability to purge this data from the interface tables.
Privileges Required
- Privilege: MNT_PURGE_MAINTENANCE_INTERFACE_RECORDS_PRIV
Specifications
Use these specifications when you run the scheduled process.
| Specification | Description |
|---|---|
| Job Type |
On an adhoc basis, you can run at any time to purge the table of data for a selected import process. On a Scheduled basis, if there is a need to routinely purge the table of data for a selected import process. |
| Frequency | Running the report adhoc for a specific import process is recommended. Users can report import errors and request the purge process to be run. |
| Time of Day | It can be run at any time. However, it is recommended that you suspend the import of data for all file-based data import (FBDI) processes. |
| Duration | Typically, it will take several minutes, depending on the volume of data being created or updated. |
| Compatibility | It is recommended to suspend the import of data for all file-based data import (FBDI) processes while the purge process is run, ensuring it successfully completes. Else, data that was imported but not processed for the import process may be deleted. |
Parameters
You must define at least an interface name to process the report.
| Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required |
|---|---|---|---|---|
| Interface Name | Required | The import process for which you wish to purge interface records. | Interface name using an LOV. | None |
| From Batch | Conditional | The beginning batch number of a range of interface batches. If left blank, then all batches are included. | Batch Number using an LOV. | Yes, From and To should be used together to define a range. |
| To Batch | Conditional | The ending batch number of a range of interface batches. If left blank, then all batches are included. | Batch Number using an LOV. | Yes, From and To should be used together to define a range. |
| From Last Update Date | Conditional | The beginning date of a range of interface batches. If left blank, then all dates are included. | Last Updated Date using a date picker. | Yes, Start and End should be used together to define a range. |
| To Last Update Date | Conditional | The ending date of a range of the interface batches. If left blank, then all dates are included. | Last Updated Date using a date picker. | Yes, Start and End should be used together to define a range. |
| Also Purge Unprocessed Batches | Optional |
Option to include unprocessed batches or not during the purge process. |
Yes or No checkbox selection. Default value is No. | none |
Troubleshooting Information
- Once submitted, you can view the status of the process on the Scheduled Processes UI. A successfully completed process, as well as any child processes, will end in Succeeded status.
- If issues are encountered, the process or any of its subprocesses may be Warning or Error. The specific validation errors and warning messages that prevented the process from completing successfully are displayed in the error log(s).
- Any interactive warning validations are NOT performed.
- When the process is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes UI.