Error while Applying Patch 32504748 - GOLDEN GATE CHANGES FOR 19.2.002 Release
(Doc ID 2771231.1)
Last updated on FEBRUARY 20, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 to 19.2 [Release 19.0 to 19.2]Information in this document applies to any platform.
Symptoms
After the upgrade at source side to 19.2.0.2 and while doing import getting the below errors for two tables.
ORA-39083: Object type TABLE:"PLSTOCKRMSDAS"."SA_GL_REF_DATA" failed to create with error:
ORA-02289: sequence does not exist
Failing sql is:
CREATE TABLE "PLSTOCKRMSDAS"."SA_GL_REF_DATA" ("STORE_DAY_SEQ_NO" NUMBER(20,0) NOT NULL ENABLE, "STORE" NUMBER(10,0) NOT NULL ENABLE, "DAY" NUMBER(3,0) NOT NULL ENABLE, "ACCT_DATE" DATE NOT NULL ENABLE, "PROCESSED_DATE" DATE NOT NULL ENABLE, "CURRENCY_CODE" VARCHAR2(3 BYTE) NOT NULL ENABLE, "SET_OF_BOOKS_ID" NUMBER(15,0), "UPDATE_ID" VARCHAR2(254 BYTE), "TOTAL_VALUE" NUMBER(20,4) NOT NULL ENABLE, "TOTAL_ID" VARCHAR2(10 BYTE) NOT NULL ENABLE, "ATTRIB1" VARCHAR2(30 BYTE), "ATTRIB2" VARCHAR2(30 BYTE), "PERIOD" VARCHAR2(15 BYTE), "REFERENCE_TRACE_ID" VARCHAR2(32 BYTE) NOT NULL ENABLE, "ID" NUMBER(28,0) DEFAULT "RMS01"."SA_GL_REF_DATA_ID_SEQ"."NEXTVAL" NOT NULL ENABLE) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "RETAIL_DATA"
ORA-39083: Object type TABLE:"PLSTOCKRMSDAS"."MONTH_DATA_ERRORS" failed to create with error:
ORA-02289: sequence does not exist
Failing sql is:
CREATE TABLE "PLSTOCKRMSDAS"."MONTH_DATA_ERRORS" ("DEPT" NUMBER(4,0), "CLASS" NUMBER(4,0), "SUBCLASS" NUMBER(4,0), "LOC_TYPE" VARCHAR2(1 BYTE), "LOCATION" NUMBER(10,0), "TRAN_CODE" NUMBER(4,0), "ADJ_CODE" VARCHAR2(1 BYTE), "TOTAL_COST" NUMBER(20,4), "TOTAL_RETAIL" NUMBER(20,4), "POSTED_TO_GL" VARCHAR2(1 BYTE), "ORIG_ERR_INSERT_DATE" DATE, "ERROR_SOURCE" VARCHAR2(100 BYTE), "ID" NUMBER DEFAULT "RMS01"."MONTH_DATA_ERRORS_ID_SEQ"."NEXTVAL" NOT NULL ENABLE) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "RETAIL_DATA"
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |