Using an Open Batch - File Job Type

Use the Open Batch - File job type to load and run multiple files to the Oracle Enterprise Performance Management Cloud in a batch. The file name format specifies the POV to load the data.

The Open Batch - File job type parameters include:

Table 12-18 Open Batch - File Job Parameters

Open Batch - File Job Type Parameters	Description
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.
File Name Separator	Select the character to use when separating the five segments of a batch file name. Options include: ~ @ _ ;
Execution Mode	In Execution Mode, select the Serial—The serial execution mode processes files sequentially, requiring that one file complete its process before the next file starts its process. Parallel—The parallel execution mode processes files simultaneously.
Number of Parallel Jobs	Specify the maximum number of Open Batch - File jobs that can be processed in parallel execution mode.
Auto Create Integration	To create the integration automatically for file-based integration, select Yes. When Data Integration assigns the integration name, it checks whether an integration with the name "Location_Category" exists. If this name does not exist, Data Integration creates the integration using the following file naming conventions: Integration Name—Location_Category Description—"Auto created data rule" Category—Category File Name—Null Mode—Replace
Plan Type	Select the plan type of the target system. You can also register a custom cube as a separate application with no limit to the number of custom cube applications that can be registered.
Multi Period	Select Yes to read file-based data sources with multiple periods and import them into the appropriate POV based on the file name. The names of multiple period batch files consist of the following segments in the following order: File ID—A free-form field used to control load order. Batch files load in alphabetic order by file name. Location Category Start Period End Period Load Method—A two-character item (Character 1 = append or replace, and Character 2 = target append or replace). Valid values are A and R. Examples of open batch for a multiple period file name: a_Texas_Actual_ Jan-2023_ Jun-2023_RR.txt (Loc, Cat, Start Period, End Period) and b_TexasDR1_ Jan-2023_ Jun-2023_RR.txt (Data Rule, Start Period, End Period) Select No to not include file-based data source with multiple periods and import them into the appropriate POV based on the file name.

Here are sample job parameters for an Open Batch - File job type: