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

Last updated on JULY 17, 2017

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

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