Drill Down to Source Data on Validate Screen is Not Working For A SQL Integration Script Location

(Doc ID 824435.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Financial Data Quality Management - Version: 9.3.1.0.00 and later   [Release: 9.3 and later ]
Information in this document applies to any platform.

Symptoms

Currently I am importing the same set of GL data for two locations. The first location is loading the data using a flat file into the FDM location and the validate process is successful.

The second location is importing the data directly from the Oracle database using a SQL Integration Script. The data imports into FDM successfully, however on validate the validate process returns intersection errors (Invalid intersection) for each line in the source data. When drilling back on the amount in the validate screen, the drill-back screen contains no rows of data and is blank. When clicking on the amount within the import screen and choosing "Show Conversion Rules" the screen it returns is also blank.

Cause

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