Data Model Upload Not Altering the Custom Stage Table with New Columns (Doc ID 3001420.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Symptoms

Unable to add new columns in the existing custom Stage table. But it is trying to drop and re-create the same primary key.

From Model Upload Log:

----------------------------------------------
STARTED DROPPING PRIMARY KEYS
----------------------------------------------
Dropping the Primary Key stg_xxx_xxx.sql
Dropped the Primary Key stg_xxx_xxx.sql
adding primary key to execution orderAlter table stg_xxx_xxx add CONSTRAINT PK_1101 PRIMARY KEY (fic_mis_date,d_account_open_date,v_acct_number)----------------------------------------------
STARTED ADDING PRIMARY KEYS
----------------------------------------------
Adding Primary Key for the tablestg_xxx_xxx.sql
Added the Primary Key stg_xxx_xxx.sql

No errors in the Model Upload log file and ETLService.log.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.