EBS 12.2 ADOP Utility xdfgen.pl Does Not Handle 12c Advanced DDL Definition Options for Custom Tables And Indexes in .xdf Files (Doc ID 2289184.1)

Last updated on MAY 16, 2024

Applies to:

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 attempting to use more advanced 12c table definition options in their custom table definition.

Cause

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