Work And Asset Management OUBI Extract Does Not correctly populateThe Extract Flat Files
Last updated on OCTOBER 04, 2013
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.
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