CF_PAY_TNDR Fact Failed While Loading Data
(Doc ID 2653777.1)
Last updated on MARCH 30, 2020
Applies to:
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.1.0 and laterInformation in this document applies to any platform.
Goal
On : 2.7.0.1.0 version, Install / Upgrade
CF_PAY_TNDR fact failed while loading data
While loading data to CF_PAY_TNDR fact job failed the following error:
ORA-01400: cannot insert NULL into ("DWADM"."CF_PAY_TNDR"."ACCT_KEY")
Steps to replicate:
1. Ensure that for a pay id multiple FT's are present in CI_FT table with FT type flag as 'PX'
2. Load associated pay tender and verify the result
Solution
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
Goal |
Solution |
References |