My Oracle Support Banner

Error while Applying Patch 32504748 - GOLDEN GATE CHANGES FOR 19.2.002 Release (Doc ID 2771231.1)

Last updated on APRIL 30, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
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


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