12.2 E-Business Suite xdfcmp.pl Fails with Error 'ORA-14020 this physical attribute may not be specified for a table partition' When Executed Against a Table Defined with SUBPARTITION Clause
Last updated on NOVEMBER 17, 2016
Applies to:Oracle Applications DBA - Version 12.2.4 and later
Oracle Applications Technology Stack - Version 12.2.4 and later
Information in this document applies to any platform.
When following the below document to create an editioned database object, where the table is created with SUBPARTITION clause:
<NOTE 1577661.1> Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2
The step to execute xdfcmp.pl against a composite partitioned table to create a batch file (xdf file) errors, with 'ORA-14020 this physical attribute may not be specified for a table partition'.
Note: The error only occurs when the XDF file being created is based on a table defined as a composite partitioned table. It will not error if it is based on a table defined with partition only.
java.sql.SQLException: ORA-14020 this physical attribute may not be specified for a table partition
xdfcmp.pl xxdev/<xxdev passwd>@dev11 /global/scripts/custom/xxdev_company.xdf apps/<apps passwd>
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms