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
Step 2: Fill the date as shown below.
![](https://static.wixstatic.com/media/672833_c683932208d24d9eb9c641336a6f0b62~mv2.png/v1/fill/w_980,h_186,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/672833_c683932208d24d9eb9c641336a6f0b62~mv2.png)
![](https://static.wixstatic.com/media/672833_92bd7e08637e4dd7bb13c6c8b76569e1~mv2.png/v1/fill/w_980,h_392,al_c,q_90,usm_0.66_1.00_0.01,enc_avif,quality_auto/672833_92bd7e08637e4dd7bb13c6c8b76569e1~mv2.png)
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.
![](https://static.wixstatic.com/media/672833_55a886eda2d9449097fab7ea02d7a5ab~mv2.png/v1/fill/w_564,h_315,al_c,q_85,enc_avif,quality_auto/672833_55a886eda2d9449097fab7ea02d7a5ab~mv2.png)
After you submit this Job , The Below series of programs gets kicked off.
![](https://static.wixstatic.com/media/672833_406525e2955c47939d375d4b2604224d~mv2.png/v1/fill/w_980,h_155,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/672833_406525e2955c47939d375d4b2604224d~mv2.png)
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!!!!!
Comments