Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Friday, August 5, 2011

Oracle General Ledger Setups

Setup for a Key Flex fields

The Path for Segment window is

Genral ledger, Setup, Financials, Flexfields, Key, Segments

Click on Segments.

Here Create New Key Flex Fields by clicking icon which was rounded.

Then Here we will find an yellow block over here.


Write a Code name as LGS_INDIA_KFF, as well as with same name in Title, Description.

Then enter here all required Segments here

Name: Segment Name (Ex:- Companies)

Prompt: Display Name (Ex:- Companies)

Column: Segment1 (Ex:- Segment1)

Then press here on Value Set.

Here Create the Value set

Ex: Value Set Name : Companies_vs_LGSINDIA

Maximum Size : 2 (It will give in range 00 to 99)

Same way Design Branches Value Set

Here Design Accounts Value set

Get the all the Value sets into Value Set Tab using LOV’s

Here For Company Segment we Need to assign the Flex field Qualifier as Balancing

Segment by enabling the Balancing segment in Qualifier windo

Here In Accounts Flex fields Qualifier enable the Natural Account Segment.

Here After Creating Accounting Key Flex field.

Freeze Flex field Definition by checking freeze flex field definition.

Check the Allow dynamic inserts box also by clicking on the check box.

And Now Compile the Account Flex Field .

Once Complied u cannot change the any segments to account Flex fields.

Create the Values for accounting Flex Field Segments

The Navigation Path is GL, Setup, Financials, Flex fields, Values

Click on Values.

Then The below Window opens were in Structure get the Accounting Flex Field we

created by using LOV.

Then Click on Find button

In this window we can enter the No. of Companies running.

Here we can enter only 00 to 99 Companies because we are created only 2 digits in

Value set Creation. If we enter more than 99 then the error which is showing on

the screen will be displayed.

Same way enter branches Information in the branch values by just placing curser in

independent Segment tab end press the cursor arrows.

In Same way we Create accounting information values by adding account type

in segment Qualifier Tab

We should enter defiantly Retained earning s in the accounts value because

it is owners profit/shares account type

Define Calendar

We Should Define Calendar using path as GL, Setups, Financials, Calendar, Types

When we Click on the type we will find this window.

Were we can add your required calendar with required no of periods

And then Save it.

After that click on accounting in GL, Setup, Financials, Calendar, Accounting

We will get following window. were we can enter our periods.

After entering the periods save the work once

Define or enabling the Currency.

Go to GL, Setup, Financials, Currency, define and click on define we will get window.

By querying the window we will get around 256 currencies were we can enable the

required currency or define new currency .

Now enable the INR by checking the check box on the enabled screen.

Define the Set of books

To Define the Set of book we need to go to GL, Setup, Financials, Books, Define

Then enter Set of books name and short name,

Get the Accounting Flex Field Value into Chart of Accounts Tab by using LOV.

Calendar which we defined to be added in Calendar Block Name Field.

And enter the account which is used for Retained earnings Field and click on ok button..

Now Go to System administrator responsibilities

Now Go to System administrator, Profile, System

And click on System.

Here enter the Responsibility name in responsibility field and enter

Profile : GL SET OF BOOKS NAME

And press on find button

Here enter the Set of book name in Responsibility tab in Profile field. If it Vision

instance else enter it on site level when it is fresh instance

Now go to GL responsibility and enter the journal we will the error which is showing in

below fig. due to period is not opened

So we need to go to Menu Open/close and click on it.

Here open the period from which date company is going to start by just clicking on open.

Were here it will ask are you sure or not click on yes

Then enter the journal end post it accept then it will work fine.

1 comment:

Mohamed Farouk said...

Thank you so much Sir. Raju

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect