Mass Adjustment Creation via CSV

Until now, the system enabled you to upload adjustment data received from an external source system and create adjustments using the C1-ADUP1 and C1-ADUP2 batches. However, there was no user interface available through which you can upload an adjustment data file and create adjustments from the adjustment records. Now, the system provides a user interface which helps you to upload an adjustment data file.

You can upload an adjustment data file in the CSV format. You need to ensure that the CSV file is in the required format; otherwise, the file will not be uploaded in the system. At present, the system supports only the CSV file format. For more information about the CSV file format, see Mass Adjustment Creation CSV Format.

While uploading an adjustment data file, you need to specify an upload request type which is created using the C1-AdjRequestType business object. All the records are validated before uploading an adjustment data file. During the validation process, the system and custom validations (if any) are executed. If there is any invalid record, the system does not allow you to upload the adjustment data file. The system indicates the reason why the adjustment record could not pass through the validation process. You need to first correct the adjustment record in the CSV file and then upload the adjustment data file.

An adjustment upload request is created when an adjustment data file is successfully validated in the system. You can track an adjustment data file through an adjustment upload request. An adjustment upload request goes through various statuses in its lifecycle. Note that the lifecycle of an adjustment upload request is driven by the business object using which the adjustment upload request is created. An adjustment upload request business object named C1-ADJUPLD is shipped with the product. The mass adjustment creation via CSV feature explained in this document is articulated based on the lifecycle and logic defined in the C1-ADJUPLD business object.

Related Topics

Parent Topic: Oracle Revenue Management and Billing Generic Business Processes