R12: PA: PA Credit Memo Is Missing Multiple Invoice Lines In AR Invoice (Doc ID 1582412.1)

Last updated on NOVEMBER 14, 2023

Applies to:

Symptoms

PA credit memo is missing multiple invoice lines in AR invoice.

STEPS
-----------------------
1. Project has a draft invoice #11 that was interfaced to AR (100740055242).
2. Users then created a canceling invoice (draft invoice #13 - credit memo) for this invoice and it was interface to AR. (100770011499)
3. The credit memo was supposed to fully credit draft invoice #11,but the CM only has a fraction of the lines in it. It is missing a bunch of the lines so the amount is way off.
4. When we look at the canceling credit memo (draft #13) in the PA billing forms, we see that it was originally created for the full invoice amount, but somehow the the AR invoice amount does not match the invoice total.
5. I am not sure if some of these lines were some how deleted from the interface table but there seems to be some missing data.
6. We are looking to get a script to get the system balance because PA and AR not in sync.

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.