Adding Import Formats for Oracle NetSuite Data Sources

A NSPB Sync SuiteApp Saved Search is stored as a data source, and import formats enables you to set up the integration mapping between the data source and the dimensions of your target application in Oracle Enterprise Performance Management Cloud.

The files generated by the data source application can be in any of the supported format like single column numeric, and multi-column data.

When you select an Oracle NetSuite data source, Data Management populates the source and target columns automatically.

You work with import formats on the Import Format screen, which consists of three sections:

• Import Format Summary—Displays common information relevant to the source and target applications.

• Import Format Detail—Enables you to add and maintain import format information.

• Import Format Mappings—Enables you to add and maintain import format mapping information.

You map NSPB Sync SuiteApp Saved Searches Saved Search data source columns or fields in the import file to dimensions in the EPM Cloud application.

To add an import format to an Oracle NetSuite source:

1. On the Setup tab, under Integration Setup, select Import Format.

2. In the Import Format summary task bar, select Add.

   In the upper grid of the Import Formats screen, a row is added.

3. In Name, enter a user-defined identifier for the import format.

   You cannot modify the value in this field after a mapping has been created for this import format.

4. In Description, enter a description of the import format.

5. In Source, select the NSPB Sync SuiteApp Saved Searches from the drop down.
6. In Target, select the EPM Cloud target application.

7. In File Type, select the format of the file to import:

   Available file formats:

   • Delimited - Numeric Data

     See Defining Import Formats for File-Based Mappings.

   • Multi Column - Numeric Data

     See Loading Multi-Column Numeric Data.

   • Delimited Data - All Data Type

     See Setting the Import Format Data Types.

   • Multi Column - All Data Type

     See Loading Multi-Column Numeric Data

8. In Drill Through URL, enter the search type criteria used for the drill-through.

   For example, you could specify:

   Searchtype=Transaction&searchid=customsearch_nspbcs_trial_balance&Transaction_ACCOUNT=$ATTR1$&Transaction_POSTINGPERIOD=$ATTR2$&Transaction_DEPARTMENT=$ATTR5$&Transaction_CLASS=$ATTR4$&Transaction_INTERNALID=$ATTR3$&Transaction_POSTING=T&

   For more information, see Defining Drill Through Parameters to Oracle NetSuite.

   When specifying the Drill Through URL detail components here, you must also set up the server component for the drill through in the source system. See also Configuring a Source Connection to Oracle NetSuite.

9. In the Mapping section, map the source columns to the dimensions.

   

10. Optional: In Expression, add any import expressions.

    Data Management provides a set of powerful import expressions that enable it to read and parse virtually any file into the Data Management database. You enter advanced expressions in the Expression column of the field. Import expressions operate on the value that is read from the import file.

    For more information, see Adding Import Expressions.

    For information on adding an import format for a data driver, see Adding an Import Expression for a Data Driver.

11. Click Save.