E1: PKG: Spec Tables Not Deleted During EnterpriseOne 8.12 Package Deletion - Oracle Database - Error: PKGENG0036 - Failed To Delete Package Spec Repository (Doc ID 657758.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

In EnterpriseOne 8.12 using Oracle database, when a package is deleted from Package Build P9621 / Package Assembly P9601 applications from the EnterpriseOne fat client machine, the Package Spec tables are not deleted from the database.  The following errors appear in the JDE.LOG.  

5160/368 WRK:Starting jdeCallObject         Tue Sep 18 11:14:54.666001 dbperfrq.c449
OCI0000178 - Unable to execute - DROP TABLE DV812.F98762DVMP0005
5160/368 WRK:Starting jdeCallObject         Tue Sep 18 11:14:54.682001 dbperfrq.c455
OCI0000179 - Error - ORA-01031: insufficient privileges 
5160/368 WRK:Starting jdeCallObject         Tue Sep 18 11:14:54.682003 Jdb_drvm.c982
JDB9900401 - Failed to execute db request
5160/368 WRK:Starting jdeCallObject         Tue Sep 18 11:14:54.682005 Jdb_exem.c1563
JDB9900827 - Failed to drop table F98762

. . . [More DROP TABLE error messages for other Spec Tables]

5160/368 WRK:Starting jdeCallObject         Tue Sep 18 11:14:55.869025 spkgeng.c1136
PKGENG0036 - Failed to delete package spec repository.

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