Planning ODS Load Completes With ORA-14097 After Patch 21680334 When TDE (Transparent Data Encryption) Has Been Enabled in RDMBS For Tablespace APPS_TS_TX_DATA
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.
On a Centralized VCP 126.96.36.199 Instance, the customer applied <Patch 21680334>:
The 'Planning ODS Load' still completes with the following error:
P_table_name = MSC_SUPPLIES
06-OCT 12:51:33 : st:EXCHANGE_SINGLE_TAB_PARTN MSC_SUPPLIES
06-OCT 12:51:33 : exchange part:-ALTER TABLE MSC_SUPPLIES EXCHANGE PARTITION
SUPPLIES__1 WITH TABLE SUPPLIES_GLO INCLUDING INDEXES WITHOUT VALIDATION
06-OCT 12:51:33 : ORA-14097: column type or size mismatch in ALTER TABLE
06-OCT 12:51:33 : Fatal Error in Exchange Partition.
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