My Oracle Support Banner

EAR 9.2: Aging Detail by Department (AR30009 Report) Does Not Include Eligible Item Transactions if PS_ITEM.CONTRACT_NUM Record Field Is Empty (Doc ID 3016815.1)

Last updated on APRIL 16, 2024

Applies to:

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

Symptoms

A problem has been detected with the Aging Detail By Department report (AR30009 SQR) where eligible transactions will not be included if no Contract Number value exists, (Record Field PS_ITEM.CONTRACT_NUM).

REPLICATION STEPS:

   1.- Log into the FSCM Online Application as a Receivables User
   2.- Navigate to: Accounts Receivable > Pending Items > Online Items > Online Item Group Entry
   3.- Create a new Pending Item Group under the Business Unit, and Customer value desired, and add a transaction
   4.- Go to the Accounting Entries tab, and manually generate the Accounting Lines for both Item rows, and proceed to add Department ID 12345 details on all rows
   5.- At the Group Action tab, set the Post Action to Batch Standard
   6.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
   7.- Launch AR_UPDATE AE Program for the Business Unit at hand, and Pending Items option selected
   8.- Navigate to: Accounts Receivable > Receivables Analysis > Aging > Aging by Department Report
   9.- Create a new Run Control ID with the below values needed:
           - As of Date
           - SetID
           - Aging ID
           - Department ID = 12345
           - Customer ID
           - Business Unit
   10.- Click on RUN button
   11.- Select the AR30009 SQR Report
   12.- Click on OK button
   13.- PROBLEM: Review the generated PDF file, and confirm that the report is empty

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the problem.

Employees are confused by the empty results obtained by the Aging Detail by Department PDF file (AR30009 Report), as there are outstanding transactions that exist for the selected Customer ID and Department combination.

Even if FIN Contracts module is not used, or the Item transactions do not contain any Contract Number value, the Aging Detail by Department report (AR30009 SQR Report), should list the outstanding transactions by aging brackets.

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.