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

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.

Symptoms

On a Centralized VCP 12.2.4.1 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
EXCHANGE PARTITION
06-OCT 12:51:33 : Fatal Error in Exchange Partition.

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