E1: 42: Sales Update (R42800) Error 078F (Insert Failure in F03B11T) (Doc ID 2036483.1)

Last updated on NOVEMBER 09, 2016

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

Sales Update (R42800)

After taking the fix for Bug 21191743 (for FASB/IASB Revenue Recognition Enhancement),Sales Update (R42800) fails with Error 078F (Failed to perform insert in F03B11T) when processing an order with installment payments. The error is issued by business function AcctRecFSEndDoc (B03B0011) on line 1510.

  1. Create a Sales Order with Customer Payment Terms P2 (Installment Payments)
  2. Ship confirm the Order
  3. Invoice the Order
  4. Run Sales Update (R42800)
  5. Job ends with message "Invoice has not processed" on the PDF.
  6. Logs show the Error 078F (Failed to perform insert in F03B11T) issued by business function AcctRecFSEndDoc (B03B0011) on line 1510.
  7. F03B11T is the Invoice Tag Table, a new table added for the FASB/IASB Revenue Recognition Enhancement.
  8. If an order is processed with payment terms of blank, or any non-installment payment terms, the error does not occur.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms