Work And Asset Management OUBI Extract Does Not correctly populateThe Extract Flat Files
(Doc ID 1385251.1)
Last updated on JULY 14, 2019
Applies to:Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.
***Checked for relevance on 04-OCT-2013***
When performing the load process in OUBI using an extract file from WAM the Fact table CF_OP_ACTG did not contain any records..
The the data file OP_ACTG_EXT the column FISCAL_CAL_CD is blank. This column should have values that refer to entries in the dimension CD_FISCAL_CAL. Since the values are blank in the extracted file the association to the dimension is not possible and hence the records are being rejected.
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