How Are Deposit Payments Applied to ADM_APPL_DEP Rows When Using A Deposit Fee To Calculate Two Installments? (Doc ID 3038806.1)

Last updated on AUGUST 06, 2024

Applies to:

Goal

A deposit fee is setup to calculate two installments for the deposit fee.  Each installment amount has a unique due date.  For example, for a Fall Term, a deposit calculated from January 1 to May 1 prior to the term start date will have two rows in ADM_APPL_DEP.  One row, for 25% of the deposit amount is due 25 days after the deposit it calculated.  The second for, for 75% of the deposit amount, is due in July.  This graduated due date structure on the deposit fee setup defines installment.

How is ADM_APPL_DEP.RECEIVED_AMT maintained when a student makes a partial deposit payment, and when the student pays an amount in excess of the total deposit amount?  The deposit installment with the earliest due date must have any payment applied to it first.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.