Creating Open Batches

To create and process open batch:

1. On the Setup tab, under Batch, select Batch Definition.
2. In the Batch Definition summary section, click Add.

   Use the blank Name and Target Application fields in the Batch Definition summary grid to enter a batch name or target application on which to search.

3. In Batch Definition Detail section, select the Definition tab.
4. In Name, specify the name of the batch definition.
5. From the Target Application drop-down, select the name of the target application.
6. In the Type drop-down, select Open Batch.
7. In the Execution Mode drop-down, select Serial.

   The serial execution mode processes files sequentially, requiring that one file complete its process before the next file starts its process.

8. In Open Batch Directory, specify the folder under inbox\batches\openbatch subdirectory where the files to be imported are copied. If this field is blank or null, all files under inbox\batches\openbatch are processed.
9. In File Name Separator, for an open batch type, select the character to use when separating the five segments of a batch file name.

   Options:

   • ~

   • @

   • _

   • ;

10. Select Auto Create Data Rule to create the data rule automatically for file-based data loads.

    When Data Management assigns the data rule name, it checks whether a data rule with the "Location_Category" name exists. If the name does not exist, Data Management creates the data rule.

    To use predefined data rules that load data based on specific categories, leave this field blank.

11. Optional: In the Description field, enter a description of the batch definition.
12. Click Save.
13. Stage the file-based data source files by copying them to inbox\batches\openbatch using one of the following methods:

    • Predefined Data Load Rule—To use a predefined data rule that loads data based on specific categories, leave the Auto Create Data Rule field blank on the Batch Definition screen and create the data load rule (see Defining Data Load Rules to Extract Data).

      Next, create the open batch file name using the following format: FileID_RuleName_Period_LoadMethod. The file id is a free-form field that you can use to control the load order. Batch files load in alphabetic order by file name.

      The load method is defined using two-character code identifying the load method where the first code represents the append or replace method for the source load, and second character represents the accumulate or replace method for the target load.

      For the import load method, depending on the source system, available values are:

      • A—Append

      • R—Replace Data

      • F—Full Refresh

      • I—Incremental

      • S—Replace by Security

      For Planning Modules and Planning, the export modes are:

      • A—ADD_DATA

      • R—REPLACE_DATA

      • M—STORE_DATA

      • S—SUBTRACT_DATA

      For Financial Consolidation and Close and Tax Reporting, the export modes are:

      • A—Accumulate

      • R—REPLACE

      • M—MERGE

      Examples of an open batch file name are: a_Texas_Actual04_Jan-2004_RR.txt and b_Texas_Actual04_Jan-2004_RR.txt.

    • Auto-Created Data Load Rule—To load data to any location category and have Data Management create the data load rule automatically, create the open batch file name using the following format: "FileID_Location_Category_Period_LoadMethod".

      In this case, Data Management looks for the data rule with the name "Location_Category". If it does not exist, Data Management creates the data rule automatically with the name "Location_Category".

14. Optional: Apply any scheduling conditions to the open batch file.

    See Scheduling Jobs.

15. On the Workflow tab, under Other, select Batch Execution.
16. In the Batch Execution summary area, select the open batch file, and then click Execute.

    After an open batch is processed, a directory is created, all files within the openbatch directory are moved into the new directory, and the new directory is assigned a unique batch ID.

    Note:

    The Open batch feature is unavailable for the Account Reconciliation Manager.