OBIA 11g: Load Plan Execution Failure ORA-04138: Value larger than specified precision allowed for this column. Fails at Interface named SIL_TimeDimension_MCalWeek445.W_MCAL_WEEK_D
(Doc ID 2026619.1)
Last updated on FEBRUARY 01, 2021
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.2 and later
Information in this document applies to any platform.
HR and Finance load plan execution failing with error ORA-04138: value larger than specified precision allowed for this column. The issue is in the interface named SIL_TimeDimension_MCalWeek445.W_MCAL_WEEK_D
OBIA version: 18.104.22.168.2
The fiscal calendar dimension has a table W_MCAL_CAL_D that stores all the fiscal calendars. Each fiscal calendar is identified by a unique ROW_WID value. The ROW_WID is populated by the sequence called W_MCAL_CAL_D_SEQ. This ROW_WID is special because it is in turn used to populate intelligent ROW_WID for other fiscal calendar tables, such as W_MCAL_PERIOD_D. In those other tables, the data type of their ROW_WID is NUMBER(15,0) with a format of:
- AAAA stands for ROW_WID from W_MCAL_CAL_D for a given calendar (up to 4 digits);
- YYYY is the year in four digits
- MM is the month in two digits
- DD is the date in two digits
- XXX (3 digits) indicates if the period is an adjustment period or not
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