C1-BLVLVALID

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

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

  • All mandatory information is available in the bill group derivation and pricing parameters record.

  • Either the bill group (person) identifier type and bill group (person) identifier or the bill group (person) ID is available in the bill group derivation and pricing parameters record.

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

  • The number of characters specified in each field does not exceed the maximum field length.

  • A bill group with the specified bill group ID exists in the system.

  • 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 which is specified in the Person Relationship Type option type of the C1-ASOBLLNG feature configuration.

  • A duplicate record with the source system, parameter 1, parameter 2, parameter 3, parameter 4, and effective date combination does not exist in the C1_​BILL_​LVL table.

  • A duplicate record with the source system, parameter 1, parameter 2, parameter 3, parameter 4, and effective date combination does not exist in the C1_​UPLOAD_​REQ_​DTLS table.

  • The source system exists in the extendable lookup which is specified in the Source System Extendable Lookup parameter.

  • The bill group sort record with the bill group ID and sort ID combination already exists in the system.

  • The effective date specified in the record is within the date range of the effective bill group sort record.

If the above mentioned validations are successful, the status of the record in the C1_​UPLOAD_​REQ_​DTLS table is changed to Valid. However, if any of the above validation fails, the status of the record in the C1_​UPLOAD_​REQ_​DTLS table is changed to Invalid.

It contains the following parameter:

  • Source System Extendable Lookup - Used to specify the source system extendable lookup business object. The bill group derivation and pricing parameters records should contain the source system which is already defined in this extendable lookup.