A Problem In Financial Dimension Hierarchy Manager

Here you can post the Business Intelligence (BI) related queries and replies.
Post Reply
oracle.consultant
Posts: 1
Joined: Wed Feb 24, 2010 5:36 am
Location: Egypt

A Problem In Financial Dimension Hierarchy Manager

Post by oracle.consultant »

Dear All
I've a problem in Financial Dimension Hierarchy Manager
When I run the Request Set Status Completed:Error


And In the log file

"+---------------------------------------------------------------------------+
Some local value sets defined in Dimension Mapping Rules for this dimension have not been mapped to the master value set using Financial Dimension Hierarchy Manager (FDHM).
For more information, please view output file.
Debug Off
Delete_LVS_Records -> phase: Delete FII_FIN_ITEM_HIER_GT
Delete_LVS_Records: ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
<x FII_FIN_CAT_MAINTAIN_PKG.Delete_LVS_Records() 13-MAR-10 12:25:57
Init_Load -> phase: Delete FII_FIN_ITEM_HIER_GT
Other error in FII_FIN_CAT_MAINTAIN_PKG.Init_Load: ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
<x FII_FIN_CAT_MAINTAIN_PKG.Init_Load() 13-MAR-10 12:25:57
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...


Finished executing request completion options.

+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Manager encountered an error while attempting to start your immediate concurrent program &PROGRAM. Routine &ROUTINE received a return code of failure.

Contact your support representative.
Concurrent Request for "Load Financial Category Dimension" has completed with error.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 13-MAR-2010 12:25:59

+---------------------------------------------------------------------------+"
erpramesh
Posts: 4
Joined: Tue Nov 04, 2008 7:56 am
Location: India

Post by erpramesh »

Hi,

You need to Map Local values to Master value set In order to view Company or cost center based reports in DBI financial Intelligence.

All you need to do is.. create one more value set for cost center and company, assign these in finance dimension set up window under financial dimensions tab to relavent dimension. do not take existed value set (which we have accounting flexfield for GL) create same like as another value set(same copy value set) and assign those as i mentioned above.

now open FDHM for company, costcenter etc.. then assign master value and child value for each segment.

and ran the dbi finance and clear summaries reqst set

still u got error and any confusion,,, shoot a mail to me with screenshot brb991@yahoo.co.in


Thanks
Ramesh
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests