My Oracle Support Banner

E1: 90CB: Fetch From Table F0116 Failed (Error 078I) When Converting Lead To Opportunity (Doc ID 2588631.1)

Last updated on NOVEMBER 07, 2022

Applies to:

JD Edwards EnterpriseOne Sales Force Automation - Version 9.2 and later
Information in this document applies to any platform.


When attempting to convert a lead to an opportunity on an existing customer using the Convert Lead button in Lead Entry (90CB010) to create a new record in the CRM Customer table (F90CA080), the following hard error is displayed:

The error is being set by the Check Company Match (B90CB032) Business Function on line 378 of the code. The table “Address By Date” (F0116) is where the fetch fails to occur. The existing customer's Address Book Number is 21415 and it does exist in the “Address By Date” (F0116) table so the error should not occur.

  1. A new sales lead is created using Lead Entry (90CB010).
  2. After the lead is created the user reenters the Lead Entry (90CB010) program and clicks on the “Convert Lead” button.
  3. The Fetch from table F0116 failed (Error ID 078I).
  4. The user checks the Address By Date” (F0116) table in the databrowser and notices the record was added to the table.




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.