ORACLE NETSUITE – ORACLE EPM CLOUD Integration

 
NetSuite Adapter
https://docs.oracle.com/middleware/12213/adapter-netsuite/using-netsuite-adapter/GUID-C7EBFF8A-13CF-4F5A-ABAE-5032E9A31386.htm

Oracle NetSuite Adapter Capabilities
https://docs.oracle.com/en/cloud/paas/integration-cloud/netsuite-adapter/oracle-netsuite-adapter-capabilities.html

Integrating Oracle NetSuite
https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/erpia/netsuite_intro_100xbda13a64.html

Using the Oracle NetSuite Adapter with Oracle Integration
https://docs.oracle.com/en/cloud/paas/integration-cloud/netsuite-adapter/preface.html#GUID-7E890AB2-AA82-4D33-82FC-0080971DB08B

Getting Started with the Oracle NetSuite Adapter
https://docs.oracle.com/en/cloud/paas/integration-cloud-service/icsns/getting-started-oracle-netsuite-adapter.html

Using the Oracle NetSuite Adapter with Oracle Integration
https://docs.oracle.com/en/cloud/paas/integration-cloud/netsuite-adapter/using-oracle-netsuite-adapter-oracle-integration.pdf

Youtube
https://www.youtube.com/embed/vX3RGihxXO0?rel=0&autoplay=1

Other Links
https://system.eu2.netsuite.com/pages/customerlogin.jsp
https://brovanture.com/connecting-two-clouds-netsuite-to-oracle-pbcs-cloud-to-cloud-integration/
https://netsuitehub.com/forums/topic/saved-search-for-ytd-sales/

Oracle EPM FCCS - ICP Eliminations - points to remember

In preparing consolidated financial statements, we need to eliminate transactions between companies or entities included in the group for consolidation and only report results arising out of transactions with third parties. This is achieved through intercompany elimination.

To perform Intercompany Elimination in Oracle Financial Consolidation and Close Cloud Service (FCCS) below pre-requsites should be met,

Prerequisites to perform intercompany eliminations in Oracle Financial Consolidation and Close Cloud Service (FCCS)

1. Intercompany feature should be enabled while creating the application.
2. Account must be set as an Intercompany account.
3. The account must have a Plug account assigned to it.
4. Entity must be set as an Intercompany entity.
5. Run a consolidation.
6. Intercompany transactions are eliminated automatically after running consolidation in Oracle Financial Consolidation and Close Cloud Service (FCCS).

How to extract Alias details using EPM Cloud Data management in EPBCS/PBCS/FCCS Applications

Now it is possible to extract a member of a dimension and its Alias information using EPM Cloud Data management in EPBCS/PBCS/FCCS Applications.

Follow the process to use the option > Data Export to File, A target application gets created as Data Target type and complete the setup process,

For extracting the Alias - which is part of metadata use the below SQL command to extract the details 

Like Mapping -- * to #SQL 

(

SELECT DISTINCT ALIAS FROM AIF_TARGET_APPL_MEMBERS WHERE UDX = MEMBER_NAME 

)

--- Note: Replace UDX with the actual UD number from the target application dimension class.