BSNL CDR1, Oracle Applications (Accounting)
Contents
1. Oracle Applications olx File Edit View Folder Tools Window Help ORACLE EAVDIGTSSPFIsINDER 4009 Enter Journals BSNL SOUTH Be Journals BSNL SOUTH New Teura E Conversion Reverse Description Currency INR Date Ledger BSNL SOUTH Category Date 01 FEB 2009 Period Period FEB 09 Effective Date 01 FEB 2009 Type User Method Switch Dr Cr v Balance Type Actual Document Number Rate 1 Status Not Reversed Clearing Company Tax Not Required DERE Control Total i ines Other Information v Line Account _ Debit INR Credit INR Description ret ab L Ld 4 3 Acct Desc Post AutoCopy Batch Approve Line Drilldown T Accounts Fi Check Funds Reserve Funds View Results Change Period Change Currency Figure 2 Journal window Field References The Field Name and the Description of all the fields that appear in the Journal window is given below Table 2 Field References for Journal window Field Name Description Journal Name Displays a unique name for every manual entry If a Journal Name is not provided a name is automatically assigned on the basis of the format defined for each source For a manual entry a journal is automatically assigned when the category is selected If a batch name is not provided before entering it in the journals the name of the first journal in the ba2. References The documents used as references are Configurations Document Oracle Applications General Ledger Implementation Guide Functional Specifications Document Technical Specifications Document System Requirements Specifications Document Pon gt Confidential vi TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Contents 1 aeaoe e sva 1 1 1 Purpose of Oracle Applications Accounting rrronrrnonvnnrnrenenvnnenvenenvnnenrenenvnnenrenennnnerrrnssnrnennressrnnennnenn 1 1 2 Features of Oracle Applications Accounting rrrrvrnnnnvnnnvrnnnnvnnnnrnnnnnernrnnnnnnnrnrnnnnennenrnnennnsnnrnsennnennnn 1 1 3 Oracle Applications Environment reronvnnenvnnonvnnenvenenvnnenvenenvnnenvenervnnnnvenenvnnsnvrnssnnnsnnressnrnsnnenesnresnnnesnn 2 1 3 1 Software Environment uaseeorvrnnnnvnrrvrnnnnrnnenrnnenvenenrnnenrnrnvrenennnnnnrenennnssnrnnennnnenvnnenennenresenrenenrnnennesennne 2 1 32 H rdware Environment siisii se aaa aAa oaa EAEE aoaaa Eiai aED 2 1 4 User ROOS a a a a a a a a aaa a T A a a aA E aA E AA A E EE Tia 2 2 Gekting Starnednuuaavssmarmeemuegsmemeeetestmedteabmssatddentm nes 5 2 1 Using Menus and Toolbars asnoisan aaaea aaan AAA a a aa EAN OEE OE TEE 5 211 Using Shortcut KEYS i acces scsanatsdcceueccesscnnenttatuctedncenaees nanos fencdlneeyy dieting ia a Ea Oai EEA be iiaia 5 3 JOU ch ses seekers ease 7 3 1 Journal Batch Window isinen annene er
3. Select or double click the status as Closed or Permanently Closed as required from the dropdown list Click Cirl S The Open Close period is saved Click X located at the top right corner of the window The Open Close window closes A message Submitted lt number gt concurrent request s appears as shown in Figure 15 Oracle Applications File Edit View Folder Tools Window Help Aveo Sa GR KOHDHee I 409972 lof lolx Ledger BSNL SOUTH Accounting Period Encumbrance Year Latest Open FEB 09 Latest Open 200809 Open Period Open Next Year Number Fiscal Year Status Period Open DEC 08 Open NOV 08 Open OCT 08 Open SEP 08 Open AUG 08 Closed JUL 08 Open JUN 08 3 20080 01 JUN 2008 30 JUN 2008 Closed MAY 08 2 20080 01 MAY 2008 31 MAY 2008 APR 08 1 20080 01 APR 2008 30 APR 2008 Figure 17 Note of Submission of concurrent request Confidential 42 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 12 Year End Closing Activities Year End Closing Activities are performed at the end of the fiscal year These activities help to generate the retained earnings for that particular fiscal year 12 1 Year End Activities Use the following checklist as a guideline to perform year end processing in Oracle General Ledger The steps in the tasks have been consolidated from the previous sections 12 1 1 Performing Year End Activities Prerequisites to proceed User should e Login
4. Balance Type Actual Document Number Rate 1 Status Not Reversed Clearing Company Tax Not Required Reverse Control Total Tl Eo Lines al Other Information v Line Account Debit INR Credit INR Description 4 gt Acct Desc Post AutoCopy Batch Line Drilldowr T Accounts 4 Check Funds Re ind Change Period Change Currency Figure 5 Journals window 5 Select a Category from the dropdown list 6 Enter the Period for the journal entry from the dropdown list For example if the Period is FEB 09 then the Effective Date is automatically set to 01 FEB 2009 The value for the Effective Date can remain the same or can be changed Note i A journal can be entered in an Open period or Future Enterable period Journals can be posted only in Open periods ii By default the value for Balance Type field is Actual A Document Number is auto populated when the record is saved iii The journal Category or Document Number cannot be changed after the journal entry is saved 7 Enter an amount for the Control Total to verify the total debits for the journal lines against the journal control total 8 Click Lines tab and enter the journal lines with Debit and Credit amounts 9 Click the Other Information tab to enter the reference information about the journal entry Note The above step is optional 10 Click Ctrl S The Journal is saved 3 1 2 Reversing a Journal or Batch Reversing th
5. REFERENCES FOR SUBMIT REQUEST WINDOW e cscescsssessssscesessscscssescssscssessevscsseeeseees 23 TABLE 6 FIELD REFERENCES FOR SEGMENT VALUES WINDOW evrvrsrsvrvrvesrvevrsessersveseseevevenessevsveseseen 26 TABLE 7 FIELD REFERENCES FOR ACCOUNTING CALENDAR WINDOW rvrvrsvrvrvrsesrevsvrsessrvevesereveveseseen 30 TABLE 8 FIELD REFERENCES FOR DOCUMENT SEQUENCES WINDOW svrvrvrsrsvrvrsesrersvrveservrvesessevsveseseen 33 TABLE 9 FIELD REFERENCES FOR SEQUENCE ASSIGNMENTS WINDOW cccesessesssesessesscessssesscsseeeeeees 35 TABLE 10 FIELD REFERENCES FOR JOURNAL CATEGORIES WINDOW u csccsssesessesssesescecscesessesscseevscees 38 TABLE 11 FIELD REFERENCES FOR OPEN AND CLOSE PERIODS WINDOW c cscecssssesessesesessesscsseeeeees 41 Confidential xX TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual List of Abbreviations Abbreviation Acronym BSNE Bharat Sanchar Nigam East Ledger for East BSNL Bharat Sanchar Nigam Limited BSNS Bharat Sanchar Nigam South Ledger for South CDR Call Detail Record DC Data Center Dr Cr Debit Credit ES Electronic Stapling GL General Ledger PMS Payment Management System SSA Secondary Switching Area Confidential xi TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 1 Introduction The main objective of Oracle Applications Accounting implementation is to rollout the Telecom Revenue Accounti
6. cannot be modified below e If there is no end date defined and there are no active assignments for a sequence it can be disabled the sequence by entering the current date as the end date Once disabled a sequence cannot be reactivated Type The value is always Automatic Once defined it cannot change the type of document numbering sequence Message It is a checkbox It is always V Once a sequence is saved the message choice cannot be changed Initial Value Enter a value for the first document in the sequence Sequence numbers cannot be greater than eight 8 digits If this field is left blank the first document is automatically assigned a value of 1 Once a sequence is saved this initial value cannot be changed 9 1 1 Defining the Document Sequences Prerequisites to proceed e User should login to Oracle Applications e User should have access to the Calendar window access depends on the role Users e South DC Level 2 Based on zonal data centre user e BSNL South O amp M Based on zonal To define document sequences Click Sequences gt Document gt Define The Document Sequences window appears Enter Name Select the value of Application field as General Ledger Enter From and To Date Select Type as Automatic Enable the Message checkbox Enter the Initial Value CO Oh OT oN Click Ctrl S The document sequences are defined and saved Confidential 34 TATA CONSULTANCY SERVICES
7. to Oracle Applications e Have access to Open Close period window e Have access to Journal and Post window Users e South DC Level 2 Based on zonal data centre user e BSNL South Admin Based on zonal To close the year end Click Open Close window The Open Close window appears 2 Follow Section 10 1 1 Opening Closing a Period to close the current period and Open the adjusting period in the Open Close window 3 Click Journal gt Enter The Journal window appears 4 Follow Section 2 1 1 Entering the Journal to enter the journal 5 Follow either Section 3 1 1 Posting a Batch or Section 3 1 2 Posting a Journal to post the adjusting entries which are entered as given in Step 4 above Click Run Trial Balance report in the adjusting period after the adjustments are made Set the status of the first accounting period in the new fiscal year to Future Entry Note It is advisable not to open the first period of the new fiscal year until all of the year end processing for the last period of the current year is completed 8 Create the reversal entries for Accrued Income and Advance income at the beginning of every period 9 Transfer data from all source systems like Billing PMS and ES to the GL INTERFACE table 10 Post all unposted journal entries for the period end closing activities including reversals 11 Review the posting results with the help of Posting Execution Report 12 Update any unpostable jo
8. 29 MAR YYYY May Adj 30 MAR YYYY Jun Adj 31 MAR YYYY General Ledger automatically creates and displays a period Name for each accounting period The name consists of period prefix and the last two digits of fiscal year General Ledger displays the period name whenever an accounting period is chosen For example Apr of financial year 2009 appears as Apr 09 in Name field and then manually it has to be changed to Apr 08 Name It is a checkbox If an accounting period is chosen as an Adjusting period it must overlap with the dates of other accounting periods For BSNL Adjusting adjusting period is from April to June of next financial year Both adjusting and non adjusting periods have the same period type associated with the ledger 8 1 1 Adding Periods to the existing Calendar Prerequisites to proceed e User should login to Oracle Applications e User should have access to the Calendar window access depends on the role Users e South DC Level 2 Based on zonal data centre user e BSNL South Admin Based on zonal To add periods to existing calendar 1 Click Calendar gt Accounting The Accounting Calendar window appears 2 Query the name of the calendar BSNL CALENDAR 3 Click EF located in menu bar A new record appears and is highlighted in yellow 4 Enter a period Prefix for each accounting period 5 Enter the period as Type BSNL Type 6 Enter the Year of the accounting
9. Batch in the Enter Journals window The screenshot for the Batch window is given below Oracle Applications jopx File Edit View Folder Tools Window Help ORACLE ZALM EE FRIE E TAA E E i pm E3 O Batch BSNL SOUTH Batch Status Period APR 08 Balance Type Actual Posting Unposted Description Funds N A Approval N A Control Total Batch Totals Details Debit Credit Created 15 DEC 2008 Entered Posted Accounted Posted By Autocopy Batch Check Funds Reserve Funds iaw Results Post Reverse Batch Tax Batch Approve Change Period More Clear New Batch New Journal Find v 4 gt Review Journal Review Batch Post Reverse Batch Requery New Journal New Batch Tax Batch Approve AutoCopy Figure 4 Batch window 3 Click Journals The Journals window appears 4 Enter a unique Journal Name and the Description for the journal entry Note i The Description field is optional ii The ledger name is BSNS for BSNL South and BSNE for BSNL East by default Confidential 11 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Oracle Applications BEE File Edit View Folder Tools Window Help ORACLE ARM 2368 4 1hb4R TAE nit Journals BSNL SOUTH New Journal Conversion Reverse Description Currency INR Date Ledger BSNL SOUTH Category Date 01 FEB 2009 Period Period FEB 09 Effective Date 01 FEB 2009 Type User Method Switch Dr Cr
10. Oracle Applications Accounting User Manual 9 2 Assign Document Sequences Every journal is associated with a document number Whenever a journal is saved a document number is assigned to it The sequences are attached with the category which in turn is linked with the journal The sequence should first be defined and then assigned to that particular category Tasks that can be performed using this window are e Assigning the Document Sequences e Defining the Category The screenshot for Sequence Assignments window is given below Oracle Applications File Edit View Folder Tools Window Help AVD GF 86S LOPA LOODJE D Functions l Documents Processes Setup Financials Sequences Document Assign O Sequence Assignments Document J Assignment Application Category Ledger Method Automatic S 1 Document Assignment Application Category Start Date End Date Sequence Figure 14 Sequence Assignements window Field References The Field Name and Description of all the fields that appear in Sequence Assignments window is given below Table 9 Field References for Sequence Assignments window Confidential 35 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Field Name Description Document Tab Application Select the value as General Ledger from the dropdown list Once saved the application associated
11. TATA CONSULTANCY SERVICES Experience certainty IT Services Business Solutions Outsourcing BSNL CDR1 Oracle Applications Accounting Version 1 0 User Manual June 2009 BSNL Hyderabad India TANITA TIAA APA LARA LARA AA AA TA NN ANNN ANNE ANNAN ANNEN NTN ANNAN ANNEN VANTANT ANNN ANNAN ANTATT NTN NANSENS NNN YANNI YANN TV ANG TV NGTVANG HV ANGTVANGTVANGT YANN TYAN TVA NGEV NGTYANGHVANGHVANGT PANG VANT NUT PANVTVANNTP NGTVANNTPANGHPANNT VANNS NANNA PANGEVANNTPANGEP ANT PANG NNN ANNAN NNTVANTN ANTANTI VA AAAA ATATA AAAA TATATATA TATA CONSULTANCY SERVICES Experience certainty IT Services Business Solutions Outsourcing BSNL CDR1 Oracle Applications Accounting Version 1 0 User Manual June 2009 BSNL Hyderabad India TANITA TIAA APA LAGA TATATA AA AA ATA NNIVANNN ANNE NNN ANNEN NTN ANNAN ANNAN VNITAT ANNN ANNAN VANTE IYANNTYANGTYANNTYANNT NEVNT NSU ANG NNN VANGTVANGTY ANT VANT VANN VANST NST ANSN ANNAN ANNI ANNTPANNT PANN NUT PANVT NTN ANNAN NNN VANN NNT NN TANN ANST NNN ANNAN NNN ANNAN NTN ANTANTI TESTATAAN HA NLA RAA ES NSS TS TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual This is a controlled document Unauthorised access copying replication or usage for a purpose other than for which it is intended are prohibited All trademarks that appear in the document have been used for identification purposes only and belong to their respective companies Co
12. UTPANGTY NGTVANNT NTN NNN NTN ANNAN NNN ANNAN NTN ANNAN NTN NNN MT TT NT TATT AJ AA AAN AA TATA CONSULTANCY SERVICES www tcs com
13. alues which contains Zone Circle SSA e Pagebreak Segment Low means From It is a list of values which contain the list of Zone Circle or SSA based on the value selected under Pagebreak Segment e Pagebreak Segment High means To It is a list of values which contain the list of Zone Circle or SSA based on the value selected under Pagebreak Segment e Period The period for which report has to be generated e Amount Type PTD means Period To Date It means the report is generated Parameters for a particular period as selected under Period field YTD means Year To Date It means the report is generated from Apr month of that year till the period selected under Period field If the report selected is Account Analysis 180 Char enter the values in the following fields as given below e Ledger Ledger Set BSNS e Ledger Currency INR e Currency Type Total e Entered Currency N A e Type Select either Entry Item Line Item Source Item e Balance Type A Actual e Budget or Encumbrance N A e Starting Period Select the period from the list of values It means Confidential 23 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Field Name Description from period e Ending Period Select the period from the list of values It means to period e Flexfield From Flexfield To Select Zone Circle SSA GL Code from the list of values e Order By Select from the li
14. asana aaa ana a aa a E VA EO EAE aA Ea aa EARTE 7 SA Entering the Journal ssiri ionan apaan a E a Ea A apa ne ciel eee 10 3 1 2 Reversing Journal or Batch ccccc ccticesccceeiseeeccelleececsdiveecdedebneaunasescdeseneesccunds sgneendvacientdeedheseist nesta 12 A Post JOUliMal BalCh casana EAE ane 14 4 1 SOUP EAT 100 EEE 14 411 Postnga Batch eseina Ed a ed ed ee een 15 4 1 2 Posting a JOUINAL ccccccece cece cece eee eeeeee cece eeeeeeaeee eee eeeceaaaaeeeeeeeeeeaaeeeeeeeeesecceaaeeeeeesseceeneeeeeseeeeee 15 4 2 POSE WINGOW eussiee cotecdenecused seint ea dd nde aE EEA a EA E add AAAA AEAEE 16 421 Postinga bateh sa umusinsmme a A E a A OEE E E E NEET 17 4 2 2 Reviewing the Batch Posting Status rrrrrrrrrrvrrrnnrrrrrrnnrnrrrrnvnrrrnnvnnrrrnnnnerrnnnnerrnnnnerrrnnnnerrnnnnerennnn 17 4 3 Status of Posting Request rrrnnvnrrrrvrnrrrnnnrnerrrnrnnnrrnvrnnnrnnnnrrennnnerrsnnnerrrnnnnsrrnnnnnsrsnnnnerrnnnnersrnnnnsrsnnnnennn 18 4 31 Miewing thie Request csiis ninenin eaaa a aaan i paidan 18 4 3 2 Verifying the Status of the Request srnnnvrnnnnvnnnvrnnnnrnervrnnnnrnnnvrnnnnvnnnvrnnenvnernrnnenrnrenrnnenvnsenrnnennesennnn 18 4 3 3 Cancelling a Posting Request rrrrvrnnnvrnnnvrnnnnvnnenrnnnnrnrenvnnrnvnnnvrnsnnrnernrnnsnnnsnnrenenvenenrnnenvenenresennesennn 18 Es OUa SR EE ee eee enone eee eee 20 5 1 T le VILA AL AT o1 0 0 ERE 20 5 1 1 Inquiring the Journal Entry reerrvronnnnnvrverernvnnnvrvrnnnnnnvrnrr
15. assignment has to be done Enter Ledger as BSNS in case of BSNL South and BSNE in case of BSNL East Select Method as Automatic or Manual as per the requirements Enter Start Date End Date Optional Select the Sequence which has to be tagged to the selected category Click Ctrl S The document sequences are assigned and saved OD ENN DOV Oe Ns Confidential 37 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 10 Categories Category is the document type of the journal which distinguishes one journal from another The Category name is unique for a particular type of journal By default for Invoice generation the Category is IV which is defined during configuration 10 1Journal Categories Window The category window is used to define the category Tasks that can be performed using this window are e Defining additional categories for manual entries The screenshot for Journal Categories is given below ES Oracle Applications lolx File Edit View Folder Tools Window Help ORACLE HVO QZSS hex Laana AY Navigator BSNL South GL Superuser Functions Documents Processes Setup Journal Categories Category Category Key Description NE f Figure 15 Journal Categories window Field References The Field Name and Description of all the fields that appear Journal Categories window is given below Table 10 Field References for Journa
16. cations Accounting User Manual About this Manual Purpose This manual has been written to help you understand and use the Oracle Applications Accounting It presents the functional capabilities and operational details and contains the procedures that you should know for performing your business tasks using Oracle Applications Accounting based on the roles assigned to the user The System Administration and Database Maintenance tasks have not been covered in this manual For more information about these functions please refer to the System Administration Guide for Oracle Applications Accounting Intended Audience This manual is intended for the personnel in the Accounts department of Bharat Sanchar Nigam Limited BSNL Prerequisites Following are the prerequisites for performing the tasks presented in this manual Sina Prior knowledge of e Oracle Applications e Domain knowledge of Finance speil Prior knowledge of e PL SQL e Oracle Applications Organisation of the Manual Information in this manual has been organised as follows Organisation of this Manual Introduction Provides a brief introduction to Oracle Applications Accounting It also details the hardware and software requirements and interfaces with other systems Journal Provides description about creating Journals or Batches Posta Provides description about posting Journals or Batches Journal Batch In
17. counting periods can have one of the following statuses e Open Journal entry and posting is allowed e Closed Journal entry and posting are not allowed until accounting period is reopened Reporting and Inquiry are allowed e Permanently Closed Journal entry and posting are not allowed The status of the period cannot be changed Reporting and Inquiry are allowed Note When a period is closed permanently all prior periods is also permanently closed and can never be re opened e Future Entry Journal entry is allowed but posting is not allowed The accounting periods can be opened closed Once it is closed it can be reopened 11 10pen and Close Periods window The Open and Close Periods window is used to open new accounting periods close accounting periods reopen closed accounting periods Tasks that can be performed using this window are e Opening Closing Period through window The screenshot of Open and Close Periods window is given below Confidential 40 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Oracle Applications File Edit View Folder Tools Window Help ORACL voi sssgS PDA ADWIGS gt Open and Close Periods BSNL SOUTH Ledger Accounting Period Encumbrance Year Latest Open Latest Open Open Period Open Next Year Number Fiscal Year Status Period From Date To Date a Status Any x Period Fiscal Years Period Numbers Fro
18. created in the sequence window reflects in the dropdown list The sequences and the document s Application value as explained in Table 5 must be the same that is General Ledger Once a sequence assignment is defined the sequence name cannot be updated later If the sequence assignment has to disabled and assigned a new sequence to the document definition e Firstly enter an End Date to disable the current sequence assignment e Secondly create a new record row for the new assignment 9 2 1 Assigning the Document Sequences Prerequisites to proceed e User should login to Oracle Applications e User should have access to the Calendar window access depends on the role e Category should be defined Confidential 36 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual e Ledger Name should be configured e Document Sequence must be defined using the Document Sequences window as given in Section 8 1 1 e Since the effective dates for an assignment must fall within the sequence s start and end dates the list of available sequences depends on the start and end dates specified for the assignment Users e South DC Level 2 Based on zonal data centre user e BSNL South O amp M Based on zonal To assign document sequences Click Sequences gt Document gt Assign The Sequences Assignment window appears Select the value of Application field as General Ledger Select Category for which
19. d hide as needed 2 1 1 Using Shortcut Keys The Shortcut Keys that are present in Oracle Applications Accounting are given below Table 1 Shortcut Keys Screen Icon Keyboard shortcut Adding Inserting a new record A N A Searches the record as per the se N A criteria Find Show Navigators N A Saves the record PE Ctrl S Next Step N A Switching the responsibility EI N A Prints the document S Ctrl P Closes the form pay F4 Cuts the required content Ctrl X Copies the content a Ctrl C Pastes the content Fay Ctrl V Clears the selected record 7 F6 Deletes the record E Ctrl Up Edits the Field B Ctrl E Zoom cal N A Translations E N A Attachments A N A Folder Tools x N A Confidential 5 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Window Help 2 Ctrl H gt Querying the data N A F11 Retrieving the data as per the query N A Ctrl F11 provided Confidential 6 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 3 Journal A Journal is used for recording any transaction entries in the form of Debit Dr and Credit Cr for accounting purposes With the help of Oracle Applications a journal can be created in a batch or individually using the Journal Batch window 3 1 Journal Batch Window Using this window you can enter find or reverse a journal batch The screenshot for Journal window is given below
20. d to identify the journal entry in the General Ledger and the journal entry reports Reference Date Displays a date to which a journal can be referred It is in the format DD MON YYYY It complies with any other date information that is stored at the journal header level Post Button Click this button to post the unposted journal This button is visible only when the posting access is provided Autocopy Batch Button Click this button to copy the journal in the same or a different period Approve Button This button is not used Line Drilldown Button This button is not used T Accounts Button Click the button to view the journal in T format or Activity Summary Check Funds Button Reserve Funds Button View Results Button All these buttons are not used Confidential TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Field Name Description Change Period Button Click this button to change the period of an unposted journal The status of the period to which it can be changed should be Open Change Currency Click this button to the change the currency of the journal The currency is Button always INR 3 1 1 Entering the Journal Prerequisites to proceed e Status of the Period should be Open or Future Enterable e Document sequencing and assigning should be completed for the categories Users e HYD GL Based on SSA name that is SSA le
21. e a report the parameters should be passed in the relevant fields The following reports can be generated are e Trial Balance e Account Analysis 180 Char The screenshot of Submit Request window is given below Oracle Applications File Edit View Folder Tools Window Help CRETA FTE EEFI Submit Re quest Run this Request Name RR Operating Unit Parameters f Language Language Settings Debug Options At these Times Run the Job As Soon as Possible Schedule Upon Completion M Save all Output Files Layout Notify Print to Help C Da Figure 10 Submit Request window Options 3 Field References The Field Name and Description of all the fields that appear in Submit Request window are given below Confidential 22 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Table 5 Field References for Submit Request window Field Name Description Displays the name of the report Choose the relevant option from the dropdown list Name e Trial Balance e Account Analysis 180 Char Operating Unit This field is Not Applicable If the report selected is Trial Balance enter the values in the following fields as given below e Ledger Ledger Set BSNS e Ledger Currency INR e Currency Type Total e Entered Currency N A e Pagebreak Segment It is a list of v
22. e journal entries is used to reverse the following type of transactions Accrued Income Advance Income Errors or Temporary Adjustments The reversal of the Accrued Income and Advance Income is done on the first day of April every financial year Confidential 12 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Prerequisites to proceed e Status of the Period should be Open e Journal batch should have Status as Posted Users e HYD GL Post Based on SSA name that is SSA level user e South DC Level 2 Based on Zonal Data Centre user e BSNL South Admin Based on Zonal To reverse a journal or batch 1 Click Journals 9 Enter The Find Journal window appears 2 Query the batch and journal within the batch for which a reversal period has to be assigned 3 Click Find The Enter Journal window appears Note Click Reverse Batch in the Enter Journals window for reversing a batch 4 Click Review Journal The Journals window appears 5 Select the period from the dropdown list and the Reversal method as Switch Dr Cr in the Reverse section Note Once these values are entered the journal entry is marked for reversal 6 Click Reverse The Journal is reversed The screenshot for Reverse Batch is given below Oracle Applications File Edit View Folder Tools Window Help ORACLE DALM ER YEE MEE rA 2 SNL SOUTH g Batch Status Source Category Period Batch Name Journal Name C
23. eeeeeeeeeeeeceeeeeaeeseaeeseaeeseaeeseaeeseaeeeeaeeseaeeeeaeeseaeeenaees 43 Glossan aaret 45 The total number of pages in this document including the cover page is 58 Confidential viii TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual List of Figures FIGURE 1 BUSINESS PROCESS FOR ACCOUNTING eseressorsessenrstesesevassssssenketssevenssessenserstsneresesesssvneseterevene 1 FIGURE 2 JOURNAL WINDOW Tan lukuedad 7 FIGURE 3 FIND JOURNALS WINDOW evrvrvvevrvrvrvrsvrnesrerenenesrersnsvesssrsvenenrersvenesssrsvenesesrsvsneneseevsvenesrsvsvevesee 10 FIGURE 4 BATCH WINDOW c cscescscscscssscssesescscssscecscscsecscscscsscsvscscsssvacsesssvacsesscsvacscsseevacsesessvavsesasevacess 11 FIGURE 5 JOURNALS WINDOW csssxsssccssaseaetsuhonisodserstiussoasexcdourwnideseanisiony aneierantnsevbavneddeviemstodenenedoniesarieds 12 FIGURE 6 REVERSE BATCH esorovrsrenesenrorsserevnnsssenensorsssvevasnssenenssssssvenessssenansersssvevavesesseneessssvevenssssnennnsseen 13 FIGURE 7 POSTING FROM JOURNAL WINDOW svrvrvrstrvrnesrsrsvrvenrsrsevnnenestevenenesrevenesssvsvenenesrsvenenesssvenenesee 14 FIGURE 8 POST JOURNALS WINDOW srsrsvrvrvrsrsrsvrnesrsrenenesrsrevsvenssrevenentsvevenenesrevsnesesrevsnenessevevenesrevsvevesee 16 FIGURE 9 JOURNAL ENTRY INQUIRY WINDOW u ccccscscssesesescscscscescssscscsscscecsesscsvecsesscevacsesscstavscssevecees 20 FIGURE 10 SUBMIT REQUEST WINDOW c ceccscsescssecssesessecssescssscscsecsv
24. ess to all the SSAs of that particular zone SOUTH DC LEVEL 2 e Enter Manual Journals e Inquire Journals Confidential 2 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual BSNL SOUTH ADMIN BSNL SOUTH O amp M Confidential Reverse Journals Post Journals Run Reports Add periods to a Calendar Define and Assign Sequences Open and Close Period Year End Activities Enter Manual Journals Reverse Journals Inquire Journals Run Reports View Values Add periods to a Calendar Viewing Sequences Viewing Categories Open and Close Period Year End Activities Inquire Journals Run Reports Add Values Define and Assign Sequences Add Categories TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 2 Getting Started 2 1 Using Menus and Toolbars You can use menus and toolbars to access Oracle Applications Accounting functionality A menu displays a list of commands Some of the commands have images next to them so you can quickly associate the command with the image Most menus are located on the menu bar at the top of the application window Shortcut menus are available when you right click text objects or other items A toolbar contains buttons with images the same images you see next to corresponding menu commands menus or a combination of both Oracle Applications Accounting includes many built in toolbars that you can show an
25. est 1 Select View gt Requests on the menu bar The Find Requests window appears 2 Click Find The Submit Request window appears The Status of the request can be viewed 3 Click View Output The report can be viewed in txt format 6 2 2 Cancelling a Request To cancel a journal batch posting request 1 Click View gt Requests on the menu bar The Find Request window appears 2 Verify that the concurrent request for the batch has a Status as Pending 3 Click Cancel Request The Request is cancelled Confidential 25 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 7 Values When the values for the segments are defined it is referred as Chart of Accounts and is in the format of Zone Circle SSA GL Code The values of Chart of Accounts helps in recording and reporting the accounting information The values for the segments can be entered using the Segment Values window 7 1 Segment Values window This window deals with adding new segment values for Circle SSA and GL code The screenshot for Segment Values window is given below Oracle Applications File Edit View Folder Tools Window Help aAveOl s2a GS One RI ADIGE Oc Segment Values Value Set Key Flexfield Descriptive Flexfield C Concurrent Program Name Dependent Value Set Independent Value Values Vv Values Effective Values Hierarchy Qualifiers Translated Enabled Value Value De
26. ffects the Trial Balance that is the amounts which are posted are reflected in Trial Balance In General Ledger a journal or a batch can be posted through the following e Journal window e Post window 4 1 Journal window In the Journal window individual Journal Batch is posted Tasks that can be performed using this window are e Posta Batch e Posta Journal The screenshot for the Journal window is given below Oracle Applications Be File Edit View Folder Tools Window Help ORACLE Avo Grao8 ODeRIADOAIS E pm f E7 Batch Status Source Category Period Batch Name Journal Name Currency Journal Debit Journal Credit Find Journals Batch Journal Ledger Source Period Category Currency Status Control Total Pasting Batch Funds Journal More Clear New Batch New Journal Find J v 4 gt Review Journal Review Batch Reverse Batch Requery New Journal New Batch Tax Batch Approve AutoCopy Figure 7 Posting from Journal window Note For the Field Name and Description of all the fields that appear in Journal window see Table 2 Field References for Journal Confidential 14 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 4 1 1 Posting a Batch Prerequisites to proceed Status of the Journals should be Unposted Users e HYD GL Post Based on SSA name that is SSA level user e South DC Level 2 Based on zonal data centre user To post a journal batch
27. from the Journal window Click Journals gt Enter The Find Journals window appears Query a batch or journal which has to be posted Enter the value for Posting as Unposted Click Find The corresponding batch journals appear on the Enter Journal window Select a batch which has to be posted Click Post A note Your concurrent request ID is number appears The status of the batch is updated to Posted ARON 4 1 2 Posting a Journal Prerequisites to proceed Status of the Journals should be Unposted Users e HYD GL Post Based on SSA name that is SSA level user e South DC Level 2 Based on zonal data centre user To post a journal batch from the Journal window Click Journals gt Enter The Find Journals window appears Query a batch or journal which has to be posted Enter the value for Posting as Unposted Click Find The corresponding batch journals appear on the Enter Journal window Select a batch which has to be posted Click Review Journal The Journals window appears Click Post A note your concurrent request ID is number appears The journal is posted PPh ee ON Confidential 15 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 4 2 Post window In the Post window multiple batches can be selected for posting at any given time Tasks that can be performed using this window are e Posta Batch e View the Request e Verify the status of the Request e Cancel the Posti
28. g And Assigning rrrsevrnsavnnnnvvnnnnvnnnnnnnnnnvnnnnvnnnnnvnnnnvnnnnnnennnvnnnnnnnnnnnnnnnnenn 33 9 1 Define Document Sequences rrrrnnnnennnvrnnnvnnenvrnnnvenesvrnnnvenesvnnsnvenesvnnsnnnnesnnnsnnenesvnnsnnenesnnnsnnenesnnesnvenenn 33 9 1 1 Defining the Document Sequences srrrnrrvrnnnvvnnrvrnnnnrnervrnnnnnnenvrnnnnnnnsnrenenenervrnsenvnssnrnsenenssnrnsenenennne 34 9 2 Assign Document Sequences marnnrarnrnnnnnnnsvrnnnnnnennrnnnnnnesnrnnnnrnesnrennnnnesnrennnrnennrenennnnsnrennvnenresennnennree 35 9 2 1 Assigning the Document SEQUENCES eccceeeeeeeeeeeeeeeeeeeeeeeeseaeeeeaeeseaeeseaeeseaeeeeaeeseaeeeeaeeseeeeeeeeeaes 36 10 Calegonesu 24422442 38 10 1 Journal Categories Window arnrnnnnnnenvrnnnnrnnanrnnnnrnnenvnnnnrnnsnrnsnnenennrenenenenrnssnnnsenrnnennerenensenensenrnsenvesenene 38 10 1 1 Defining additional categories for manual entries rrrvrnnnrrnorvrnnnvrnervrnrnvenerrnnrnvenennnnnrnrnesrnnennnenn 38 11 Open Close Period vasse 40 11 1 Open and Close Periods WiINdOW csecceeeeeeeeeeeeeeeeseneeeeeeseeeeeaeeeseaeesaeeesaeeeaeeseaeeseaeeseaeeseaeeseaeessaees 40 11 1 1 Opening Closing a Period mannenenvrnnnvrnervrnnnnvnnnnrnnnnvnrsnrnnenrensvrnsnvnnesvnnsnnnnenvrnssnnnssnrnsenressnrnsennesenn 41 12 Year End Closing ACU Vit eS vasse 43 12 1 Year End Activillesu isen Seeste cage s de laces tatieed decent eed dan line Juni EE EdaS 43 12 1 1 Performing Year End Activities cceecccceeeeee
29. g Calendar Calendar Description Enable Security Periods Quarter Adjusting Prefix Type Year Num From To Name iA Apr BSNL PeriodT 2011 1 1 01 APR 2010 30 APR 2010 Apr 10 bd May BSNL PeriodT 2011 1 2 01 MAY 2010 31 MAY 2010 May 10 i Jun BSNL PeriodT 2011 1 3 01 JUN 2010 30 JUN 2010 Jun 10 Jul BSNL PeriodT 2011 2 4 01 JUL 2010 31 JUL 2010 Jul 10 Aug BSNL PeriodT 2011 2 5 D1 AUG 2010 31 AUG 2010 Aug 10 a Sep BSNL PeriodT 2011 2 6 01 SEP 2010 30 SEP 2010 Sep 10 amp Oct BSNL PeriodT 201113 7 01 067 2010 31 OCT 2010 Oct 10 Nov BSNLPeriodt 2011 3 8 01 NOV 2010 BO NOV 2010 Nov 10 Dec BsnLPerodT 2011 3 9 01 DEC 2010 81 DEC 2010 Dec 10 anl BSNL Periodt 201114 10 01 JAN 2011 31 JAN 2011 Jan 11 Feb BSNL PeriodT 201114 1101 FEB 2011 28 FEB 2011 Feb 11 a Mar BSNL PeriodT 20114 12 01 MAR 2011 31 MAR 2011 Mar 11 Fi Apr Adj BSNL PeriodT 2011 4 13 01 APR 2011 30 APR 2011 Apr Adj 11 v May Adj BSNL PeriodT 20111 41 14 01 MAY 2011 31 MAY 2011 May Adj 11 v Jun Adj BSNL PeriodT 2011 4 15 01 JUN 2011 130 JUN 2011 Jun Adj 11 M I Figure 12 Accounting Calendar window Field References The Field Name and Description of all the fields that appear in Accounting Calendar window are given below Table 7 Field References for Accounting Calendar window Field Name Description Name of the Calendar is already defined during configuration Changes Calendar cannot not be made
30. he Find Key Flexfield Segment window appears 2 Enter the values in the following fields Application General Ledger Title Accounting Flexfield Structure BSNL_ACCOUNTING_FLEXFIELD Segment Select from the list of values Zone Circle SSA or GL code 3 Keep the cursor on Value field 4 Click EF located in menu bar A new record appears and is highlighted in yellow 5 Enter the Value which has to be added The Translated Value appears automatically 6 Enter Description of the value Enable V appears 7 Enter From date If the value has to be end dated then provide To date 8 Click Values Hierarchy Qualifiers tab The Value Translated Value and Description appear automatically Note DO NOT enter Parent Group and Level fields 9 Enter the Qualifiers 10 Click Ctrl S The segment value is saved 11 Click X located at the top right corner of the window A note Submitted request s to compile 1 value set hierarchies appears 12 Click OK The Segment Values window closes Confidential 28 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 8 Calendar Calendar in Accounting relates to the current fiscal year The date which is represented in the Journal comes from this Calendar BSNL follows the fiscal calendar year and three adjusting periods that is April to March as fiscal year and April to June of next year as adjusting periods Tasks that can be performed using this
31. ing the Status of the Request can be performed for both Journal Window Section 3 1 and Post window Section 3 2 4 3 1 Viewing the Request To view the request 1 Click Post A concurrent request to post the selected journal batches is submitted at the backend 2 Review the Posting Execution Report Posting Single Ledger to determine if there were any errors during posting after the concurrent process is completed Note If any of the requested batches are not successfully posted a Warning appears and is highlighted in yellow If the request is successful then the Phase becomes Completed and the value of the Status becomes Normal 4 3 2 Verifying the Status of the Request To verify the status of the Request name Posting Single Ledger 1 Select View gt Requests on the menu bar The Find Requests window appears 2 Click Find The Submit Request window appears The Status of the request can be viewed 4 3 3 Cancelling a Posting Request To cancel a journal batch posting request Users e HYD GL Post Based on SSA name that is SSA level user e South DC Level 2 Based on zonal data centre user 1 Click View gt Requests on the menu bar The Find Request window appears 2 Verify that the concurrent request for the batch has a Status as Pending 3 Click Cancel Request The batch status resets to Postable Confidential 18 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Note Review
32. iry window through Inquiry gt Journal The Find Journals window appears Note When the Journal Entry Inquiry window is first navigated the Find Journals window appears automatically After the query is run the Find Journals window can be reopened by selecting View gt Find from the menu bar 2 Enter query parameters to find the batch or journal for review in the Find Journals window Note Select the More button to see additional fields that can use to refine query To hide these extra fields select the Less button 3 Click Find The journal batches or journals that meet the query criteria appear in the Journal Entry Inquiry window 4 Select any of the following e Review Batch Click this button to view the number of journals formed in a batch e Review Journal Click this button to view the detailed information about the journal entries formed in a batch e T Accounts Click this button to view the accounting entries in a graphical T account format Confidential 21 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 6 Reports The Accounting system provides reports which are generated as per the users requirements These reports provide the consolidated view on the basis of GL Code Zone Circle SSA The reports can be generated and viewed using the Submit Request window 6 1 Submit Request window The Submit Request window is used to select the report to be generated In order to generat
33. l Categories window Field Name Description Category This is a mandatory field Enter the name of the category as per the choice for the user It should consist of two alphabets For example IV PS and so Category Key on This is an optional field Provide the description about the category For Description example IV means Invoice Generation PS means Payments Settlement and so on 10 1 1 Defining additional categories for manual entries Prerequisites to proceed e User should login to Oracle Applications Confidential 38 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual e User should have access to the Calendar window access depends on the role User1 e BSNL South O amp M Based on zonal To define new category for manual entries Click Setup gt Journal gt Categories The Journal Categories window appears Enter the values for Category Category Key the values should be same Enter a Description to the category defined Click Ctrl S The category is defined and saved Po ONS Confidential 39 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 11 Open Close Period Open and close accounting periods are used to control the journal entry and journal posting as well as compute the period end and year end actual account balances for reporting Open and close accounting periods can be done in two ways e Open and Close Periods window Ac
34. m From To To Figure 16 Open and Close Periods window Field References The Field Name and Description of all the fields that appear in Open and Close Periods window are given below Table 11 Field References for Open and Close Periods window Field Name Description Ledger This is a non editable field It is pre defined as part of configuration Status This is a dropdown list The status can be Closed Future Entry Open and Permanently Closed Period These are non editable fields They are first defined while adding periods to the calendar Period Number Fiscal Year From Date To Date 11 1 1 Opening Closing a Period Prerequisites to proceed e User should login to Oracle Applications e User should have access to the Calendar window access depends on the role Confidential 41 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual e Calendar of the fiscal year should be defined Users e South DC Level 2 Based on zonal data centre user e BSNL South Admin Based on zonal To open close period through window Click Open Close The Find Periods window appear Click Find The Open and Close Periods window appear Click Open Period to open the next period Note Skip Step 3 and go to Steps 4 and 5 if an open period has to be Closed or Permanently Closed Click the status of a particular open period which has to be closed
35. nfidential ii TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual PF3020 Document Release Note Notice No Customer BSNL Project BSNL CDR1 Document details Version no Oracle Applications Accounting Version1 0 User Manual Revision details Previous page no Action taken add del change New page Description This guide provides information about the functionalities of Oracle Applications General Ledger It also provides the procedures and tasks that the user need to know to perform the business tasks more efficiently Revision description Change Register serial numbers covered The documents or revised pages are subject to document control Please keep them up to date using the release notices from the distributor of the document These are confidential documents Unauthorised access or copying is prohibited Approved by Date Confidential Authorised by Date TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual PF2060C Document Revision List Customer BSNL Project BSNL CDR1 Document Name Oracle Applictions Accounting User Manual Release Notice Reference for release Rev Revision Revision Page Previous Action Addenda Release No date description no page no taken New page notice reference Confidential iv TATA CONSULTANCY SERVICES Oracle Appli
36. ng 1 2 Features of Oracle Applications Accounting The following are some important features of Oracle Applications Confidential 1 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual e Data that is received from various source systems PMS ES Billing is placed into the database This data will be used to generate the Trial Balance and Account Analysis Reports e Contains the Journal form which is used to create post the Manual entries at the end of the fiscal year 1 3 Oracle Applications Environment This section describes the software and hardware environment required to run Oracle Applications Accounting 1 3 1 Software Environment Operating System IBM Unix Database Oracle 10g Server Software s Oracle E Business Suite Applications Release 12 0 Media Pack for IBM Unix Other Software s Oracle Developer putty 1 3 2 Hardware Environment Servers None Network Infrastructure None Communication None Infrastructure Other Hardware None 1 4 User Roles This section describes the roles and responsibilities of the various users that Oracle Applications Accounting supports e Enter Manual Journals e Run Reports e Inquire Journals HYD GL Post e Enter Manual Journals e Run Reports e Inquire Journals e Post Journals e Reverse Journals SOUTH DC LEVEL 1 e Enter Manual Journals e Inquire Journals e Run Reports Note Acc
37. ng Request e Review the Batch Posting Status The screenshot for the Post Window is given below Oracle Applications ojx File Edit View Folder Tools Window Help ORACLE Total Entered Balance Period Batch Type Debit Credit Control Total Find Journal Batches Period Balance Type v Batch Budget Encumbrance Any Total Entered Debit Entered Credit Control Batch Informati Clear Post Batch Sraraz Review Batch Post Figure 8 Post Journals window Field References The Field Name and the Description of all the fields that appear in the Post window is given below Table 3 Field References for Post window Field Name Description Period Displays the month and the year for the transaction to be posted Choose the relevant period from the dropdown list Balance Type Displays the type of the balance of the journal Note The value for the Balance Type should be always Actual Batch Displays the name of the batch to be posted This field is optional Total Confidential 16 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Field Name Description Entered Debit Displays the debit amount of the batch This field is optional It helps in querying a batch easily Entered Credit Displays the credit amount of the batch This field is optional It helps in q
38. ng solution which supports the accrual accounting at a consolidated level Ledgers are maintained at the Financial Accounting level and Subledgers at the Billing system level GL accounts are defined at the corporate level and used at the SSA level in order to facilitate the SSA level accounting Identification of Revenue Receiving and Revenue Owning Secondary Switch Area SSA is required in order to process all the Remittance transactions This infomation is provided by Payment Management System PMS and Billing system with respect to the Call Detail Records CDR Oracle Applications Accounting deals with the following external interfaces e Billing system e Payment Management System PMS e Electronic Stapling ES The representation of the various processes that interact with the Accounting system is given below Electronic Stapling System Figure 1 Business process for Accounting The main sources of information for General Ledger are e Billing System e Payment Management System e Electronic Stapling System e Manual journal entries for period closing 1 1 Purpose of Oracle Applications Accounting The main purpose of Oracle Applications Accounting is to keep track of all the financial information that it receives from different sources mentioned above for generating the Trial Balance and Account Analysis reports It records the information about the Journals Accounting entries and so on for Telecom Revenue Accounti
39. period The Name appears automatically once the Year is entered 7 Enter a number to specify which Quarter of the fiscal year the accounting period is in 8 Enter the Num of the period within the fiscal year 9 Enter the range of dates From and To when the accounting period begins and ends 10 Select the checkbox if the period is Adjusting 11 Click Ctrl S The calendar is saved 12 Click X to close the Accounting Calendar window Full calendar validation request is launched as a backend process Confidential 31 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Note To validate the current calendar navigate to View Requests on the menu bar to view or print the Calendar Validation Report This report helps to identify any errors in calendar that might interfere with the proper operation of General Ledger Confidential 32 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 9 Document Sequencing And Assigning The Document sequencing and assigning is used to create the document number for each journal automatically It can be divided into two parts e Define Document Sequences e Assign Document Sequences 9 1 Define Document Sequences Every journal is associated with a document number Whenever a journal is saved a document number is assigned to it Tasks that can be performed using this window are e Defining the document sequences The screenshot for Document Seq
40. quiries Provides description about inquiring the existing Journals or Batches Reports Provides description about the reports generated as per the requirement of the user Values Provides description about the procedures for creating the segments of Circle SSA and GL Code Calendar Describes the procedure for adding a new calendar for the fiscal year Document Describes the sequencing and assigning of the journal which fall under different Confidential v TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Sequencing categories and Assigning Categories Describes various categories of Journals or Batches Open Close Describes the procedure for opening or closing a period period Year End Describes the various activities that are performed at the end of the Year Closing Activities Typographical Conventions The following table gives the details of the typographical conventions used in the document Typographical Conventions Formatting Type of Information Convention Bold e Keys on the keyboard appear in title case first letter in upper case For example Enter e Buttons check boxes Commands that you choose from the menus or dialog boxes appear in title case and in bold font For example Click View from the menu bar e Navigation to the particular window For example Journal gt Enter Italics Messages Courier New Names of the tables Blue Cross References
41. re already explained Table 2 Field References for Journal window The additional references are given below Table 4 Field References for Journal Entry Inquiry window Field name Description Review Batch Button Displays detailed information about the selected journal batch in the Batch window From the Batch window select the Journals button to navigate to the Journals window where the journals associated with the batch can be reviewed Displays detailed information about the selected journal in the Journals Review Journal Button window Confidential 20 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Field name Description Line Drilldown Button This button is not used Displays the accounting entries in a graphical T account format in the T T Accounts Button Accounts window The T accounts functionality can also be accessed from the Tools menu in the Journals window by selecting the T Accounts option 5 1 1 Inquiring the Journal Entry Prerequisites to proceed Journals should have been already created Users e HYD GL Based on SSA name that is SSA level user e HYD GL Post Based on SSA name that is SSA level user e South DC Level 1 Based on zonal data centre user e South DC Level 2 Based on zonal data centre user e BSNL South Admin Based on zonal e BSNL South O amp M Based on zonal To inquire a journal entry 1 Navigate to the Journal Entry Inqu
42. rnnrnererrensernvansrrsvnnnerrnrrenernnrnerererensrssrrerennnn 21 Ge ROP ONUS Luang 22 6 1 Submit Request window ccecceeeceeeseeeeeeeeceeeseaeeseaeeceaeessaeeseaeesaaeeseaeessaeeseaeeseaeeseaeessaeeseaeeseaeeseeeseaees 22 6 1 1 Submitting the Request to generate Reports rrrnrnvrnnnvrnnnnvnnnvrnnnnrnrnvrnnnnrnnrnrnnrnrerrnrenenvenenrnnsnnnsennn 24 6 2 Status Of the Request nnu guru kem gni ddmd i a NEA ideer der fest EEE ET 24 6 2 1 Verifying the status of the Request rrrnrnvnnnnnvnvrnnnnnvrnnrennvennrrnvrenrrnnrnrrrnrnnerenrresrrnvrnerererensrsnrrerennnn 25 6 2 2 Cancelling a Request rrnnrornrnnnnvnnrvrnnnnnnervrnnnnrnnsnrnnnnnnesernnnnnnnsnrnsnnnnennrennnnnnnresennnenrenenvnnrnresennnennsee 25 Confidential vii TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual E WMS aan eee 26 7 1 Segment Values window rrrrnnrnnnnvnnnnrnnenvnnnnvrnnnvnnenvrnennnnenvrnrnvenenvnnsnensenrenenvnnenernssnnnevresnnnnernressnneennnene 26 7 1 1 Adding values to existing Segment Values rnrnnrnnnnrnnnnvnnnnvnnnnvnnnnvnnnvrnnnnnnenvrnnnnrnnrnrnnenvnnenrenenvenennnn 28 gt E O 1110 E T EEE EE eee ee eee ee 29 8 1 Accounting Calendar Window rnanvrnenvrnnnvrnvnvrnnnnrnervrnnnnenesvrnsnnenesvrnnnnenssnrnsnnnennrnnenvenenrenenenssnrnsennnennnne 29 8 1 1 Adding Periods to the existing Calendar ssnrrranrnnnnrnnnnvnnnnvnnnvrnnnnrnnnnrnnenrnernrnnnnrnnenrnnenrnsenrenenvenennnn 31 9 Document Sequencin
43. s 1 Navigate to the Enter Journals window 2 Query the batch whose status has to be reviewed 3 Select Review Batch General Ledger automatically displays the Posting Status for selected journal batch Note Confidential 17 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual i Batches can remain Unposted for a number of reasons including control total violations and posting to closed periods General Ledger may also indicate that the batch is Processing or has been selected for posting but has not yet run The batch may not have posted due to an Error such as an invalid journal entry line ii When posted to an earlier open period actual balances rotate forward through the latest open period iii If posted a journal entry into a prior year General Ledger adjusts the retained earnings balance for the effect on revenue and expense accounts iv Runa Trial Balance Report whenever post to a previous fiscal year to ensure that Retained Earnings account is properly reconciled 4 3 Status of Posting Request Whenever you click Post the Posting Single Ledger request process runs at the backend Once the request is executed the user can review the report for the errors that occurred during posting The following tasks are applicable for both the ways of posting Journal and Post window e View the Request e Verify status of the Request e Cancel a Posting Request Note Viewing the Request and Verify
44. s of the original journal entry This method is often used while reversing the accruals Reverse Button This button is enabled only after a journal is posted Hence the journal can be reversed only after it is posted Lines Line Displays the line number of a journal For the first line a number 1 has to be assigned and thereafter for the other lines it is auto populated Account Displays the account in the format Zone Circle SSA GL code Select an option from the dropdown list Debit INR Displays the debit amount of the journal It does not accept any special characters like comma and so on For example Enter 1000 and not 1 000 Credit INR Displays the credit amount of the journal It does not accept special characters like comma and so on For example Enter 1000 and not 1 000 Description Displays the description of a line of a journal for future reference Acct Desc The description of Account line reflects in this field For example S AP HYD 1110101 the Acct Desc is South Andhra Pradesh Hyderabad Sundry Debtors Other Information Tab Optional This is an auto populated field which displays the source field indicating the origination of the journal entry When any manual entry is passed it Source has the value as Manual Otherwise it can be Billing PMS or ES from where the data has originated Reference Displays the reference description which is use
45. scription From To I iw ae X Define Child Ranges f Move Child Ranges Figure 11 Segment Values J Field References The Field Name and Description of all the fields that appear in Segment Values window are given below Table 6 Field References for Segment Values window Confidential 26 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Field Name Description Values Effective tab Value Enter value for Circle SSA and GL Code e Circle It is two character values in alpha For example AP for ANDHRA PRADESH e SSA Itis three character values in alpha For example HYD for HYDERABAD e GL Code It contains 7 digits For example 1110101 for Sundry Debtors Telephone Translated Value Displays the characters of the Value field by default Enter the description of the value It is reflected automatically on different Pesenpion windows For example Enter Journals window Reports and so on Enabled Check the Enabled checkbox to make the value effective From To have the value effective for a limited time enter a start date and or end date for it The value is valid for time including the From and To dates To Note The values from this window cannot be deleted because they are referred in the system But it can be disabled at any time This field is Not Applicable Val
46. scscsscscscsesesvacsesscevacssesssvavscsseevasees 22 FIGURE 11 SEGMENT VALUES u0 cccsccccsssescssscssescscscscescscscsssscscscsesscsvscscescscssscssesvacssessevacscssssvavaceueevaeas 26 FIGURE 12 ACCOUNTING CALENDAR WINDOW csccscscssesesescscssscsscscssscsscscacsesscscacscsscscassesscscavscssscasans 30 FIGURE 13 DOCUMENT SEQUENCES WINDOW csccccscsssssssescscssscsscscssssssescscscsscssacscsssscassessescavsceseevasaes 33 FIGURE 14 SEQUENCE ASSIGNEMENTS WINDOW ccccccsesssesessscssescscscsssessscscssessasscsssscasscsscsvsvseeseesseaes 35 FIGURE 15 JOURNAL CATEGORIES WINDOW c ccccccsesessecssesescscscsscsssssssscscscssscssscscesescassessestavsesueeeaeaes 38 FIGURE 16 OPEN AND CLOSE PERIODS WINDOW c cscscesssescscscscescssscscssessscscsscscecscsscsvacsssesvavsessevaces 41 FIGURE 17 NOTE OF SUBMISSION OF CONCURRENT REQUEST osvrvrvrvrrrsvrvnsesssnevesesrensvesessevenesessevsveseseen 42 Confidential ix TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual List of Tables TABLE 1 SHORTCUT KEYS enk eisdenestiikaalaumdsadstunainsiigali 5 TABLE 2 FIELD REFERENCES FOR JOURNAL WINDOW sorvrvrsrsvrvrvesrsvevesestsvevesessevevesesesvevereseenevesesseveveveseen 7 TABLE 3 FIELD REFERENCES FOR POST WINDOW c cccscesesssesescscesesssvscssesscscscessscscsssscassesscsvavsesseeseas 16 TABLE 4 FIELD REFERENCES FOR JOURNAL ENTRY INQUIRY WINDOW orvrsvrvrvrsesrevsvrsessevevesersevsveseseer 20 TABLE 5 FIELD
47. st of values either Account Segment Balancing Segment Source 6 1 1 Submitting the Request to generate Reports Prerequisites to proceed e User should login to Oracle Applications e User should have access to the Segment Values window access depends on the role e Journals should be posted in order to be reflected in both the reports e HYD GL Based on SSA name that is SSA level user e HYD GL Post Based on SSA name that is SSA level user e South DC Level 1 Based on Zonal Data Centre user e South DC Level 2 Based on Zonal Data Centre user e BSNL South Admin Based on zonal e BSNL South O amp M Based on zonal To submit the request to generate the Reports Click Reports gt Request Submit a New Request window appears Select Single Request Click OK The Submit Request window appears Select the Request Name Click Parameters field The Parameters window appears Select the Parameters for the relevant Reports Click OK The Parameters window closes O N D 0 e N Click Submit A note appears with the Request ID The Request to generate the reports is submitted 6 2 Status of the Request Once the Request is submitted the process starts at the backend The status can be viewed or checked in Submit Request window Confidential 24 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 6 2 1 Verifying the status of the Request To verify the status of the Requ
48. tch is used by default Confidential 7 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Field Name Description Description Displays the description of the journal entry Ledger Displays the name of the ledger By default the value is BSNS for BSNL South and BSNE for BSNL East Category Displays the purpose of the journal entry All lines in a journal entry share the same journal category Select an option from the dropdown list Whenever the entry is manual select the values as AD or Al The other values in the list are applicable for different source systems like Billing PMS and ES Do not select ZZZ ZZZ159 as these values are not applicable to Accounting Period Displays the month and the year of the transaction for which the journal was entered Select a period from the dropdown list which is either Open or Future Enterable e If a period is entered at the batch level the same period must be used for each journal entry in the batch e If a period is not entered at the batch level select any Open or Future Enterable period for a journal entry Effective Date Displays the first day of the period selected by default It is in the format DD MON YYYY The date can be changed according to the transaction Balance Type This is a non editable field which displays the type of the entry The value is Actual by default Document Number Displays a unique doc
49. the batch posting status to determine whether the selected batch was posted successfully If a batch is not posted changes can be made to the batch and its entries Once a batch is posted no information can be changed that affects the balances such as accounts or debit and credit amounts However the reversal period for entries in the batch can be reversed Confidential TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 5 Inquiry Inquiring is a process of finding the journals which were already created in the General Ledger The user can only view the journals but cannot modified or posted 5 1 Inquiry Window The Inquiry window is used to inquire and review the journals on the basis of the parameters provided The tasks that can be performed using this window are e Inquiry of Journal Entry The screenshot for Journal Entry Inquiry window is given below Oracle Applications File Edit View Folder Tools Window Help ORACLI Avo Bros 5687 45075 Joumal Entry inquiry BSNL SOUTH Batch Status Source Category Period Batch Name Journal Name Currency Journal Debit Journal Credit O Find Journals Batch m Journal Ledger Source Period Category Currency Status o Control Total Posting Batch Funds Journal More 4 gt Review Journal Review Batch Requery Figure 9 Journal Entry Inquiry window Field References Some of the Field References a
50. to this field Description to the calendar is defined Changes should not be made to this field Do not enable this field The access will be restricted to the user according to their roles Description Enable Security It is a prefix for a period for each accounting period General Ledger Prefix combines this prefix with the year to create the period name For example Jan Feb Mar and so on Type It is a Period Type It is always BSNL Type It is the year of the accounting period when the fiscal year ends For Year example if fiscal year begins in 2010 and ends in 2011 enter 2011 for all periods in the fiscal year A number to specify which Quarter of the fiscal year the accounting period Quarter oa f is in General Ledger uses this number to determine how the accounting Confidential 30 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Field Name Description periods rotate up for quarter to date balances It has to be defined between 1 to 4 For the adjusting periods it is always 4 The Number of the period within the fiscal year The number of the Num accounting periods are sequential based on the period starting dates specified in the From To range Select this value from the calendar The range of dates From and To From represents when the accounting period begins and ends To The from date and to date for the adjusting period are Apr Adj
51. uences window is given below E3 Oracle Applications BEE File Edit View Folder Tools Window Help ORACLE AYO EZISH RNA AASEN Ay Navigator BSNL South GL Superuser Functions Documents Processes Setup Financials Sequences Document Define Document Sequences Effective Message Initial Value fe Name Application From To 16 DEC 2008 Figure 13 Document Sequences window Field References The Field Name and Description of all the fields that appear in Document Sequences window is given below Table 8 Field References for Document Sequences window Field Name Description Name Enter the name of the Document Sequence Once saved sequence names cannot be changed Application It always has the value as General Ledger Select from the List of values Once saved the application associated with the sequence cannot be Confidential 33 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual changed Effective From The date is in DD MON YYYY format Enter the dates on which the document sequence takes effect is no longer enabled e From field automatically defaults to the current date and once a sequence is defined the start date cannot be changed Effective To e If the To field is left blank the document sequence does not expire and if enter an end date and define the sequence the end date
52. uerying a batch easily 4 2 1 Posting a batch Prerequisites to proceed The status of the Batch should be Unposted Users e HYD GL Post Based on SSA name that is SSA level user e South DC Level 2 Based on zonal data centre user To post a batch from the Post window Click Journals gt Post The Find Journal Batches window appears Select Period Select Balance Type as Actual Click Find The Post Journals window appears Pon gt Select the checkbox next to each batch The corresponding batch is selected Note There are two options i A batch can be reviewed and posted follow Step 5 to 8 OR ii A batch can be posted directly follow Step 8 5 Click Review Batch The Batch window appears The details of journal batch can be reviewed 6 Check the Period Status and Post Status to determine if a batch is available for posting Note The batches can be posted only when the status of the Period is Open 7 Verify the Control Total for the journal entry batch if it was entered manually in the Journal entry Noite If the Control Total is not equal to the Total Entered Debits and Total Entered Credits the batch cannot be posted 8 Click Post A note Your Posting concurrent request ID is number appears The batch is posted 4 2 2 Reviewing the Batch Posting Status Users e HYD GL Post Based on SSA name that is SSA level user e South DC Level 2 Based on zonal data centre user To review the batch posting statu
53. ues Hierarchy Qualifiers tab Value Enter value for Circle SSA and GL Code e Circle It is two character values in alpha For example AP for ANDHRA PRADESH e SSA Itis three character values in alpha For example HYD for HYDERABAD e GL Code It contains 7 digits For example 1110101 for Sundry Debtors Telephone Translated Value Displays the characters of the Value field by default Enter the description of the value It is reflected automatically on different DAR windows For example Enter Journals window Reports and so on Parent Group These fields are Not Applicable Level For Circle and SSA enter the following Qualifiers Allow Budgeting No Allow Posting Yes Qualifiers For GL Code enter the following Qualifiers e Allow Budgeting No e Allow Posting Yes e Account Type Asset or Expense or Liability or Ownership Stockholders or Revenue Confidential 27 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Field Name Description e Third Party Control Account No e Reconcile Yes i This field is Not Applicable 7 1 1 Adding values to existing Segment Values Prerequisites to proceed e User should login to Oracle Applications e User should have access to the Segment Values window access depends on the role User1 BSNL South O amp M To add new segment values the Segment Values 1 Click Values T
54. ument number for every entry It is auto populated when a journal or a batch is saved The document number appears on the basis of sequencing and assignment done for the categories Clearing Company This field is not used Tax This field is not used Control Total Verifies that the total debits and the credits for the journal lines are equal to the amount provided in this field Conversion Currency Displays the currency of the journal By default the currency is Indian Rupee INR Date Displays the date of conversion which is same as Effective Date It is in the format DD MON YYYY Type This is a non editable field which displays User by default Rate This is a non editable field which displays the value as 1 by default The Rate cannot be converted from one currency type to another Reverse Date Displays the date for which the reversal of the journal has to be passed Reverse Period Displays the month and year for which the reversal of the journal has to be passed Select an option from the dropdown list It is applicable only when the status of the period is Open Reversal Method Displays the method by which the journal can be reversed By default it is Switch Dr Cr General Ledger reverses the journal by switching the debit Confidential TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Field Name Description and credit amount
55. urnal entries and then post them again Common reasons for unpostable batches include e Control Total violations if used e Posting to unopened period e Unbalanced journal entries 13 Run Trial Balance Report as explained earlier in Reports section Confidential 43 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 14 Close the last period of the fiscal year using Open and Close Periods window Note Open the first period of the new fiscal year to start a concurrent process to update account balances Opening the first period of a new year automatically closes out the income statement and posts the difference to the retained earnings account which is specified while setting up of a Ledger Confidential 44 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Glossary Accrual Accounting A system of accounting in which revenues are recorded when earned and outlays are recorded when goods are received or services performed even though the actual receipt of revenues and payment for goods or services may occur in whole or in part at a different time Credit An accounting entry which results in either a decrease in assets or an increase in liabilities or net worth Debit An accounting entry which results in either an increase in assets or a decrease in liabilities or net worth Confidential 45 FAA AT AEA FAT IN SA AA AA ARAFAT AA TATA ATATAT N
56. urrency Journal Debit Journal Credit E Manua v SEP 08 Test for SR 22 SEP 2C Test for SR NR 300 00 300 00 Posted Manua v SEP 08 Testing SR 17 SEP 2C Testing SR NR 100 00 100 00 Posted Manua v SEP 08 Testing after new setu Testing after new setup INR 150 00 150 00 Posted Manual v FEB 09 Testing for Remittance Testing for Remittance INR 1000 00 1000 00 Posted Manua v FEB 09 Testing for Remittance Testing for Remittance INR 1000 00 1000 00 Posted Manua v FEB 09 Testing for Remittance Testing for Remittance INR 800 00 800 00 Posted Manual V FEB 09 Testing for Remittance Testing for Remittance INR 1000 00 1000 00 Posted Manual v FEB 09 Testing for Remittance Testing for Remittance INR 1000 00 1000 00 4 3 Review Journal Review Batch Post Reverse Batch Requery New Journal New Batch Tax Batch Approve AutoCopy Figure 6 Reverse Batch Confidential 13 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual 4 Posta Journal Batch The journal entries appear on the Journal window based on the parameters provided either in the Journal or Post window The entries coming from different source systems like Billing PMS and ES are posted automatically The other entries which are manually entered in the Journal window Advance Income Accrued Income Gain or loss of foreign exchange transactions Reversal entries and so on at that instance has to be posted manually Posting of the accounting transactions a
57. vel user e HYD GL Post Based on SSA name that is SSA level user e South DC Level 1 Based on zonal data centre user e South DC Level 2 Based on zonal data centre user e BSNL South Admin To enter a journal batch 1 Click Journals 9 Enter The Find Journals window appears The screenshot for Find Journals window is given below Oracle Applications File Edit View Folder Tools Window Help ORACL EVOIGEISGP SIP SLADGYEN BETTE Batch Status Source Category Period Batch Name Journal Name Currency Journal Debit Journal Credit Find Journals Batch e Journal Ledger Source Period Category Currency Status Control Total Posting Batch Funds Journal More Clear New Batch New Journal v gt Review Journal Review Batch Post Reverse Batch Reguery New Journal New Batch Tax Batch Approve AutoCopy Figure 3 Find Journals window 2 Enter any or all values for which the journals have to be entered Confidential 10 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Note i To enter a journal without entering the batch information click New Journal from the Find Journals window and proceed to Step 3 ii To enter journals for a new batch click New Batch from the Find Journals window and type the batch information iii To add journals to an existing batch query the batch from the Find Journals window and click Review
58. window are e Adding periods to the calendar Some of the important rules to be followed while adding the periods to an existing calendar e Accounting periods cannot overlap except for adjusting periods If any of the non adjusting accounting periods overlap General Ledger reports an error e Adjusting periods must overlap with the non adjusting periods e Periods of the same period type must be consecutively numbered in ascending order without gaps that is from 1 to 15 e All periods must have period numbers assigned between 1 and 15 for that period type e All periods must have quarter numbers assigned between 1 and 4 for that period type e All non adjusting periods contain the dates that span the entire fiscal year Note This includes the 29th day in February for leap years e Period ordering must be based on the period starting dates e The starting fiscal year must start no earlier than one year before the calendar year and end no later than one year after the calendar year e Periods are defined for the full year e Reports cannot be generated for a year that has no periods defined 8 1 Accounting Calendar window This window is used to add the periods to an existing calendar The screenshot for Accounting Calendar window is given below Confidential 29 TATA CONSULTANCY SERVICES Oracle Applications Accounting User Manual Oracle Applications File Edit View Folder Tools Window Help AYO AEEY EA EEEN O Accountin
59. with the sequence cannot be changed Category Select category from dropdown list for which the document assigning has to be done Ledger Name of the Ledger defined at the time of configuration that is BSNS in case of BSNL South and BSNE in case of BSNL East Method Select the value as Automatic from the dropdown list for the data coming from different sources and Manual for manual entry of the journal Assignment Tab Application Select the value as General Ledger from the dropdown list Once saved the application associated with sequence cannot be changed Category Select category from dropdown list for which document assigning has to be done Start Date The date format is DD MON YYYY Select from the calendar the dates on which the sequence assignment to the document definition takes effect The Start Date field automatically defaults to the current date and once a sequence assignment is saved the start date cannot be changed End Date The date format is DD MON YYYY e If the End Date field is left blank sequence assignment does not expire e If an end date is entered and sequence assignment is defined the end date cannot be modified later e If there is no end date defined and there are no active assignments for a sequence it can be disabled the sequence assignment by entering the current date as the end date Once disabled a sequence assignment cannot be reactivated Sequence The sequence
Download Pdf Manuals
Related Search