Skip to Main Content

SQL Developer

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!

SQL Worksheet in Oracle Developer 4.1

3309371Jun 14 2017 — edited Jun 14 2017

Hi,

I am using Oracle SQL Developer 4.1 and everytime I launch a new sql worksheet it gets pinned to the left hand side just above my connections navigator.

Is there way oracle sql developer remembers or allows you to set the sql worksheet positing in the oracle sql developer?

Many Thanks

pastedImage_0.png

This post has been answered by thatJeffSmith-Oracle on Jun 14 2017
Jump to Answer

Comments

Francisco Amores

Hi,

just to confirm how the integration process works with SAP integration.

When you integrate SAP with FDMEE data will be extracted to a flat file in shared folder called FSMOUNT (typically located in the FDMEE server). The extract process is basically an ABAP program executed by ODI Agent. Then the ODI agent will take this file and import into FDMEE. Shared folder must be declared in SAP (Transaction AL11)

You need to ensure that the shared folder must be accessible from the SAP system using the <sid>adm user and from the operating system user that starts the ODI agent.

In the ODI Topology, you will have to configure Data Serve "FDMEE _SAP_FSMOUNT" to point the shared folder.

Regarding drill through, FDMEE will open the drill through url you configure in FDMEE depending on your requirements. You will have to enable ITS Server Version 6.2 or higher (Internet Transaction Server) so you can navigate your SAP instance through the web. FDMEE source adapter for SAP comes with some predefined drill through urls (including parameters) based on the SAP module you integrate.

I hope that clarifies.

user8628169

Thanks Francisco.

Correct me if I am wrong, the pre-built SAP adapter which comes with FDMEE is for SAP BW and not for SAP G/L. Does this adapter also provides the ability to drill through to transactional data ?

Francisco Amores

FDMEE supports both SAP ECC 4.6+ / R3 (ERP Financials) and SAP BW.

So you can integrate SAP GL modules (NEWGL and Classic GL) and others:

  • General Ledger
  • Profit Center
  • Cost Center
  • Vendor Balances
  • Customer Balances

For SAP BW, it extracts data from standard as well as custom infocubes.

Integration includes data load and drill through for all SAP integration.

Regards

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

Post Details

Locked on Jul 12 2017
Added on Jun 14 2017
2 comments
218 views