ZRGOS01S RESULTS IN ORA-12899 (Doc ID 2076105.1)

Last updated on NOVEMBER 25, 2015

Applies to:

Oracle Health Insurance Policy Administration Data Marts - Version 10.15.1.3 and later
Information in this document applies to any platform.

Symptoms

On acceptance : 10.15.1.3 version, Load


ZRGOS01S results in ORA-12899

ERROR
-----------------------
ERROR: Fout in sys_mapping_util_pck.draai_mapping. Commando: begin

sys_mapping_util_pck.a_map_result := STG_DD2_STG_DP1.main

(p_env =>
  sys_mapping_util_pck.a_map_env , p_audit_id =>
  to_number(:b_arg01)
, p_audit_datum =>
  to_date(:b_arg02,'ddmmyyyy hh24:mi:ss') );
end;

  begin
*
ERROR at line 1:
ORA-12899: waarde te groot voor kolom
"OWBSYS"."OWB$WB_RT_ERRORS"."RTE_STATEMENT" (huidige waarde: 2020,
maximumwaarde: 2000)
ORA-06512: in "OWBSYS.WB_RT_MAPAUDIT", regel 49
ORA-06512: in "OWBSYS.WB_RT_MAPAUDIT", regel 593
ORA-01403: Geen gegevens gevonden.
ORA-06512: in "OWBSYS.WB_RT_MAPAUDIT", regel 2468
ORA-06512: in "OWBSYS.WB_RT_MAPAUDIT", regel 3450
ORA-06512: in "OBD_OWN.STG_DD2_STG_DP1", regel 4948
ORA-06512: in "OBD_OWN.STG_DD2_STG_DP1", regel 9124
ORA-01422: Exact ophalen retourneert meer dan het gevraagde aantal rijen.
ORA-06512: in "OBD_OWN.SYS_MAPPING_UTIL_PCK", regel 1301
ORA-06512: in "OBD_OWN.STG_ZRGOS01S_PCK", regel 1391
ORA-06512: in regel 2


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ZRGOS01S

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