My Oracle Support Banner

EBS 12.2 ADOP Utility 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:

Oracle Applications DBA - Version 12.2 and later
Information in this document applies to any platform.


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


The ADOP utility 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 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



Developers create custom tables to be applied by 12.2 ADOP using 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 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 tool are listed below:


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


 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.


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

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