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 FEBRUARY 15, 2019
Applies to:Oracle Applications DBA - Version 12.2.4 and later
Oracle E-Business Suite 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>
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