Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question about Metadata Mappings in ERPI

essappMar 25 2011 — edited Jun 18 2013
I have registered my source and target systems, initialzed, setup import formats and locations.

I am now at the metadata mapping part. Now I want to do the following:

- Each dimension in planning is currently populated with all its members, which were loaded using outline load utility. I want to overwrite these hierarchies with the hierarchies from the GL.

How do I do that? Will ERPI automatically overwrite those existing members? Also can someone explain what this paragraph from the user guide means:

"When you perform the next steps to define the hierarchy region starting parent, keep in mind that Planning, Essbase, and Financial Management do not allow members to roll up to the parent under the same root. When extracting, you should specify hierarchies where every node has only one parent. E-Business Suite supports instances where a segment value can rollup to two different parents. "

Comments

Billy Verreynne

Oracle APEX with Oracle ORDS are good alternatives, and are no-cost options too.
ORDS (Java web app) can be run in Apache Tomcat - an Open Source minimal/no-cost option.

Wayne_Duke

@billy-verreynne thanks for this, I have been looking at a number of products that can I could use, but what I seem to remember being at an Oracle event/webinar where there where it was mentioned that as we are paying a forms and report license, we could use some form of Oracle BI publisher without additional cost

Michael Ferrante-Oracle
Answer

To be very clear, Oracle Reports is NOT planned to be desupported at this time. It has merely been deprecated, which is not at all the same as desupported. This simply means that no new features are planned for it going forward unless changes are required to make it compatible with whatever new stack contains it.
The recommended migration is Analytics Publisher (previously BI Publisher). If you already have proper licensing to use Oracle Reports and are using a Supported version, your license includes entitlements to use it (Analytics Publisher), at no additional cost. Refer to the FMW Licensing Guide for a more official reference. Also, contact your Account Representative or Oracle Sales for the latest information.
https://docs.oracle.com/en/middleware/fusion-middleware/fmwlc/
Regarding the use of APEX as a "reporting" tool, I would recommend caution. APEX is not a reporting technology. Although it does have some basic reporting functionality, it may not meet the needs of more complex reporting requirements that can be easily and more appropriately handled by actual "reporting" technologies like Analytics Publisher and others.

Marked as Answer by Wayne_Duke · Apr 14 2021
1 person found this helpful
Wayne_Duke

Hi @michael-ferrante-oracle thanks for the clarification and the information on Analytics Publisher, that was what I remembered you saying, but when we tried asking our accounts team they didn't seem aware of it so the link will be very useful.
With regards to the current state of Oracle reports, I understand we are at the terminal release and reviewing the statement of direction of reports its says "Oracle is not planning any functional enhancements for Oracle Reports in its terminal release, or any subsequent releases, if any." The "if any" intimates that following versions of Oracle forms may not have reports included or am I misunderstanding the statement?

regards
Wayne

@wayne-duke1
I had written a three paragraph lengthy answer to your question then decided it might not be a good idea to share my entire opinion here. Feel free to contact me privately and maybe I can help explain.
In short, a formal commitment has not yet been made regarding the inclusion of Reports in the next FMW release.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 16 2013
Added on Mar 25 2011
#business-intelligence-applications, #financial-data-management, #performance-management-applications
2 comments
393 views