Pts GL Setup

Download as doc, pdf, or txt
Download as doc, pdf, or txt
You are on page 1of 17
At a glance
Powered by AI
The document discusses the steps to setup Oracle General Ledger for an organization called Proton Technologies.

The document outlines 13 steps to setup Oracle General Ledger which includes defining templates, flexfields, periods, calendars, currencies, ledger, book profiles, address formats, locations, organizations and profile options.

Some of the templates defined include accounting flexfield value sets, accounting flexfield structure, accounting flexfield segment values, period types, accounting calendar etc.

General Ledger Oracle General

Ledger
Proton Technologies

Setup

ORACLE GENERAL LEDGER SETUP FOR


PROTON TECHNOLOGIES

Creation Date: September 23, 2011 Last Updated: Document Ref: Version: V1.0

Approvals:

<Approver 1> <Approver 2>

Prasad

Copy Number _____

General Ledger Oracle General

Ledger
Proton Technologies

Setup

Document Control
Change Record
3

Date Author Versio n 18-Jan2010

Change Reference

Proton Infotech ERP Team V1.0 No Previous Document

Reviewers
Name Position Prasad

Distribution
Copy No. 1 2 3 4 Name Location

Library Master Project Library Project Manager

Note To Holders: If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.

General Ledger Oracle General

Ledger
Proton Technologies

Setup

SET UP STEPS ORACLE GENERAL L EDGER


1. ORACLE GENERAL LEDGER SETUP TEMPLATES ............................................................................................. 1.1 DEFINE A CCOUNTING FLEXFIELD VALUE SET .................................................................................................................... 1.2 DEFINE THE ACCOUNTING FLEXFIELD STRUCTURE ........................................................................................................... 1.3 DEFINE THE ACCOUNTING FLEXFIELD SEGMENT V ALUES .................................................................................................. 1.4 DEFINE PERIOD T YPES ..................................................................................................................................................... 11 1.5 DEFINE THE ACCOUNTING C ALENDAR ............................................................................................................................. 11 1.6 ENABLE REQUIRED C URRENCY ........................................................................................................................................ 12 1.7 DEFINE THE LEDGER ........................................................................................................................................................ 12 1.8 DEFINE GL: SET OF BOOK PROFILE OPTION .................................................................................................................... 13 1.9 DEFINE FLEXIBLE ADDRESS FORMAT .............................................................................................................................. 15 1.10 DEFINE LOCATIONS ....................................................................................................................................................... 16 1.11 DEFINE O RGANIZATIONS ............................................................................................................................................... 16 1.12 DEFINE PROFILE OPTIONS .............................................................................................................................................. 17 5 5 5 8

General Ledger Oracle General

Ledger
Proton Technologies

Setup

1.

Or a cl e G e ne r al Ledge r Set up T emp la te s

1.1 Define Accounting Flexfield value set


Setup > Financials > Flexfields > Validation > Sets
Accounting Flexfield Value Sets

Segment Name Value Set Name Security Available Enable Long List Format Type Max Size Precision #s Only Upper Case Only Right Justify Zero Min Value Max Value Validation Type

Entity Cost Centre Department Natural Account Activity Future PTS_ENTITY_ PTS_COSTCE PTS_DEPT_VS PTS_ACCOUNT_VS PTS_ACTIVITY_VS PTS_FUTURE VS NTRE_VS _VS No Security No Security No Security No Security No Security No Security List of Values List of Values List of Values List of Values List of Values List of Values

Number Number Number Char Number Number 3 6 4 6 2 2 Yes Yes Yes Yes Yes

Independent Independent Independent Independent Independent Independent

1.2 Define the Accounting Flexfield Structure


Setup > Financials > Flexfields > Key > Segments
Field Description Value Application R Enter the application name that owns the key flexfield. General Ledger Flexfield Title R Enter the title of the key flexfield you want to define. You cannot create a new flexfield or change the name of an existing flexfield using this form. Structures Code Title This field automatically displays all previously defined flexfield structures. Use your cursor keys to select the title of the flexfield structure you want to

Accounting Flexfield

PTS_ACCOUNTING_FL EXFIELD PTS_ACCOUNTING_FL EXFIELD

General Ledger Oracle General

Ledger
Proton Technologies

Setup
Field Description Value define or customize. If the flexfield you are defining allows you to use more than one structure, you can create a new structure for your flexfield by inserting a row. When creating a new structure, arrow down to obtain a blank row. Description O You can use this description to provide a better explanation of the purpose of this flexfield structure. View Name O Enter a View name if you want the application to generate a view for the structure to make ad hoc reporting simpler. The View that you specify will have a column for each segment in the structure along with the start_date_active, end_date_active, summary_flag, enabled_flag, and row_id. Freeze Flexfield R Indicate whether you want to freeze your flexfield definition. Enter No if you Definition want to set up or modify your flexfield segments or change the appearance of your key flexfield window. After you finish defining your flexfield, enter Yes to freeze it. Then save your changes. Enabled R Indicate whether you want this structure may be used in your key flexfield. Y Segment R Enter the character you want to use to separate your flexfield segment Separator values or descriptions whenever your application forms display concatenated segment values or descriptions. Cross-Validate O Indicate whether you want to cross-validate multiple segments using crossMultiple validation rules. You can define cross-validation rules to describe valid Segments combinations using the Define Cross-Validation Rule form. Enter No if you want to disable any existing cross-validation rules. Cross-Validation rules will be addtional rules to any FCE validations. Freeze Rollup O Enter Yes or No to indicate whether you want to freeze your rollup group Groups definitions. Allow Dynamic R Enter Yes to allow dynamic inserts of new valid combinations into your Inserts generic combination table. Name Entity Cost Centre Department Natural Account Description Column Number Enabled Displayed Indexed VALIDATION Value Set Description SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 1 2 3 4 5 6 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes PTS_ENTITY_ VS PTS Entity Valueset PTS_COSTCE NTRE_VS PTS Cost Centre Valueset PTS_DEPT_VS PTS_ACCOUNT_ VS PTS PTS Account Department Valueset Valueset PTS_ACTIVITY_ VS PTS Activity Valueset Activity Future

PTS_ACCOUNTING_FL EXFIELD

Set to N initially, then change to Y

Dash ( - )

N Y

PTS_FUTURE_V S PTS Future Valueset

Default type Default Value Required Enable Security Range SIZES Display Size Description Size

Yes Yes Yes Yes Yes Yes

3 6 4 6 2 2 50 50 50 50 50 50

General Ledger Oracle General

Ledger
Proton Technologies

Setup
Name Entity Cost Centre Department Natural Account Concatenated Description Size PROMPTS List of Values Window Prompt QUALIFIERS Cost Center Segment Natural Account Segment Balancing Segment Intercompany Segment Management Segment Secondary Tracking Segment 25 25 25 25 25 25 Activity Future

Entity Cost Centre Department Natural Account Activity Future Entity Cost Centre Department Natural Account Activity Future

No Yes No No No No

No Yes No

No

No No

Yes No No No No No No No

No No No No

No No No No

No No No No

No No No No

General Ledger Oracle General

Ledger
Proton Technologies

Setup

1.3 Define the accounting Flexfield Segment Values


Setup > Financials > Flexfields > Key > Values
Following are the value sets of key Flexfield segments: 1. 2. 3. 4. 5. 6. PTS_ENTITY_VS PTS_COSTCENTRE_VS PTS_DEPT_VS PTS_ACCOUNT_VS PTS_ACTIVITY_VS PTS_FUTURE_VS

Value Set Name Description Size

PTS_ENTITY_VS PTS Entity Valueset

Type Validation Type Independent Value Description Effective Hierarchy Qualifier Enabled From Date 100 SERVICE ENTITIES 101 Proton Technologies Checked Checked Checked

To Date No No

Parent Rollup group

Level Allow Budgeti ng

Allow Posting

Yes Yes

200 PROJECT ENTITIES 201 PTS Business Parks (Hyderabad) Pvt Ltd More Values

Checked Checked

Checked

No

No

Yes Yes

Value Set Name Description Size

PTS_COSTCENTRE_VS PTS Cost Centre Valueset

Type Validation Type Independent

Value Description Effective Hierarchy Enabled From Date 100000 CORPORATE Checked Checked No 111000 IN_CHENNAI Checked Checked No

To Date

Parent Rollup group

Qualifier Level Allow Allow Budgeting Posting No No

General Ledger Oracle General

Ledger
Proton Technologies

Setup
113 ACRES_India Fund I 111001 IN_CHENNAI 113 ACRES_India Fund I (Payroll/ NonPayroll) More Values

Checked

Yes Yes

Value Set Name Description Size Type

PTS_DEPT_VS PTS Department Valueset

Validation Type Independent

Value Descrip tion 1001 ACQUISI TIONS & DEV 1002 ACCOUN TING 1003 ASSET MANAGE MENT 1004 BUILDIN G OPERATI ONS 1005 CORPOR ATE EXECUTI VE More Values

Enable d Checked

Effective Hierarchy From To Date Parent Rollup Date group Yes

Level Allow Budgeting

Qualifier Allow Posting Yes

Checked Checked

Yes Yes

Yes Yes

Checked

Yes

Yes

Checked

Yes

Yes

Value Set Name Description Size

PTS_ACCOUNT_VS PTS Account Valueset

Type Validation Type Independent

Value Descrip tion

Enable d

Effective Hierarchy From To Date Parent Rollup Date group No No Asset No No Asset

Level Allow Budgeti ng

Qualifier Allow Posting

Accoun t Type

A00000 ASSETS Checked Checked A10000 FIXED Checked Checked

General Ledger Oracle General

Ledger
Proton Technologies

Setup
ASSETS A11000 LAND Checked A11000 Free Checked Hold Land More Values

Checked No Yes Yes Asset

No

Asset

Account Type Choose from LOV (Asset, Liability, Revenue, Expense)


Value Set Name Description Size Type Validation Type Independent PTS_ACTIVITY_VS PTS Activity Valueset

Value Descrip tion 1 Leasing Checked 2 Acquisiti ons 3 Asset Manage ment 4 Develop ment 5 Property Manage ment Escalata ble More Values

Enable d Yes Checked Checked

Effective Hierarchy From To Date Parent Rollup Date group Yes Yes

Level Allow Budgeting

Qualifier Allow Posting Yes Yes Yes

Checked Checked Yes

Yes

Yes Yes

Value Set Name Description Size

PTS_FUTURE_VS PTS Future Valueset

Type Validation Type Independent

Value Descrip tion 99 Default Checked

Enable d Yes

Effective Hierarchy From To Date Parent Rollup Date group

Level Allow Budgeting

Qualifier Allow Posting Yes

10

General Ledger Oracle General

Ledger
Proton Technologies

Setup

1.4 Define Period Types

Setup > Financials > Calendar > Types

Period Type Month (16) Periods per Year 16 Year Type Fiscal Description

1.5 Define the Accounting Calendar

Setup > Financials > Calendar > Accounting Calendar: PTS_CALENDAR Description: PTS Calendar
Prefix Type Year Qtr Num From To Name Adjusting Apr-09 Month (16) 2010 1 1 01-APR-2009 30-APR-2009 May-09 Month (16) 2010 Jun-09 Month (16) 2010 AdjMonth (16) 2010 Q1-09 Jul-09 Month (16) 2010 Aug-09 Month (16) 2010 Sep-09 Month (16) 2010 AdjMonth (16) 2010 Q2-09 Oct-09 Month (16) 2010 Nov-09 Month (16) 2010 Dec-09 Month (16) 2010 AdjMonth (16) 2010 Q3-09 Jan-09 Month (16) 2010 Feb-09 Month (16) 2010 Mar-09 Month (16) 2010 AdjMonth (16) 2010 Q4-09

Apr-08 1 2 01-MAY-2009 31-MAY-2009 May-08 1 3 01-JUN-2009 30-JUN-2009 Jun-08 1 4 30-JUN-2009 30-JUN-2009 Adj-08 Yes 2 2 2 2 3 3 3 3 4 4 4 4 5 6 7 8 01-JUL-2009 31-JUL-2009 Jul-08 01-AUG-2009 31-AUG-2009 Aug-08 01-SEP-2009 30-SEP-2009 Sep-08 30-SEP-2009 30-SEP-2009 Adj-08 Yes

9 01-OCT-2009 31-OCT-2009 Oct-08 10 01-NOV-2009 30-NOV-2009 Nov-08 11 01-DEC-2009 31-DEC-2009 Dec-08 12 31-DEC-2009 31-DEC-2009 Adj-08 Yes 13 14 15 16 01-JAN-2010 31-JAN-2010 Jan-08 01-FEB-2010 28-FEB-2010 Feb-08 01-MAR-2010 31-MAR-2010 Mar-08 31-MAR-2010 31-MAR-2010 Adj-08 Yes

11

General Ledger Oracle General

Ledger
Proton Technologies

Setup

1.6 Enable Required Currency


Setup > Currencies > Define
Purpose: Use this screen to enable predefined currencies or to add new currencies-

Note: Oracle provides seeded values for most currencies (including STAT)- They must to be enabled Field Code R INR Name R Indian Rupee Description O Indian Rupee Issuing Territory R India Symbol O Precision R 2 Extended N 5 Precision Minimum R Accountable Unit Type Factor From O Defaulted To O NA Enabled R Yes

1.7 Define the Ledger


Setup > Financials > Accounting Setup Manager > Accounting Setups
1. Create Legal Entity

Field Value Identification Information Territory R Legal Entity Name R PTS Organization Name O Organization Number R 1062 Legal Entity Identifier R 1 Registration Number Transacting Entity Yes Legal Address Country R India Address 1 R Address 2 Address 3

India PTS Business Parks Hyderabad

12

General Ledger Oracle General

Ledger
Proton Technologies

Setup
Field Value City State Karnataka Post code 560001 General Information Place of Registration Bangalore Inception Date Bangalore

2.

Define Ledger

Field Value Standard Information Ledger R PTS_Ledger Short Name R PTS_Ledge2025(INR) Description O PTS Business Park (Hyd) Pvt Ltd Chart of Accounts R PTS_ACCOUNTING_FLEXFIELD Currency R INR Accounting Calendar Name R PTS_CALENDAR Period Type R Month (16) R 1 Number of Future Enterable Periods Subledger Accounting Subledger Accounting R Encumbrance Accrual Method Journal Entry Language R American English Year-end Processing Retained Earnings R 201.999999.9999.L26001.99.99 Journal Processing Balance I/C Journals O Journal Approval O Journal Entry Tax O Suspense O Rounding Differences O Currency Translation Options Default Period End Rate O Type Budgetary Control Enable Budgetary Control O Checked Require Budget Journals O Checked Reserve for Encumber- O 201.999999.9999.L90005.99.99

1.8 Define GL: Set of Book Profile Option


Sysadmin responsibility>Profile>System

13

General Ledger Oracle General

Ledger
Proton Technologies

Setup

Site Yes Application Blank Responsibility Blank User Blank Profile with No values Selected Profile GL: Data Access Set Value at Site Level

14

General Ledger Oracle General

Ledger
Proton Technologies

Setup

1.9 Define Flexible Address Format


Login into the Application Developer Responsibility Navigate: Inventory>Setup>Flexfield>Descriptive Segment s
Descriptive Flexfield Segments Window Application Oracle Human Resources Title Accommodation Address Freeze Flexfield Definition Yes Segment Separator Period (.)

Context Field Zone Prompt Default Value Reference Field Value Required Override Allowed Address Style STYLE No No Context Field Values Zone Code Name Description Enabled Global Data Elements Global Data Elements Global Data Element Context

Yes

Click on Segments Button. Segments Summary ( Address) Num Name Window Column Value Set Displayed Enabled ber Prompt 1 Address Line 1 Address Line 1 ADDRESS LINE1 30 Characters Yes Yes 2 Address Line 2 Address Line 2 ADDRESS LINE2 30 Characters Yes Yes 4 City City CITY 30 Characters Yes Yes 5 State State STATE 30 Characters Yes Yes 6 PIN CODE PIN CODE POSTAL_CODE 7/Number Yes Yes

Log into Application Developer > Application>Lookups>Application Object Library


Type User Name Application Description Code Meaning Description Enabled ADDRESS_STYLE ADDRESS STYLE Application Object Library Address entry style for Flexible Address Formats IN India Address Style India Address Style Yes

15

General Ledger Oracle General

Ledger
Proton Technologies

Setup

1.10 Define Locations


Navigate: Inventory>Setup>Organizations>Locations
Name PTS_Hyderabad_ Description PTS Hyderabad Inactive Date Global Yes Address Style India Flat/Door/Block Number APIIC SEZ Building Name/Village Road/Street/Lane/Post Office Area/Locality/Taluk/Sub Division Town/City/District Hyderabad State/UT Andhra Pradesh PinCode Shipping Details Contact Ship-To Location PTS_Hyderabad_(PTS) Ship To Site Yes Bill To Site Yes Receiving Site Yes Internal Site Yes Office Site Yes Other Details Inventory Organization 102-PPTS Tax Code EDI Location

1.11 Define Organizations


Navigate: Inventory>Setup>Organizations>Organizations
Name PPTS Type From Date 01-JAN-1990 To Date Location PTS_Hyderabad_() Internal / External Internal Location Address Pradesh. Internal Address Organization Classification HR Organization Yes Inventory Organization Yes Project Expenditure/Event Organization India

Hyderabad.

Andhra

Yes

16

General Ledger Oracle General

Ledger
Proton Technologies

Setup
Project Task Owning Organization Yes

1.12 Define Profile Options


Sysadmin responsibility>Profile>System
Site Yes Application Blank Responsibility Blank User Blank Profile with No values Selected Profile Value at Site Level PTS Pvt Ltd Profile Value at Site Level Profile Value at Site Level Setup Business Group Profile Value at Site Level Setup Business Group

MO: Operating Unit MO: Security Profile HR:Business Group HR: Security Profile

Chart of Accounts >> Organization Structure >>

17

You might also like