Image
Netsuite-PBSC integration

NetSuite to PBCS - Cloud integrations

Persis Vuppula
January 4, 2020

NetSuite manages the business finances, operations, and customer relations. Oracle (Planning & Budgeting Cloud Services) PBCS facilitates the financial planning with modeling capabilities, approval workflows and reporting. Integrating NetSuite with PBCS provides one collaborative scalable solution for an Enterprise.

NetSuite PBCS Sync SuiteApp in the NetSuite allows to extract the accounting reports. This SuiteApp is a managed bundle, helps in defining the saved Searches with the data required for Planning and Budgeting. This App can be installed from NetSuite customizations by searching for “Oracle NetSuite PBCS Sync”. Guided steps will install the SuiteApp successfully.

As in most of the Applications a Single sign on, password encryption, Token-Based Authentication and custom saved searches are all possible.

After a successful installation of SuiteApp, a PBCS Menu item appears on the NetSuite Menu bar which helps to navigate to the PBCS Application. Set the PBCS URL in the NS_Config file in the NetSuite.

Data Management plays a major role in integrating the data. Go to the setup and Register the Source Application. Provide a drill through URL for data drill down.

Initialize, Configure Source Connection and Test the connection.

After a successful Connection, Navigate to Target Applications. All the PBCS saved searches from NetSuite are listed under Target Application Summary. Select Target with the Type as Planning. A complete setup is done automatically. Refresh Metadata and Refresh Members when necessary.

Now the integration setup and Workflow mappings can be done for each target application of type data source with Category Mappings, Period Mappings, Locations and Import Formats, Data load rules and Data load mappings as followed in general for any Integrations. Saved Searches can be downloaded from NetSuite to understand the type of data. A calendar mapping must be taken care based on the NetSuite Accounting Periods.

After all setups and Configurations, load the Metadata and data for Planning, Budgeting, Forecasting, What-if & Variance Analysis, Predictive Analytics etc. Financial Reporting and Adhoc Reports using SmartView.

Persis Vuppula, Sr.Analyst

Persis Vuppula joined Jade Global in 2017. She is responsible for providing enterprise solutions to Jade Global customers within the Financial Planning and Analytics (FP&A) team. Her areas of expertise include financials, workforce, CapEx & Projects Planning. She helps customers achieve strategic goals using Oracle Enterprise Planning & Budgeting Cloud Services including Oracle PBCS and EPBCS.

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.