My Oracle Support Banner

E1: 03B: E1PAGE: P03B202X|W03B202XH - Top 10 Customers By Open Amount - UXOne Screen Displays "Still Receiving Invalid JSON from JAS after 3 tries" Message with ORA-01795 Error in E1root Log (Doc ID 2886225.1)

Last updated on JULY 28, 2022

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
JD Edwards EnterpriseOne Accounts Receivable - Version 9.2 and later
Information in this document applies to any platform.


When trying to run P03B202X|W03B202XH against a query which returns large data set, it displays the message - "Still Receiving Invalid JSON from JAS after 3 tries.".  This chart is based on the One View Customer Ledger Inquiry program (P03B2022). In a specific case, it works when the query returns about 15K records in P03B2022. It does not work when query returns more than 30K records and displays the mentioned message. It is the same issue if P03B202X|W03B202XH is directly accessed from fastpath or if it is accessed within the Accounts Receivable Manager UXOne page.

Below error messages are captured in e1root log of the html instance:

Steps to replicate:

  1. Make sure that P03B2022 has more than 30K records for over 1000 customers
  2. Create an advanced query to select those many records
  3. Access P03B202X W03B202XH from fastpath
  4. Select the query added in step 2




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

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