My Oracle Support Banner

EAR 9.2: Missing PS_AR_CC_TRAN_HDR Records From AR_REV_EST after Unpost of Item (Doc ID 2476938.1)

Last updated on MARCH 09, 2020

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 Image #21
AR Update - Posting

Receivables Revenue Estimate process (AR_REV_EST) inserted rows into PS_AR_CC_TRAN_TBL but not into PS_AR_CC_TRAN_HDR.  PS_ITEM_ACTIVITY.ARRE_STATUS was also update to 'P' (Processed).
Navigating to Accounts Receivable > Customer Accounts > Item Information > View/Update Item Details on the "Item Accounting Entries" tab, clicking the "Revenue Estimate" link results in an error.

ERROR
-----------------------

No matching buffer found for level. (15,26)
When retrieving data for a page, a data value was retrieved for which there was no matching data value at a higher level scroll entry. (For example, at scroll level 2, a value of ABC was read in and scroll level 1 contained this higher level field but did not have a row with a key value of ABC.) This usually occurs because of an error in a database record or view; or because of improper deletion of values in a database. Correct the page definition or contact your system administrator.


STEPS
-----------------------
The issue can be reproduced at will:
1. Create 2 items, one with invalid budget check chartfield
2. Run AR Update (one item will post)
3. Run Journal Generate
4. Unpost the Item Group
5. Open Revenue Estimate link returns error

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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