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 (Doc ID 2165520.1)

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.

Symptoms

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.

 

ERROR

-----------------------
java.sql.SQLException: ORA-14020 this physical attribute may not be specified for a table partition

STEPS
-----------------------
xdfcmp.pl xxdev/<xxdev passwd>@dev11 /global/scripts/custom/xxdev_company.xdf apps/<apps passwd>


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