Original ITEM_EFFECTIVE_DT Retained During Payment Swapping Creates an Issue with Accounting Lines Created (Doc ID 2394983.1)

Last updated on APRIL 23, 2019

Applies to:

Symptoms

On  Campus Solutions  the original ITEM_LINE_SF.ITEM_EFFECTIVE_DT is used when a credit swaps from one account type to another.  There may be several lines, each with a unique line sequences for the same item number on ITEM_LINE_SF. An increase in the credit amount may have a different ITEM_LINE_SF.ITEM_EFFECTIVE_DT.  The accounting lines created for the increases, with an ITEM_EFFECTIVE_DT representative of when the increase occurred, are for the correct accounting period.  However, the accounting lines created when the payment swaps, utilizing the original  ITEM_LINE_SF.ITEM_EFFECTIVE_DT,  are often in a prior accounting period.

ACTUAL BEHAVIOR
---------------
Payment swapping from the item number after an increase in the amount, evidenced by an increase in the amount on ITEM_LINE_SF, uses the original ITEM_EFFECTIVE_DT to be used on accounting lines for any excess amount.

EXPECTED BEHAVIOR
-----------------------
The ITEM_EFFECTIVE_DT of the most recent posting to the credit item should be retained for accounting lines for the excess.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Post an increase amount for a credit.  The credit item was originally posted to the account on an earlier date;
3. Payment swapping occurs;
3. The reduction row on ITEM_LINE_SF uses the original item effective date and not an effective date reflective of the date the transaction occurred;
4. Upon posting to the new account type, the ITEM_LINE_SF.ITEM_EFFECTIVE_DT has the original item effective date of the credit;
5. Accounting lines for the transactions for the reversal and repost reflect an accounting date in the past.

Changes

Cause

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