12.2 E-Business Suite Online Patching ADOP Utility xdfgen.pl Does Not Handle Some Advanced 12c Table Options, When Creating DDL Definitions For Custom Tables To Be Migrated Between Instances As A Patch Via .xdf Files (Doc ID 2289184.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Applications DBA - Version 12.2 and later
Information in this document applies to any platform.
EBS ATG 166/XDF

Symptoms

E-Business Suite 12.2 Applications DBA, Online Patching ADOP Utilities issues

 

 

The ADOP utility xdfgen.pl is a 12.2 tool supplied by EBS ATG to identify and recreate custom tables in a development environment by creating a custom patch with the DDL statements in .xdf file format.


ADOP then uses xdfcmp.pl on the target production environment to create the custom table in an Online Patching lifecycle, reading the DDL in the .xdf file as discussed in the following document:

<Note 1577661.1> - Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2

 

Issue

Developers create custom tables to be applied by 12.2 ADOP using xdfgen.pl so their custom tables are generated automatically via ADOP using the custom patch .xdf file.

However when attempting to apply the custom patch in an online patching session, they received various different errors or inconsistent results.

Reviewing the DDL generated by xdfgen.pl there are many options that were not taken into consideration.  

For example the various advanced options that were not included in the DDL statements created by the xdfgen.pl tool are listed below:


Errors

DEFAULT ON NULL >>  will generate standard DEFAULT option

SYS.ANYDATA >> ORA-19001: Invalid storage option specified

GENERATED ALWAYS AS () >> ORA-00904: invalid identifier

GENERATED ALWAYS AS IDENTITY  >> sequence code is not included in .xdf

CLUSTER >> Exception occured :null

COMMENT ON COLUMN.. IS '開発コード' >> Unable to apply XSLT transformation on the xml file; Exception occured : 6-byte UTF8 encoding not supported.

GLOBAL PARTITION BY RANGE >> ORA-00926: missing VALUES keyword

Changes

 Developers following <Note 1577661.1> to create a custom ADOP patch are using more advanced 12c table options in their custom table definition.

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