I have been trying from long to work on Integration of FDMEE and PBCS to load data as part of automation process. So here you go with complete steps.
Using FDMEE, you must register the source system from which you want to import data. For Oracle Planning and Budgeting Cloud, it is a file-based source system. FDMEE creates a file-based source system automatically when you install and configure the product. You must also register the target application (for example, Planning) to which you want to load the data from one or more source systems.
In this tutorial, we take source data from a data file that we downloaded from an Enterprise Resource Planning (ERP) source ledger and load the data to a Oracle Planning and Budgeting Cloud application.
In Oracle Planning and Budgeting Cloud Service Workspace, select Navigate > Administer > Data Management to launch FDMEE.
On the Setup tab, under Register, select Source System.
On the Data Load Mapping page, define the mappings for the Entity, Version, and Account dimensions.
In this tutorial, you define an Explicit mapping for the Entity dimension to map the source value, 1, to the target entity, Operations.
You define a Like mapping for the Version dimension to map any source value to the target version, BU Version_1.
You also define Like mappings for the Account dimension to map source values to target accounts. For example, all source account values that begin with 14 are mapped to the target account, Inventory. The source data file includes accounts 1410 and 1499 that are both mapped to the account member Inventory in the target application. When you run the data load, the source data for these two members will be summed up in the Inventory account in Oracle Planning and Budgeting Cloud.
Your next step in FDMEE is to create a data load rule for a specific location and category to define what you want to import from the source system. For example, the data load rule defines the file(s) that you want to import in addition to other details. After creating the data load rule, you execute it to import the data for one or more periods. You then verify that the data was imported and transformed correctly, and then export the data to the target application.
Perform the following steps to define and execute the data load rule, and then verify that the data was imported and transformed:
On the Workflow tab, under Data Load, select Data Load Rule.
The Data Load Rule page is displayed with the current POV. In this example, the POV is set to the Operations location, Aug-13 period, and Current category.
Click Add to add a data load rule. In the Details grid, specify the data load rule name, OperationsDLR, and select the data load file name. In this example, you load the file TrialBalAug2013.csv.
- Note: If the file information is left blank, the user will be prompted to select a file at run time.
With the rule selected, click Execute. In the Execute Rule dialog box, you define the options for running the rule. In this example, you specify Import from Source, select Aug-13 as the starting and ending period, select the Replace import mode, and click Run.
You only check the box labeled “import from source” so you can look at the data and the mapped results in the workbench prior to loading the data to Oracle Planning and Budgeting Cloud. After everything is confirmed, additional data imports can load to the workbench and export to Oracle Planning and Budgeting Cloud in the same step.
Note: When you import source data, FDMEE imports and also transforms (validates) the data by using the data load mappings that you defined.
An Information dialog box displays your process ID.
- Note: To verify the status of your process, you can navigate to Process Details. A green check mark indicates success for your process ID.
Under Data Load, select Data Load Workbench to see the results of the data load and the mapping process in Data Load Workbench.
- After a successful load, click Export to load the data to the target application. Select the desired load options, and then click OK.
When complete, the icon will change to indicate a successful load.
Let’s now look at the data that you loaded to the target application. In Oracle Planning and Budgeting Cloud, we open a form to verify that the data was loaded, and then we confirm that we can drill through from the Oracle Planning and Budgeting Cloud form to the source system.
In Oracle Planning and Budgeting Cloud, perform the following steps to verify the data load and the drill through:
Open a form in the Oracle Planning and Budgeting Cloud application that contains the accounts for which you loaded data. The data form displays data for the Operations entity, Aug period, FY13 year, Current scenario, BU Version_1 scenario, and USD currency. The form displays the loaded data.
Right-click on the Inventory data cell, and select Drill Through.
Then click Drill Through to source to start the drill-through process.
The first step in the drill-through process displays the source rows that comprise the Inventory amount in Oracle Planning and Budgeting Cloud. Note that two rows (1410 and 1499) from the source data-load file were loaded to the same account in Oracle Planning and Budgeting Cloud.
- From here you can click on an amount to display the source data-load file or drill-through to the source system.
In the Drill Through Details grid, click the amount for the 1499 row, and select Drill Through to Source to drill through to the source system; in this case, Oracle E-Business Suite. Because you included the CCID in the data-load file, you can drill-through to the original data in Oracle E-Business Suite.
The first time you access this source system, you are prompted to enter a user name and password.
This will be prompted to ERP data source with respective code combinations.
That’s it . Queries and comments awaited.