My Oracle Support Banner

EFPA User Guide Version 8.0 Ambiguous for Mapping Balance Sheet GL Accounts to Reporting Lines (Doc ID 1995994.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA / PFTBI) previously known as Oracle Financial Services Profitability Analytics
Business Intelligence (BI) Applications


The EFPA guide is misleading in the following paragraphs:

Page 5-5, 5-6, 5-7 for version 8.0 describes how to map the balance sheet GL account to reporting line. This mapping is necessary to enable the Ledger Stat data to be populated in "Fact Management Reporting" - which is picked up by the EFPA reports.

There are a few issues with this section:

1. It suggests that the mapping can be done within the "Map Maintenance" section of OFSAA AAI. However, that particular screen does not do that. It only creates a table for the mapping, but does not have any functionality to populate the mapping data into the table REP_LINE_GL_MAP.

2. Even the section where it guides us into populating the mapping data through the database directly is not clear enough. For example, in page 5-7, it says that the column V_MAP_ID should be populated by Map_ID. What is "Map_ID"? This appears nowhere else in the user guide. Also, what is "User Group Name" - which has to be populated into V_Member_3 and what are the appropriate values for this?

3. The names of the columns in this table (REP_LINE_GL_MAP) is very different in v8.0 compared to v6.x, but it's hard to figure that out in the user guide.  A more detailed description of the steps required and the overall design should be provided.

A clarification is required on the above items.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.