My Oracle Support Banner

E1: XMLP: Report Definition Is In Status "FR" And XMLP Kernel Log Shows "JDB_FetchKeyed F95620 failed with rcode=1 " After Upgrading To Tools Release 9.2.6 And When Using Multiple Environments (Doc ID 2865294.1)

Last updated on APRIL 28, 2022

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.


After upgrading Tools release to, when submitting a Report Definition, in an environment sharing the same pathcode with other environments, the RD is in status FR- Report Definition Invalid, and the following error appears in the XMLP kernel log:

The select statement for the Report definition should be done on F95620, but for the custom environment.

In this scenario, the issue can be reproduced at will with the following steps:
1. Upgrade TR to
2. Submit a Report Definition from P95620 application.
3. Notice the Report Definition is failing in Status FR.


 Upgrade Tools release to 9.2.6.


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.