My Oracle Support Banner

Sales Journal By GL Account Report (XML) Report Output Shows "No Data Found" After Patch 22565802 (Doc ID 2233909.1)

Last updated on MAY 12, 2021

Applies to:

Oracle Receivables - Version 12.2 and later
Information in this document applies to any platform.
ARSJGLARPT: Sales Journal by GL Account Report (XML)
xlarpjel.pkb

Symptoms

Sales Journal by GL Account Report (XML) report returns:

No Data Found

Note: The issue is reproduced in file version : xlarpjel.pkb 120.68.12020000.31 (which is delivered via Patch 22565802) and higher (till version 120.68.12020000.35 as on date).

Steps To Reproduce:

  1. Responsibility: Receivables Manager
  2. Navigate to : View > Requests > Submit a New Request
  3. Submit the Concurrent Program "Sales Journal by GL Account Report (XML)" by passing required parameters
  4. Check the Report Output once Program Completes
  5. Report Output shows "No Data Found"

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
 Step1.  Enable the parameter P_PERIOD_FROM P_PERIOD_TO
 Step2. Verify the two new parameters
 Step3. Click on List of Values for both new Parameters; Make sure you have already selected Ledger.
 Step4. If in step3 You can see only one value in the LOV for the newly parameter added. Then follow below step.
 Step5. Now run the report “Sales Journal By GL Account Report (XML)”

Now pass the appropriate values in Period From and To along with the GL date parameters and it fetches the desired data.
 Final Result
References


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