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.

Tuesday, June 21, 2011

11i - SOB (Set of books) - 3C's (CAO , Calendar , Currencies) R12 - Primary Ledger - 4 C's (CAO , Calendar , Currencies , Accounting Method)

Prequisite -
1) Chart of accounts - N > GL > Setup > Financials > Flexfields > Key > Segment

2) Calendar - N > GL > Setup > Financials > Calendar > Accounting

3) Enable Currencies - N > GL > Setup > Currencies > Define

4) Accounting Method Defined - N > AP > Setup > Accounting Setup > Subledger Accounting Setup > Accounting Methods Builder > Methods and Definitions > Subledger Accounting Method

To Setup your accounting structure -

N > GL > Setup > Financials > Accounting Setup Manager > Accounting Setups

1st step - Create your LE
2nd Step - Create PL - Add RL - Add SL

Updating PL -

Accounts used -
Retained Earning - 01.00.3310.000.0000
Suspense - 01.00.2990.000.0000
Rounding - 01.00.7826.000.0000
Translation Adjustment - 01.00.1675.000.0000
Reserve for Encumberance - 01.00.1677.000.0000

--You have to define your BG
--N > US HRMS > Work Structure > Description

Defined various setups/options and changed the setups status to complete.

YOu need a responsibility for your ledger
N > SYSADMIN > Security > Responsibility > Define

Resp Name - YR US General Ledger
Menu - GL_SUPERUSER
Req Group - GL Concurrent Program Group

YOu need to attached your ledger with this responsibility. You have to assign the profile option

Goto Sysadmin - N > Profile> System

Select your new responsibility & Profile name is GL: Ledger Name

OPTIONALLY-

Ledger Set-
N > GL> Setup > Financials > Ledger Set

Data Access Set-
N > GL> Setup > Financials > Data Access Set

Select your new responsibility & Profile name is GL: Ledger Name

Journal Sources
N > GL> Setup > Journal > Source
Roll Date?


Journal Categories
N > GL> Setup > Journal > Categories

------------------------------------------------------Finish Setup for GL

Open the first period to be used -
N > GL> Setup > Open/Close

COnversion/Exchange Rate -
N > GL > Setup > Currencies > Rates > Daily

Transaction -

1) Manual Journal Entry - USD
2) Manual Journal Entry - INR
3) Reverse the Journal Entry

Recurring Journal

1 comment:

varaprasad an artist said...

hi ,
this artical very help full to beginers

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