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 21, 2020
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.
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