My Oracle Support Banner

E1: BSFN: After Calling Business Function RetrieveDistributionAAI Why is There Sometimes No SQL Select Statement But Only a JDB_OpenTable and Then a JDB_Fetchkeyed Seen in Debug Log? (Doc ID 2569662.1)

Last updated on JULY 25, 2019

Applies to:

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

Goal

A custom application is calling the Business Function RetrieveDistributionAAI (B4000350 - F4095 Retrieve Distribution AAI). From the Call Object Kernel Debug log, it is found that sometimes when this business function is called, system will do an SQL SELECT statement to fetch the record from the F4095 table. However, sometimes there is no SQL SELECT statement seen.

Sometimes SQL SELECT Statement can be seen


Why is this there no SQL SELECT Statement issued sometimes?

Solution

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
Goal
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.