Adoption Premium Benefit Waiver

Oracle Revenue Management and Billing enables you to waive off premium of an adopted child or adult while billing the individual memberships. However, the adoption waived off premium is not recorded and maintained in ORMB for the General Ledger (GL) posting unless you do the following:

  • Set the Adoption Waiver Credit Calculation Applicability option type of the C1-ASOBLLNG feature configuration to Y.

  • Set the required SQIs in the New Born Waiver SQI, New Born Waiver Credit SQI, and New Born Distributed SQI option types of the C1-ASOBLLNG feature configuration.

Note: The SQIs given in the New Born Waiver SQI, New Born Waiver Credit SQI, and New Born Distributed SQI option types are used for both newborn and adoption premium benefit waiver.

The system calculates the premium for the adoption premium waiver period and stores the amount in the billable charge when an adopted member person exists in the individual membership and the adoption gift days applicability for the individual membership is set to Yes. The system stamps two SQIs in the billable charge - one SQI stores the adoption premium (i.e., debit amount) and another SQI stores the adoption premium waiver benefit (i.e., credit amount). This mechanism ensures that the system records the adoption premium in the system, but at the same time does not charge the adoption premium for the membership. It helps to maintain GL entries for the adoption premium which is waived off during premium calculation.

While deriving the eligible members for an individual membership or while deriving the subscription tier for an individual membership, the system derives the list of eligible members for the membership or subscription tier for the membership, respectively, considering with and without adoption gift days. If a tier-based pricing rule is referred for an individual membership, the system will set the following characteristics for the individual membership:

  • Subscription Tier – Stores the subscription tier for the membership considering adoption or newborn gift days.

  • Subscription Tier without Gift Days – Stores the subscription tier for the membership without considering adoption or newborn gift days.

While calculating premium for an individual membership, the system checks whether there is an adopted member person in the individual membership and the Gift Days Applicability parameter in the adoption business rule is set to Y. If the Gift Days Applicability parameter in the adoption business rule is set to Y, the system derives the adoption gift days from the adoption business rule and calculates the adoption gift period start and end dates.

While deriving the timeline during premium calculation, the system checks whether the timeline is within the adoption gift days period. If the timeline is within the adoption gift days period, the system calculates the premium for the adopted person and creates a record in the CI_​PRCE_​CALC_​LN table where the NEW_​BORN_​CMT_​FLG column is set to Without Gift Days. In addition, the system creates a reverse entry record in the CI_​PRCE_​CALC_​LN table where the NEW_​BORN_​CMT_​FLG column is set to Reversal. If the amount calculated with and without gift days do not match, the system stamps two SQIs in the billable charge - one SQI stores the adoption premium (i.e. debit amount) and another SQI stores the adoption premium waiver benefit (i.e. credit amount). The system considers the SQIs specified in the New Born Waiver SQI and New Born Waiver Credit SQI option types of the C1-ASOBLLNG feature configuration, respectively.

During premium proration, the system stores the distributed amount for the adopted member person in an SQI that is specified in the New Born Distributed SQI option type of the C1-ASOBLLNG feature configuration.