During the upgrade we are supposed to use ad_zd_table.upgrade to register Tables, however this proce
We have about 50 custom tables that are 'External' tables. Defined as something like this.
CREATE TABLE "XX"."XX_CST_ITEM_CST_STG"
( "ORGANIZATION_CODE" VARCHAR2(50 BYTE),
"ITEM_NUMBER" VARCHAR2(81 BYTE),
"COST_TYPE" VARCHAR2(50 BYTE),
"COST_ELEMENT" VARCHAR2(50 BYTE),
"USAGE_RATE_OR_AMOUNT" VARCHAR2(50 BYTE)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY "XX_DEST_DIR"
ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ","
MISSING FIELD VALUES ARE NULL )
LOCATION
( 'No Cost HMLK PN_Org 7_20140915_145226.csv'
)
)
REJECT LIMIT UNLIMITED ;
When we run: EXEC ad_zd_table.upgrade('XX','XX_CST_ITEM_CST_STG'); to register the table during the upgrade we are getting the following error.