Defer Upload Request Validation

Until now, the system enabled you to upload data for the following using the Upload Request feature:

  • Billable Charge (Adhoc and Regular)

  • Hold Request

  • Refund Request

  • Write Off Request

  • Derivation and Pricing Parameters for a Bill Group and Sort ID Combination

The system faced performance issues while validating a CSV file uploaded through the Upload Request feature when the CSV file had voluminous records. Therefore, now the system has introduced defer processing mechanism while validating a CSV file. The defer processing mechanism for the validation process is introduced for the following business objects:

  • C1-BillableChargeUploadRequest

  • C1-HoldUploadRequest

  • C1-RefundUploadRequest

  • C1-WriteOffUploadRequest

  • C1-BillLevelUploadRequest

Two new statuses named Validating and Deferred Validation are added in the lifecycle of the above business objects. Now, when you click the Validate button, the system changes the status of the upload request to Validating. The system then invokes the C1-DEFERVALD algorithm which is attached to the Validating status. It checks whether the total number of records in the upload request exceeds the online record validate limit defined in the C1-DEFERVALD algorithm. If the total number of records in the upload request does not exceed the online record validate limit, all records in the upload request are validated immediately and its record status is changed to Valid or Invalid depending on whether it is successfully validated or not. Finally, the status of the upload request is changed to Validated.

However, if the total number of records in the upload request exceeds the online record validate limit, the status of the upload request is changed to Deferred Validation. On executing the C1-UPLRQ batch, the system checks whether there are any upload requests in the Deferred Validation status. If there is an upload request in the Deferred Validation status, all records in the upload request are validated in the deferred mode and its record status is changed to Valid or Invalid depending on whether it is successfully validated or not. Finally, the status of the upload request is changed to Validated.