Work And Asset Management OUBI Extract Does Not correctly populateThe Extract Flat Files (Doc ID 1385251.1)

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***

Goal

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.



Solution

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