top of page

Tags

Archive

Search

Import Segment Values and Hierarchy-FBDI -Oracle ERP Cloud

Updated: Jun 27, 2020

In This post i will show how to Import Segment values and hierarchy in Oracle general ledger module.

Step 1: Download the FBDI from below OER

https://www.oracle.com/webfolder/technetwork/docs/fbdi-20a/fbdi/xlsm/ChartofAccountsSegmentValuesandHierarchiesImportTemplate.xlsm

Step 2: Fill the date as shown below.




After you clicked on generate CSV button, you will see a csv file zipped generated in the desired location

Step 3: Log in to the applications and launch the "Load Interface File for Import process." and provide the parameters as shown below.


After you submit this Job , The Below series of programs gets kicked off.


The program goes into the error if there is an issue with single transaction. Check the Output file for more details.

The successful records can be validated by navigating to Setup and maintenance > Manage Segment Values Security Rules

Enter the value set code and then click on manage values and finally check for the value you imported.


Happy Learning!!!!!

2,614 views0 comments

Recent Posts

See All

When transactions are entered, Dynamic Insertion in Oracle Fusion General Ledger (GL) allows an organisation to automatically insert extra segments or values in the GL chart of accounts. This feature

Oracle Fusion Segment Security The General Ledger (GL) feature enables an organisation to restrict access to data in the GL depending on certain parts of the GL chart of accounts. A segment is a subse

Oracle Fusion General Ledger (GL) Cross-Validation Rules are used to assure the integrity and accuracy of data entered into the GL module. They are used to ensure that data submitted in the GL is cons

Other Posts you may Interested