OBIA 18.104.22.168 How do you resolve the DAC Task Failing for PS_SIL_BenefitFact_Full Load Into Benefit Fact?
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124 and later
Information in this document applies to any platform.
- Using Source Siebel 126.96.36.199 patchset 6, OBIA Subject Area Public Sector-Case Management the PS_SIL_BenefitFact_Full Load Task is failing in DAC with WRT_8229 ORA-01400: cannot insert NULL into ("BI_DEV_USER"."W_BENEFIT_F"."BENEFIT_NUM")
- In Table S_BNFT_PLAN_ITM, Column BENEFIT_NUM in Siebel this is inactive but in OBIA data warehouse this column is required and is not NULLABLE.
- Since this is an OOTB task and no changes have been made what is the best way to resolve this issue?
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