EBS 12.2 ADOP Utility xdfgen.pl Does Not Handle 12c Advanced DDL Definition Options for Custom Tables And Indexes in .xdf Files
Last updated on SEPTEMBER 25, 2017
Applies to:Oracle Applications DBA - Version 12.2 and later
Information in this document applies to any platform.
EBS ATG 166/XDF
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
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:
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.
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