ZRGOS01s Gives ORA-20102 On STG_PRE_STG_PTN_V After Installing 10.14.2.6.21 (Doc ID 2055956.1)

Last updated on SEPTEMBER 15, 2015

Applies to:

Oracle Health Insurance Policy Administration Data Marts - Version 10.14.2.6 to 10.15.1.4 [Release 10.14 to 10.15]
Information in this document applies to any platform.

Symptoms

On test: 10.14.2.6 version, Load

When attempting to run ZRGOS01S after installing 10.14.2.6.21
the following error occurs.

ERROR
-----------------------
ERROR at line 1:
ORA-20102: Fatale fout in mapping STG_PRE_STG_PTN_V. Het laadproces wordt
afgebroken.
ORA-06512: in "OBD_OWN.SYS_MAPPING_UTIL_PCK", regel 1348
ORA-06512: in "OBD_OWN.STG_ZRGOS01S_PCK", regel 1760
ORA-06512: in regel 2


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. install 10.14.2.6.21
2. run ZRGOS01S

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create acurate reports

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms