Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

During the upgrade we are supposed to use ad_zd_table.upgrade to register Tables, however this proce

edited Aug 20, 2021 10:07AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center