E1: PKG: Spec Tables Not Deleted During EnterpriseOne 8.12 Package Deletion - Oracle Database - Error: PKGENG0036 - Failed To Delete Package Spec Repository
Last updated on NOVEMBER 15, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
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.
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.
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