Page 1 of 1

A Problem In Financial Dimension Hierarchy Manager

Posted: Sat Mar 13, 2010 6:58 am
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

+---------------------------------------------------------------------------+"

Posted: Wed Apr 07, 2010 10:37 am
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