C1-BLSRTVALD

This algorithm is invoked when the user clicks the Validate button. It validates the records which are in the Pending status. It validates the following:

  • The bill group (i.e., person) ID given in the record is valid.

    Note: If the bill group ID is invalid, it derives the bill group ID using the respective bill group (i.e., person) identifier type and bill group (i.e., person) identifier combination. Once the bill group ID is derived, the corresponding record is updated in the C1_​UPLOAD_​REQ_​DTLS table. If the system could not derive the bill group ID using the bill group identifier type and bill group identifier combination, the status of the record in the C1_​UPLOAD_​REQ_​DTLS table is changed to Invalid.

  • The parent customer's person type is set to Parent Customer in the system.

  • The end date is not earlier than the start date and the start date is not later than the end date.

  • The bill group identifier type is available when the bill group identifier is specified in the record and vice versa.

  • The bill group is the child person of the parent customer.

  • The bill group's person type is set to Bill Group in the system.

  • The relationship between the bill group and parent customer is effective on the system date.

  • The bill group is related to the parent customer using the relationship type that is specified in the Person Relationship Type option type of the C1-ASOBLLNG feature configuration.

  • A duplicate record with the bill group ID and sort ID combination does not exist in the C1_​BILL_​LVL table.

  • The two or more records with the same bill group ID and sort ID combination do not exist in the upload request.

    Note: If duplicate records exist in the upload request, it validates and changes the status of one record to Valid and the status of the remaining records to Invalid.

If any of above validations fail, the status of the record in the C1_​UPLOAD_​REQ_​DTLS table is changed to Invalid. However, if all the above validations are successful, the status of the record in the C1_​UPLOAD_​REQ_​DTLS table is changed to Valid. Once all the pending records in the upload request are validated, the status of the upload request is changed to Validated.

Note: If there are no pending records while validating an upload request, a message appears indicating that there are no records to be validated. In such case, you can only delete an upload request.