Receipt Accrual (PO_RECACCR) is Reversing All Prior Period Rows again in RECV_LN_ACCTG after a Receipt is Matched or Canceled also Causing Performance Issues for Journal Generation (Doc ID 1605541.1)

Last updated on JANUARY 13, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

After a Receipt is Matched, Receipt Accrual reverses RECV_LN_ACCTG rows on all past Accounting Periods causing performance issues with Receipt Accrual (PO_RECACCR) and Journal Generator and reverses original rows with the Expense entry in the period received.

Steps to recreate the issue:

  1. Create a PO and dispatch. PO has receiving and matching required.
  2. Create a receipt.
  3. Run Receipt Accrual. Expense entries created in current period and Accrual entries created in next period. This is correct.
  4. Run Receipt Accrual again. Accrual entries are reversed in current period and created in next period. This is correct.
  5. Run Receipt Accrual again. Accrual entries are reversed in current period and created in next period. This is correct.
  6. Create voucher against the receipt.
  7. Run matching. Voucher and receipt are matched.
  8. Run Receipt Accrual again. See that all previous rows have been reversed again, including the original rows with the Expense entry in the period received. This is incorrect.

 This results is many unnecessary rows being created, causing performance issues when running Receipt Accrual and Journal Generator.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms