nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Journal Batch/Header Identifier Mismatch in Warehouse Values to Actual Source Values

Juan Hurtado

Is there we can request the Configurable Account Analysis to have a detailed validation component in FAW? Having the ability to compare the metrics amount would be ideal but it will be beneficial for business to have Journal Batch and Journal Header Description as a optional column to compare. Currently there is a mismatch to what is feed to FAW to what is in OTBI.

Find more posts tagged with

FDI Back End

FDI Front End

Data Connectivity

Data Preparation and Flows

FDI

Accepted answers

All comments

Krishna Prasad Kotti-Oracle

Are you looking for Data Validation for Configurable Account Analysis?

Juan Hurtado

Correct, we're looking for Data Validation for the Configurable Account Analysis Subject Area.

Krishna Prasad Kotti-Oracle

Currently, we do not support Data Validation for Configurable Account Analysis. But you can do the following:

Create a report against CAA and GL Details Transactions.

The GL Journal Information should match between Configurable Account Analysis and GL Details Transactions.

Juan Hurtado

Would there be a way to run a report for Journal Batch/Header Identifiers that scans Source Values to Warehouse Values? We currently have mismatches for a report in FAW that we would like to get corrected.

Krishna Prasad Kotti-Oracle

I would recommend you raise a Service request and work with the Support Team to understand and identify the Mismatches.

Juan Hurtado

Okay, thanks.