Purge Negotiation Interface Records
Use the Purge Negotiation Interface Records process to delete records from the negotiation interface tables. These interface tables are used to import negotiation lines for large negotiations.
When to Use
Use this process to purge records from the negotiation interface tables. Before running Import Negotiation Lines process you need to upload records to these interface tables. Also use the process if you've uploaded erroneous records or for periodic cleaning up of interface tables. You can run this process when needed, or schedule periodic runs (daily, weekly, monthly). This process can only be used for large negotiations. A large negotiation must be enabled in the negotiation style.
For more information see Import Negotiation Lines, in the Oracle Fusion Cloud Procurement: File-Based Data Import (FBDI) for Procurement guide.
Privileges Required
- Purge Negotiation Interface Records (PON_PURGE_NEGOTIATION_INTERFACE_PRIV)
Specifications
Review these before setting up this scheduled process:
| Specification | Description |
|---|---|
| Job Type | Ad hoc job. |
| Frequency | Based on your business needs. |
| Time of Day | Based on your business needs. |
| Duration | Depends on the total number of lines and the line level details (external cost factors, quantity-based price tiers, price breaks) being imported. |
| Compatibility |
You can run only one instance of this job at any one time. This job is also not compatible with the process, that is, the application will display an error if you try to run this job when the job is either already scheduled or running for any negotiation:
|
Parameters
| Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required | Notes |
|---|---|---|---|---|---|
| Interface Table | Required | Select the name of the interface table from which the records should be deleted. | For example: All, Lines, External Cost Factors, Quantity based price tiers, Price Breaks Default value: All | None | N/A |
| Records | Required | Select the status of records which needs to be deleted. | For example: All, New, Processed, Rejected, Success Default value: All | None | N/A |
| Load Request ID | Optional | Number or ID of the Load Interface File for Import process whose interface records needs to be purged. | For example: Load Request ID= 50215 | None | N/A |
| Procurement BU | Optional | Specify the name of the Procurement business unit whose interface records needs to be purged. | For example: Vision Operations | None | N/A |
| Negotiation | Optional | Number or ID of the negotiation whose interface records needs to be purged. | For example: Negotiation = 567893 | None | N/A |
| Batch ID | Optional | To delete a specific group of records or line level child entities from the interface table, enter the value of batch ID parameter as available for these records in the interface table. | For example: Batch ID = 123 | None | N/A |
| Purge Data Before | Optional | All records inserted before this date will be purged | For example: Purge Data Before= 30-Dec-2022 | None | N/A |
Troubleshooting Information
- The output file generated once the process is completed will specify the number of records purged in each table along with any validation messages.
- If the purge process fails, all records that were previously purged during the execution of the job are restored, so you can run the process again to purge the records.