E1: ENV: What Is Table F9888 for? OCI0000178, OCI0000179, JDB3500011 F9888 Table Errors When R9830512 UBE Run to Copy Versions Information from One Environment to Another (Doc ID 1265896.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

When you run R9830512 UBE to copy versions information from one environment to another, you see the following messages in the JDE.LOG:

2860/1084 WRK:Starting jdeCallObject Mon Nov 08 19:50:07.328000 dbperfrq.c456       OCI0000178 - Unable to execute - DELETE FROM DEVDTA.F9888 WHERE ( BLJDEPKGNM = :KEY1 )
2860/1084 WRK:Starting jdeCallObject Mon Nov 08 19:50:07.328001 dbperfrq.c462       OCI0000179 - Error - ORA-00942: table or view does not exist
2860/1084 WRK:Starting jdeCallObject Mon Nov 08 19:50:07.328002 Jdb_drvm.c1110    JDB9900170 - Failed to execute db request
2860/1084 WRK:Starting jdeCallObject Mon Nov 08 19:50:07.328003 Jdb_exet.c4889     JDB3500011 - Failed to delete for F9888
2860/1084 WRK:Starting jdeCallObject Mon Nov 08 19:50:07.328004 dbperfrq.c456       OCI0000178 - Unable to execute - INSERT INTO DEVDTA.F9888 (BLJDEPKGNM, BLENHV, BLBLDDTE, BLFCTNM, BLFUNO, BLDS80, BLUPMT) VALUES (:BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7)
2860/1084 WRK:Starting jdeCallObject Mon Nov 08 19:50:07.328005 dbperfrq.c462       OCI0000179 - Error - ORA-00942: table or view does not exist
2860/1084 WRK:Starting jdeCallObject Mon Nov 08 19:50:07.328006 Jdb_drvm.c1110    JDB9900170 - Failed to execute db request
2860/1084 WRK:Starting jdeCallObject Mon Nov 08 19:50:07.328007 Jdb_exet.c6144     JDB3400009 - Failed to perform Insert for F9888


In addition, you will see the following warnings in the R9830512 PDF:

*    "Merge Warning - see log" for every record in R9830512 that has not merged, and there is no log generated in F9888 because TBLE F9888 could not be found.
*    "ERROR (new line) Unable to locate table in specified datasource for section: Merge Log" at the last page of R9830512 PDF since it could not find the F9888 to generate the Merge Log providing the details of the merge warnings in previous section.

There is an Object Librarian record for object F9888, in table F9860, but the table does not exist in the EnterpriseOne database.  What is F9888 table for?

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