My Oracle Support Banner

E1: PKG: EnterpriseOne 8.12 and 9.0 Package Build on Oracle Database with Security Server (Doc ID 832174.1)

Last updated on JANUARY 07, 2020

Applies to:

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

Symptoms

With the changes in TAM going to metadata tables at the database level in E1 8.12 application release level onwards, the process of building a package requires the creation of new tables for each of the spec files in the database itself versus flat file TAM files in the spec folder in prior releases. 

The issue is that the default permissions for the JDE user for the Oracle database doesn't allow proper premissions to create and grant to objects in the central object schemas like the DV812 schema. The JDE_ROLE that is created during the platform pack for the EnterpriseOne 8.12 and 9.0 application releases has some default permissions, but not enough to build packages when security server is used from the build machine. 

The errors in the log may look like the following during a full package build -->

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.