user training manual-gl

7/31/2019 User Training Manual-GL

1/54

1

USER TRAINING MANUAL

Sang Lin Tackle Sdn Bhd

Oracle General Ledger

Author :Sudhakara ReddyCreation Date :June 24, 2012Last Updated :June 24,2012Version :1.0

Module Lead Sign-off:

SLT Anthony Lee

YGL Approval:

William Lee


2/54

2

1 Document ControlChange Record

Date Author Version Change Reference

24-June-2012 Sudhakara Reddy 1.0 No Previous Document

Reviewers

Name Role Date Reviewed

Anthony Lee SLT Project Manager

Distribution

Copy No. Name Location

1 Library Master Project LibraryProject Manager


3/54

3

Content1 DOCUMENT CONTROL .................................................................................................................................. 2

2 GENERIC ORACLE APPLICATION USAGE ........................................................................................................ 4

2.1 TO LOG ON...................................................................................................................................................... 4

2.2 TO SWITCH YOUR RESPONSIBILITY .................................................................................................................. 52.3 TO CHANGE PASSWORD.................................................................................................................................. 52.4 TO SIGN ON AS A DIFFERENT USER.................................................................................................................. 52.5 NAVIGATION TO FORMS ................................................................................................................................. 62.6 TOOL BARS...................................................................................................................................................... 7

3 OPENING AND CLOSING ACCOUNTING PERIODS...................................................................... 8

3.1 OPENING PERIODS ........................................................................................................................................ 113.2 CLOSE PERIOD............................................................................................................................................... 13

4 DEFINE NEW ACCOUNT COA VALUES ........................................................................................... 14

5 DEFINING CURRENCIES ..................................................................................................................... 17

6 DEFINING CONVERSION RATE TYPES........................................................................................... 20

7 ENTERING JOURNALS ........................................................................................................................ 23

7.1 ENTER FUNCTIONAL CURRENCYJOURNALS(MANUAL) ............................................................................. 237.2 FOREIGN CURRENCYJOURNALS................................................................................................................... 287.3 REVERSEJOURNAL ENTRIES ......................................................................................................................... 30

8 JOURNAL APPROVAL .......................................................................................................................... 32

9 RUN GL REPORTS ................................................................................................................................. 36

10 GENERAL LEDGER REPORTS ............................................................................................................ 41

10.1 AVERAGE BALANCE TRIAL BALANCE REPORT ....................................................................................... 41

10.2

CHART OF ACCOUNTS LISTING............................................................................................................... 42

10.3 DAILY CONVERSION RATES LISTING....................................................................................................... 4310.4 CREATEJOURNAL ENTRIES EXECUTION REPORT.................................................................................... 4310.5 DETAIL TRIAL BALANCE REPORT ............................................................................................................ 4410.6 GENERAL LEDGER REPORT...................................................................................................................... 4510.7 JOURNAL ENTRY REPORT......................................................................................................................... 4610.8 JOURNALS -VOUCHER REPORT ............................................................................................................... 4710.9 POSTED JOURNALS......................................................................................................................................... 49

10.10 UNPOSTEDJOURNALS.............................................................................................................................. 5010.11 ERRORJOURNALS..................................................................................................................................... 5110.12 TRANSLATION TRIAL BALANCE REPORT ................................................................................................ 52

11 OPEN/CLOSED ISSUES ........................................................................................................................ 54

11.1 OPEN ISSUES............................................................................................................................................. 5411.2 CLOSED ISSUES ......................................................................................................................................... 54


4/54

4

2 Generic Oracle Application Usage2.1 To Log on

Use Internet Explorer to connect to ERP system using the URLhttp://oappserv.sanglintackle.local:8002/and open the following screen:

Enter the user name and password and click on Connect button to log into OracleApplications and select the appropriate responsibility.

User Name

Password

Click On

Responsibility

Click On

Enter
http://oappserv.sanglintackle.local:8002/http://oappserv.sanglintackle.local:8002/http://oappserv.sanglintackle.local:8002/


5/54

5

Click on Enter...If Java is installed, it automatically open the following form.

This is oracle General Ledger User menu.

2.2 To switch your responsibility Click in the Navigate window or choose Navigator from the Window menu to make

the Navigate window active.

Choose Switch Responsibility from the File menu.

2.3 To change password Click in the Navigate window or choose Navigator from the Window menu to make

the Navigate window active. Choose Change Password... from the Edit, Preferences menu, to display the

Password Update window.

Enter your old password in the Old Password field. Enter your new password in the New Password field. Enter your new password again in the Re-enter New Password field. Choose OK.2.4 To sign on as a different user Click in the Navigate window or choose Navigator from the Window menu to make

the Navigate window active. Choose Log on as a Different User from the File menu, to display the Oracle

Applications sign-on window.


6/54

6

Enter the username and password for your other sign-on and choose Connect.2.5 Navigation to FormsThe forms that you can navigate to are displayed in a navigation list on the left-handside of the Navigate window. The navigation list is organized much like the hierarchyof a file system, where you can expand items that begin with a plus sign (+) to furthersub-levels until you find your form of interest. Sub-levels appear indented below theitems from which they are expanded. Items that are expanded are preceded by a minussign (-). You can expand no further when an item displays neither a plus or minus sign

1) Choose one of the following methods to expand an expandable item to its next sub-level

Double-click on the item. Select the item and choose File - Open. Select the item and choose the Tools - Expand button.

2) Choose one of the following methods to collapse an expanded item

Double-click on the item. Select the item and choose the Collapse button.

3) To expand or collapse several items at once, choose one of the following buttons

Expand All Children--expand all the sub-levels of the currently selected item Expand All--expand all the sub-levels of all expandable items in the

navigation list Collapse All--collapses all currently expanded items in the navigation list

4) To open a form from the navigation list Select your form of interest. Choose Open.

Alternatively you can double click on the Form Name (i.e. Menu) to Open

5) To open a form using an LOV window


7/54

7

Use the keyboard shortcut (usually Ctrl L) to open the LOV (List of Values)window.

Select the form from the list and choose OK or first reduce the list by enteringa partial form title.

2.6 Tool BarsThe toolbar is a collection of iconic buttons, where each button performs a specificaction when you choose it. Each toolbar button replicates a commonly used menu item.Depending on the context of the current field or window, a toolbar button can beenabled or disabled. You can display help for an enabled toolbar button by holdingyour mouse over the button.

The toolbar buttons which are commonly used are as follows


8/54

8

3 Opening and Closing Accounting PeriodsOpen and close accounting periods to control journal entry and journal posting, as well

as compute period- and year-end actual and budget account balances for reporting.

Accounting periods can have one of the following statuses:

Open:Journal entry and posting allowed.Closed: Journal entry and posting not allowed until accounting period isreopened. Reporting and inquiry allowed.


9/54

9

Permanently Closed:Journal entry and posting not allowed. You cannot changethis period status. Reporting and inquiry allowed.Never Opened: Journal entry and posting are not allowed. General Ledgerassigns this status to any period preceding the first period ever opened in yourcalendar, or to any period that has been defined, but is not yet future-enterable.

You cannot change this period status.Future-Entry: Journal entry is allowed, but posting is not. Your period is not yetopen, but falls within the range of future-enterable periods you designated in theSet of Books window. You cannot change this period status without using theconcurrent process to open the period.

You can open new accounting periods, close accounting periods, reopen closedaccounting periods, and open an encumbrance year (if you are using encumbranceaccounting).Note: When you define a new set of books, choose carefully the first accounting periodyou want to open. Once you open your first accounting period, General Ledger does

not allow you to open prior accounting periods.Additionally, you cannot translate account balances for the first period ever opened.Therefore, we recommend that you open at least one period prior to the first accountingperiod in which you wish to enter transactions.

Additional Information: If you use Multiple Reporting Currencies, you mustopen/close accounting periods in your primary set of books and in each of yourreporting sets of books.

Prerequisite

Define your set of books.

To open a new accounting period:

1. Navigate to the Open and Close Periods window.2. General Ledger displays the Latest Open accounting period. Note that while aperiod may be the most recently opened accounting period, this period may havea current status of closed.3. Choose Open Next Period. General Ledger calculates the ending accountbalances for the current period, and launches a concurrent process to open the

next period. The current period remains Open.Suggestion: Although you can have several open accounting periods, to maximize theefficiency of the General Ledger posting process, as well as to minimize the possibilityof user error, limit the number of accounting periods that are open at one time.

If you open the first period of a new fiscal year, General Ledger automaticallyupdates the Retained Earnings account.4. Save your work.


10/54

10

To close an accounting period:

1. Navigate to the Open and Close Periods window.General Ledger displays all accounting periods defined for your calendar withthe period type of your set of books.

2. Select the open period that you want to close.3. Enter a new status for the period.

o Enter Closed to prevent entering or posting journals to that period. Youcan reopen a closed period at any time.

o Enter Permanently Closedto prevent entering or posting journals to thatperiod. You cannot reopen a permanently closed period.

4. Save your work.

To reopen an accounting period:

1. Navigate to the Open and Close Periods window.General Ledger displays all accounting periods defined for your calendar withthe period type of your set of books.2. Select the period that you want to reopen. You can reopen any closed periodthat is not permanently closed.3. Change the status toOpen.4. Save your work.


11/54

11

3.1 Opening PeriodsNavigation: Setup: Open/Close

click on Open/Close tab, it will get the following window.

Click on find, it will shows the open periods and future period.


12/54

12

Click on open period, it will ask target period to open..choose the target period from thelist. and click on open button. it will give the request with number.For check the status of the request.N:(From Tool Bar) View-> Requests


13/54

13

Click on find Button..

Check the status.. Normal , it is completed without having any errors or warnings.

3.2 Close PeriodNavigation: Setup: Open/CloseAfter that click on find button, is as shows below.

It will open the following Window.


14/54

14

Above status LOV contains all the statuses, we need to select the closed one.Description of these statuses explained in earlier pages.

4 Define New Account COA ValuesTo define segment values:

1. Navigate to the Segment Values window.2. Query the value set to which your values (will) belong. You can locate valueseither by their value set or by the flexfield segment or concurrent programparameter that uses their value set for validation.3. Enter a segment value that is valid for your application. A valid value can be aword, phrase, abbreviation, or numeric code. Users can enter this value in aflexfield segment or a report parameter that uses this value set. Users also seethis value whenever they select a value in a flexfield segment that uses this value

set.Any value you define must conform to the criteria you defined for your valueset. For example, if your value set can only accept values one character long withno alphabetic or special characters allowed, you can only enter the values 0through 9 in this field.If you enter a value that contains the segment separator character defined for theflexfield that uses this value set, application windows display the character inyour value as a ^ in your concatenated value fields to differentiate it from the


15/54

15

segment separator. This change is for concatenated display purposes only anddoes not affect your value.Since individual values can be referenced from many places in your applications,you cannot delete valid values that have already been defined, nor can youchange those values. You can, however, change the description of a valid value

in the Description field after you query up the value.You cannot define values that would violate any flexfield security rules that areenabled for your responsibility.4. Check the Enabled check box to make your value effective.5. If you want to have the value effective for a limited time, you can enter a startdate and/or an end date for it. The value is valid for the time including the Fromand To dates.You cannot delete values from this window because they are referencedelsewhere in the system, but you can disable them at any time. You should notdisable or have effective dates for a segment value that you use as a segment

default or a default dependent value.6. If you are defining values whose value set will be used with the AccountingFlexfield, define hierarchy and qualifiers information7. Save your changes.

N: Setup->Financials->flexfield->key->Values

click on value set..it will shown as follows..

Please provide the value set Name : SL_Account


16/54

16

click on find.. it will open the following window..

If you want to add new account to the existing list, click on Plus button from tool bar.

enter the relevant account for the COAs , in above we are adding 9998 account fortesting purpose only. for the accounts, it will ask the account type, as shown above inthe figure. choose the appropriate account type for each and every account you want toadd further states.click on ok, ok, for all windows.


17/54

17

next save the value after that close the form, it will pop up message for compilation, isas follows..

click on ok, .. Account is successfully added to the chart of account.

5 Defining CurrenciesUse the Currencies window to define non-ISO (International Standards Organization)currencies, and to enable/disable currencies. Oracle Applications has predefined allcurrencies specified in ISO standard #4217.

To use a currency other than U.S. Dollars (USD), you must enable the currency. U.S.Dollars (USD) is the only currency that is enabled initially.

To define a new currency:

1. Navigate to the Currencies window.2. Enter a unique Codeto represent your currency.Note: You cannot change a currency code after you enable the currency, even if youlater disable that currency.

3. Enter the Name and Description of the currency.


18/54

18

4. (Optional) Select the name of the Issuing Territory. Oracle Applications haspredefined the names of countries (per ISO Standard #3166) that issue standardcurrencies.5. Enter the Symbolfor your currency.

Note: Some Oracle Applications use currency symbols when displaying amounts.

Others, like General Ledger, do not.

6. Enter the Precision of the currency to designate the number of digits to theright of the decimal point used in regular currency transactions.7. Enter theExtended Precision to designate the number of digits to the right ofthe decimal point used in calculations for this currency. The extended precisionmust be greater than or equal to the standard precision.

Note: Some Oracle Applications use the extended precision. Others, like GeneralLedger, do not.

8. Enter the Minimum Accountable Unit to designate the smallest denomination

used in this currency. Note that this might not correspond to the precision.9. If you are defining the national currency of an EMU member state, define yourCurrency Derivation options.10. (Optional) Enter Effective Dates for your currency. You can only entertransactions denominated in this currency for dates within the range. If you don'tenter a start date, the currency is valid immediately. If you don't enter an enddate, the currency is valid indefinitely.11. Enable your currency.12. Save your work.

To enable or disable a currency:

1. Navigate to the Currencies window.2. Query the Code or Name of the currency that you want to enable or disable.3. Mark the Enabledcheck box to indicate that the currency can be used to entertransactions and record balances. Clear the check box to indicate that thecurrency cannot be used.4. Save your work.


19/54

19

Navigation: Setup->Currencies->Define

Click on Define then the following window will appear, we can define new currencies overthere.


20/54

20

for all standard currencies available in Oracle, just we need to enable only as shown in abovescreen shot.

6 Defining Conversion Rate TypesUse conversion rate types to automatically assign a rate when you convert foreigncurrency journal amounts to functional currency equivalents. You enter dailyconversion rates for specific combinations of foreign currency, date, and conversion ratetype.

When you enter a foreign currency journal, General Ledger automatically displays thepredefined exchange rate based on the currency, rate type (unless you are using theUser rate type), and conversion date you enter. When you have a User rate type, youenter the rate directly when you enter a foreign currency journal.

Additional Information: If you want to enter different daily rates for the samecombination of from-currency, to-currency, and conversion date, you must defineseparate conversion rate types.

General Ledger provides the following predefined daily conversion rate types:

Spot: An exchange rate which you enter to perform conversion based on the rate on aspecific date. It applies to the immediate delivery of a currency.

Corporate: An exchange rate you define to standardize rates for your company. Thisrate is generally a standard market rate determined by senior financial management foruse throughout the organization.


21/54

21

User: An exchange rate you specify when you enter a foreign currency journal entry.

EMU Fixed: An exchange rate General Ledger provides automatically when you enterjournals (after the EMU effective starting date) using a foreign currency that has a fixedrelationship with the Euro.

You can use these predefined rate types to enter exchange rates, or you can defineadditional conversion rate types. After defining a conversion rate type, enter daily ratesusing that rate type.

To define a new conversion rate type:

1. Navigate to the Conversion Rate Types window.2. Enter a Name and Description for the new conversion rate type.3. Save your work.

when we are using foreign currencies, then currency conversions are needed.first define the currency type, is as follows..N: Setup->Currencies->rate->Type

Define Rate Types is as follows..


22/54

22

here we defined two currency types, Sanglin_Morning and Sanglin_Evening.For this types , we need to define the rates.N: Setup->Currencies->rate->Daily

Define rates for the currency types..after that save and close window.


23/54

23

7 Entering JournalsUse this window to enter journals manually in General Ledger. You can enter severaltypes of journal entries, including foreign currency journals, statistical journals, andintercompany journals.Before posting, you can review and update any journal entries you entered manually,imported from feeder systems, or generated automatically. You can also review andupdate budget journal entries.You can use this window to find journals and journal batches. You can view detailedinformation about a journal batch and examine your journal entries in detail and in T-Account or Summary Activity view. If your journals and journal batches allow, you cantake additional actions from this window.

7.1 Enter Functional Currency Journals(Manual)N: Journal->enter

Click on New Journal , it will direct to the following window.


24/54

24

1. Navigate to the Enter Journals window.

2. Enter or query the batch for which you are entering journals. To enter a journal withoutentering batch information, choose New Journal and proceed to Step 4.

To enter journals for a new batch, choose New Batch and enter the batch information.

To add journals to an existing batch, query the batch and choose Review Batch.

Note: The Status region on the Batch window will display the current statuses for Posting,Funds reservation, and journal Approval.

3. Choose Journals.

4. Enter a unique Journal name for the entry. If you do not enter a journal name, GeneralLedger automatically assigns a name using the following format: Source Journal ID Date.

If you did not enter a batch name before entering journals, General Ledger uses the name ofthe first journal in the batch to create a default batch name.

5. Enter the Period for the journal entry. If you entered a period at the batch level, you mustuse the same period for each journal entry in the batch. If you did not enter a period at the batchlevel, choose any Open or Future Enterable period for your journal entry. Note that you canonly post journals in Open periods.


25/54

25

Note: If you enter a period prior to the current accounting period and the user profile optionJournals: Enable Prior Period Notification is set to Yes, General Ledger will display a messageindicating that you are entering a prior period journal. You must confirm that this is what youwant to do.

Additional Information: Balance Type is a display-only field. It displays Actual when you areentering actual journals and Budget when you are entering budget journals.

6. Accept or change the default Effective Date for the journal entry.

7. Enter a Category to describe the purpose of your journal entry, such as accrual, paymentsor receipts. All lines in a journal entry share the same journal category.

General Ledger defaults the journal category if you defined the profile optionJournals:Default Category.

8. If you use manual numbering, enter a unique Document number. This field is onlyavailable if the Sequential Numbering profile option is set to Always Used or Partially Used.

If you set your profile options to always use or partially use sequential numbering, and use adefined Automatic document numbering sequence, General Ledger enters a document numberautomatically when you save your work.

Attention: If sequential numbering is always or partially used, you cannot change the journalcategory or document number after you save your journal entry.

9. If you use automatic tax on journal entries, enter Required in the Tax field to indicate thatyou want to enter additional tax information. Otherwise, enter Not Required. This field only

appears if you have automatic tax enabled for your set of books.

10. Enter an optional Description for the journal entry. General Ledger uses this as the defaultdescription for each journal entry line. You can change the journal entry description asnecessary.

11. Enter a Control Total if you want to verify the total debits for the journal lines against thejournal control total.

12. Accept the default Currency (the functional currency for your set of books), or change thejournal currency to enter a foreign currency or statistical journal.

13. (Optional) If you have average balance processing enabled and your set of books is aconsolidation set of books, select Standard or Average as the Journal Type.

In a consolidation set of books, you can create journal entries that affect either standard oraverage balances. The balances are not linked. In a non-consolidation set of books, you can onlycreate journal entries that directly affect standard balances. Average balances are calculatedautomatically from your standard balances.


26/54

26

14. Choose More Details to enter optional reference information about the journal entry.

Enter a Reference description to further identify the journal entry on general ledger andjournal entry reports.

Enter a reversal Date, Period, and Method. You can then generate a reversing journal entryto that effective date and period. You can also reverse a journal entry without assigning areversal period. Reversal Method can be either:

Switch Dr/Cr: General Ledger creates your reversing journal by switching the debit andcredit amounts of the original journal entry. This method is often used when reversing accruals.

Change Sign: General Ledger creates your reversing journal by changing the sign of youroriginal journal amounts from positive to negative. This reversal method is often used whenreversing journals to correct data entry mistakes.

Close the More Details window when you are finished.

15. Return to the Journals window and enter the journal lines.

16. Save your work.

While entering the manual journal, need to enter the all required information.all colored fields are mandatory, need to enter.Need to specify the period, specify the category, and currency of the journal.After that need to enter Journal lines, is as follows.


27/54

27

1. Enter a Line number for each journal line to control the sequence in which the journal entrylines appear online and in reports. After you enter the first journal entry line number, GeneralLedger automatically increments the numbers for the following lines. You can change the linenumbers as necessary.

2. Enter an Account for the journal line.

3. Enter the Debit or Credit amount for the designated account.

Note: If needed, you can enter debits and credits as negative amounts.

4. If you enabled the General Ledger descriptive flexfields, enter additional descriptiveinformation about the journal line.

Use Journals - Journal Entry Line to enter any additional information related to yourjournal lines.

Use Journals - Captured Information to enter additional information about journal lineswith certain natural account segment values.

Use Value-Added Tax to incorporate tax information into your accounting transactions.You cannot change the definition of this descriptive flexfield in General Ledger.

5. Save your work.


28/54

28

After enter the values save the Journal, click on approve button, it will forwarded to superiorfor approval of journal, it shows the message is as follows.

7.2 Foreign Currency JournalsTo enter a foreign currency journal:

1. Navigate to the Enter Journals window.2. Enter optional batch information.3. Enter your journal information, specifying the foreign Currency you want to use

for your journal entry.4. Enter the journal currency conversion information.

The conversion Date must be within the accounting period you defined for thejournal entry. The conversion date is the posting date for the journal entry, and thedefault is the Effective Date shown in the More Details window.

The conversion Type can be the Spot, Corporate, or User type, or any conversion

type you defined. You must enter a conversion Rate if you enter User as the conversiontype. If you specify a conversion type other than User, General Ledger automaticallyenters the daily conversion rate based on the rates you entered in the Daily Rateswindow.5. Enter your journal lines, using debit and credit amounts in the foreign currency.General Ledger automatically converts the entry amounts into your functional currencybased on the designated conversion rate.Screen shot is as follows.


29/54

29

We need to provide the foreign currency and rate type.


30/54

30

after enter the foreign currency journal, Oracle automatically convert that foreigncurrency to functional currency based on the provided rate to the journal. After that itwill go to approval.

7.3 Reverse Journal EntriesUse reversing journal entries to reverse accruals, estimates, errors or temporary adjustmentsand reclassifications.

Assign a reversal period and, if average balances is enabled, a reversal effective date to a journalentry if you want to generate a reversing entry from the Enter Journals window, or later fromthe Reverse Journals form. You can enter a reversal period and effective date at any time, evenafter the journal is posted. However, you cannot reverse batches and journals that you havealready reversed.

You can also reverse a journal or batch from the Enter Journals window, even if you have notassigned a reversal period and effective date.

Multiple Reporting CurrenciesIf you use Multiple Reporting Currencies and reverse a journal entry in your primary set ofbooks, General Ledger will also reverse the corresponding entry in your reporting sets of books.The reporting currency journal is reversed using the same conversion rate that was used tocreate the original journal entry.

To assign a reversal period and effective date to a journal entry:

1. Navigate to the Enter Journals window.

2. Query the batch and journal within the batch for which you want to assign a reversalperiod. Note that the reversal effective date is only necessary when you have average balancesenabled for your set of books.

3. Choose Review Journal.

4. Choose More Details.

5. Enter the Period for the reversing entry. If average balances is enabled, you must also enterthe effective Date.

6. Select a reversal Method:

Switch Dr/Cr: General Ledger creates your reversing journal by switching the debit andcredit amounts of the original journal entry. This method is often used when reversing accruals.

Change Sign: General Ledger creates your reversing journal by changing the sign of youroriginal journal amounts from positive to negative. This reversal method is often used whenreversing journals to correct data entry mistakes.


31/54

31

Once you enter the effective date, reversing period, and reversal method, the journal entry ismarked for reversal and will appear in the Reverse Journals window.

7. Generate the reversing entry from the Enter Journals window, or from the Reverse Journals

window.

just click on reversal, it will automatically reverse the journal. it will generate request for

reversal of journal, is as follows.


32/54

32

8 Journal ApprovalThe GL Journal Approval Process obtains the necessary management approvals formanual journal batches. The process validates the journal batch, determines if approval

is required, submits the batch to approvers (if required), then notifies appropriateindividuals of the approval results.The process has a result type of GL Journal Approval Process Result that gives one offour results:

Approval Not Required: The journal batch does not need approval.Approved: The journal batch was approved by all necessary approvers. In some

cases, this may be the preparer.Rejected: The journal batch was rejected by an approver.Validation Failed: The journal batch failed the validation process and was never

submitted to the approver.

The process consists of 5 unique activities, some of which are reused, to comprise the 9activity nodes that appear in the workflow diagram:


33/54

33

Manager login for oracle instance for approval of Journals:URL: http://oappserv.sanglintackle.local:8002/User ID: JINGPassword :Welcome

click on Login, after that click in Sanglin General Ledger Super User Responsibility.it will open the following window is as follows.


34/54

34

Click on Enter journal tab, it will open journals window, after that need to close formsuntil get the main menu( it is already seen at GL User Level). Main Menu is as follows.

Click on Other, Notifications, it will open web form, is as follows.


35/54

35

Click on GO button, it will display all notifications for this particular user.

Click on any one of these journals, it leads to approval page, where manager can takedecision, either approve or reject. that window is as follows.


36/54

36

Click on approval, journal get approved and it is ready for post.

9 Run GL ReportsNavigation: View->Request.it is shown in below screen shot.


37/54

37

click on Request tab, it will open the oracle form, is as follows.

click on Submit a New Request button, it will open other form, asking for singlerequest or multiple requests, click on single request.


38/54

38

Click on OK button, it will take the new form where we need to give the request name,is as follows.

The above list box, shows the list of reports which we are using for sanglin tackle.selected the chart of account detail listing, click on OK.it will ask the list of parameters is as follows.


39/54

39

After passing all parameters to the request, we need to submit the request, is asfollows..

After submission, it will give the Request Id, after that we need to check the status ofthis request. click on no, it will take to other form is as follows.

Click on find button, it will show the status of request, is as follows.


40/54

40

Once it is completed , the status shows as Normal, without having any color.after that click on View Output button, it will gives the report , is as follows.

This is the report of chart of account detail listing, similarly we can see all the reports inoracle.


41/54

41

10 General Ledger Reports10.1Average Balance Trial Balance ReportReview your General Ledger standard and average account balances. You can print

functional, foreign-entered, or translated average balances.

This report provides a listing of standard and average balances for selected accountsbased on an as-of date you specify. In addition, the report displays period, quarter, andyear average-to-date balances. You can also request additional information on thisreport by specifying balancing segments and account ranges.

Parameters

When you request this report, General Ledger prompts you to enter the following:

Currency: Choose the functional currency for your set of books or STAT.

Currency Type: Choose Entered to have your report print average balances that wereentered in the chosen currency. Choose Translated to print average balances that weretranslated to the chosen currency.

Reporting Date: Enter the calendar date for which you want to see average balances.For example, if you want to review average balances as of January 31, 1996, you enter31-JAN-96 as the Reporting Date.

Account From/To: Enter the range of accounts you want to include in your report.

Selected Headings

Refer to the selected heading descriptions below for additional information.

Ending Balance: the standard ending balance for an account.

Period Average-to-Date: the average of the end-of-day balances for a related range ofdays within a period.

Quarter Average-to-Date: the average of the end-of-day balances for a related range ofdays within a quarter.

Year Average-to-Date: the average of the end-of-day balances for a related range ofdays within a year.


42/54

42

Note: If you are reporting on translated average balances, an asterisk will appear next toany translated balance that is out of date. This can occur if a rate changes or newtransactions are posted after your balances are translated. You should retranslate yourbalances, then run the report again.

10.2Chart of Accounts ListingReview the chart of accounts for your current set of books, including detail andsummary accounts.

General Ledger first prints your enabled detail accounts, then your disabled detailaccounts, and finally your summary accounts. Each of these three groups begins on anew page. Within each of the three groups, your accounts are sorted by their accountsegment values.

Parameters

When you request this listing, General Ledger prompts you to enter the following:

From/To Balancing Value: Enter a range of balancing segment values. This listingprints only accounts with balancing segment values that fall within this range, andstarts a new page for each balancing segment value.

From/To Account Value: Enter a range of account segment values. This listing printsonly accounts with account segment values that fall within this range.

Attention: The values that you supply for the ranges do not have to be valid segmentvalues. For example, you can specify balancing segment values 00 to ZZ and accountsegment values 5000 to 5999 even if those specific values are not defined.

Selected Headings


Account: description of the account segment value for each Accounting Flexfield.

Account Type: one of the following account types for each detail account: Asset,

Liability, Owner's Equity, Revenue or Expense.

The account type is determined by the account segment of the Accounting Flexfield.

Summary Account: Yes if your account represents a summary account or No if itrepresents a detail account.

Enabled: Yes if your account is enabled or No if it is not enabled.


43/54

43

Start/End Date: start and end date, if any, for your account.

10.3Daily Conversion Rates ListingReview the conversion rates you have defined for any foreign currency in your set of

books. You can request this listing for any accounting period.

This listing prints the rate type for each conversion rate as well as the date on whichyou defined the rate. General Ledger sorts the listing alphabetically by rate type. Foreach rate type, General Ledger sorts the conversion rates in ascending order by dateentered.

Parameters

When you request this listing, General Ledger prompts you to enter the following:

Period: Choose any accounting period in your calendar.

Currency: Choose any foreign currency you have defined or enabled.

Selected Headings


Rate Type: one of the following rate types for each conversion rate in your listing:Corporate, Spot, User, or a unique rate type you defined.

Date: date for which you defined your conversion rate.

to : daily conversion rates from the foreigncurrency you specified to the functional currency for your set of books.

to :daily conversion rates from thefunctional currency for your set of books to the foreign currency you specified.

10.4Create Journal Entries Execution ReportReview the journal batches created from transactions that pass funds reservation fromOracle Purchasing and Oracle Payables when you run the Create Journals program.General Ledger also runs the Create Journals program when you enter budget journalsor transfer budget amounts using budgetary control.

For each created batch, the report prints the source, balance type, batch name,accounting period, and total debits and credits.


44/54

44

General Ledger automatically creates this report when the Create Journals programcompletes successfully.

10.5Detail Trial Balance ReportReview your general ledger actual account balances and activity in detail. You can runthis report for balances and activity entered in your functional currency or STAT, ortranslated to a foreign currency.

The report prints a line for each of your accounts and lists them in ascending order byaccount segment value. For each account, the report prints the account segment value,account segment value description, beginning balance, period activity, and endingbalance for the period you specify. General Ledger reports debits as positive amountsand credits as negative amounts.

Parameters


Pagebreak Segment: Choose any account segment other than your account segment.General Ledger prints a separate page for each value of the segment you choose.

Pagebreak Segment Low/High: Enter the range of Pagebreak Segment values for yourreport.

Currency: Choose your functional currency, a foreign currency or STAT. If you choose a

foreign currency, this report shows youraccount balances translated to that currency.

Period: Choose any open accounting period in your calendar.

Amount Type: Choose PTD (period-to-date), YTD (year-to-date), or PJTD (project-to-date).

Selected Headings


Account: account segment value for each account.

Description: description of your account segment value.

Accounting Flexfield: a line for each account.


45/54

45

10.6General Ledger ReportReview journal information to trace each transaction back to its original source.

General Ledger prints a separate page for each balancing segment value. For each

journal line, the report prints the account affected, the concatenated description, thejournal line amount, and the beginning and ending account balance. Additionally, foreach journal line, the report prints journal details including source, category, journalname, and effective date. The report lists accounts in ascending order by accountsegment value, and it prints a "CR" next to credit amounts.

Note: If you use the Enter Budget Amounts form to update budget balances, GeneralLedger does not generate journal entries to reflect your changes. This will cause theGeneral Ledger Report to flag discrepancies between a budget balance and the budgetjournals for that period.

Parameters


Type: Choose Line Item to generate a report showing REFERENCE_1 from theGL_JE_LINES table. Choose Source Item to generate a report showing REFERENCE_4from the GL_JE_LINES table. These references appear only if you used Journal Import.

Choose Document Number to generate a report showing the sequence number of thejournal containing your journal line. A sequence number will only appear in your

report if you are using sequential numbering and you have assigned a number to thejournal containing your journal line.

Currency: Choose either the functional currency for your set of books or STAT.

Balance Type: Choose Actual, Budget or Encumbrancebalances.

Budget or Encumbrance Name: If you chose the Budget balance type, you must select abudget name. If you chose the Encumbrance balance type, you must select anencumbrance type. Finally, if you chose the Actual balance type, General Ledger

automatically enters N/A.

Starting/Ending Period: Choose the range of accounting periods for your report.

Flexfield From/To: Choose the range of accounts for your report.


46/54

46

10.7Journal Entry ReportReview journal activity for a given period or range of periods, balancing segment value,currency, and range of account segment values.

The report prints the accounting date, category, journal name, reference, journal batchname, entered debit or credit amounts, net balance, and account total for each journal.In addition, a total is provided for each balancing segment included in your report anda grand total is provided for all the activity included in your report.

Parameters


Currency: Enter the functional currency for your set of books, a foreign currency, orSTAT. If you enter a foreign currency, General Ledger prints only journals entered inthat currency.

: (optional) Enter the balancing segment value for which youwant to report. Or, leave this field blank if you want to report on all balancing segmentvalues.

Start/End Account: Enter the range of account segment values for your report.

Start/End Period: Enter the range of accounting periods for your report.

Selected Headings


Debit: debit amount of the journal entry.

Credit: credit amount of the journal entry.

Begin Total: beginning balance for each account segment value for each period in therange you specified.

Period Movements: debit and credit activity for each account segment value.

End Total: ending debit and credit amounts for each account segment value for eachperiod in the range you specified.

Account Total: total debit and credit amounts for each account segment value.


47/54

47

Total: total debit and credit amounts for each balancing segmentvalue included in your report.

Grand Total: total of the accounted debit and credit amounts for your report.

Balance: net of debit and credit amounts corresponding with each period movement,end total, account total, total, and grand total.

10.8Journals - Voucher ReportUse this report to print journal vouchers:

o From a specified journal batcho For all posted, unposted, or "error" journalso With a specified journal source, journal category, and document sequenceo That fall within a specified range of starting and ending dates and

document numbers.

For each matching detail journal, General Ledger prints a voucher that includes headerinformation such as batch name, period, journal entry name, document number, journalsource, description, journal category, currency, accounting date, subledger documentname, rate type, posting date, subledger document number, and exchange rate.

For each detail journal line, General Ledger prints the line number, account, accountdescription, entered debit or credit amount, and description. At the end of the voucher,General Ledger prints the total entered debit and credit amounts.

A new page is started for each journal voucher.

Prerequisites

You must use document sequences in your Oracle subledgerapplications.

You must use the Detail method when importing journal entries fromyour subledgers to General Ledger.

Parameters



48/54

48

Posting Status: the posting status on which you want to report. You can enter Posted,Unposted, or Error.

Start/End Posting/Account Date: the starting and ending posting or accounting datesfor which you want to print journals and journal details. If you select Posted as your

posting status, these entries are the starting and ending posting dates. If you selectUnposted or Error as your posting status, these entries are the starting and endingaccounting dates.

Sequence Name: the sequence name on which you want to report.

Start/End Sequence Number: the starting and ending document number to include inyour report.

Note: These two parameters must be automatic document numbers assigned by

General Ledger. Manually assigned document numbers will not work for this report.

Batch Name: the batch name on which you want to report.

Source: the journal source on which you want to report.

Category: the journal category on which you want to report.

Caution: General Ledger does not check your report parameters for conflicts. Forexample, you will get no errors if the batch name you specify does not include thesequence numbers you specify. Your report will run, but may produce no results. You

should carefully review your report output to ensure that it meets your expectations.

Selected Headings


Period: the accounting period in which the journal was entered.

Document Number: the document number for the journal.

Currency:the currency used to enter the original journal amounts.

Account Date: the accounting date of the journal.

Posted Date: the date the journal was posted.

Exchange Rate: the rate used to convert the entered journal amount into your set ofbook's functional currency.


49/54

49

Accounting Flexfield: the General Ledger account and description for the detail journalline.

Entered Debit: the detail journal line debit amount as entered in the original currency.

Entered Credit: the detail journal line credit amount as entered in the original currency.

10.9Posted JournalsReview your posted journal batches and the journals associated with each postedjournal batch. This information allows you to trace your transactions back to theoriginal source.

The report prints the line number, account, transaction date, description, line/sourceitem, the debit or credit amount, and the statistical amount for each journal line. Totalsare provided for all journal lines within a journal, and all journals within a journalbatch. In addition, totals are provided for your journal source, and a grand total isprovided for all of the debit and credit amounts included in your report.

10.9.1.1ParametersWhen you request this report, General Ledger prompts you to enter the following:

Type: Choose Line Item to generate a report showing REFERENCE_1 from theGL_JE_LINES table. Choose Source Item to generate a report showing REFERENCE_4from the GL_JE_LINES table. These references appear only if you used Journal Importand included a journal voucher number, an invoice date and number, or some other

source document information that helps you to identify the origin of this journal.

Posting Status: Choose the Posted status.


Period: (optional) Choose any accounting period in your calendar. If you leave this fieldblank, the report will include posted journal batches for all accounting periods.

Start/End Date: (optional) Enter the posting date range for your report. If you skip these

fields, the report will include journal batches posted on any date.

Source: (optional) Choose the journal entry source for your report. If you leave this fieldblank, the report will include posted journal batches from all sources.

Batch Name: (optional) Choose any posted journal batch. If you leave this field blank,the report will include all posted journal batches which comply with the otherparameters.


50/54

50

10.9.1.2Selected HeadingsRefer to the selected heading descriptions below for additional information.

Batch Effective Date: For manual journals to prior periods, the last day of the periodyou specified in your batch. For manual journals to future periods, the first day of the

period you specified in your batch. For manual journals to the current period or forjournals created by feeder systems, the date on which the batch was created.

Balance: Actual, Budget, or Encumbrance to indicate the type of batch. General Ledgerfirst prints your Actual batches, then your Budget batches, and finally yourEncumbrance batches.

Line/Source Item: If you chose the Line Item type, prints REFERENCE_1 from theGL_JE_LINES table. If you chose the Source Item type, REFERENCE_4 from theGL_JE_LINES table.

Units: statistical amount, if any, associated with your journal line.

10.10Unposted JournalsReview your unposted journal batches and their associated journals. This informationallows you to trace your transactions back to the original source.

The report prints the line number, account, transaction date, description, line/sourceitem, the debit or credit amount, and the statistical amount for each journal line. Totalsare provided for all journal lines within a journal, and all journals within a journal

batch. In addition, totals are provided for your journal source, and a grand total isprovided for all of the debit and credit amounts included in your report.

10.10.1.1 ParametersWhen you request this report, General Ledger prompts you to enter the following:

Type: Choose Line Item to generate a report showing REFERENCE_1 from theGL_JE_LINES table. Choose Source Item to generate a report showing REFERENCE_4from the GL_JE_LINES table. These references appear only if you used Journal Importand included a journal voucher number, an invoice date and number, or some other

source document information that helps you to identify the origin of this journal.

Posting Status: Choose the Unposted status.


Period: (optional) Choose any accounting period in your calendar. If you leave this fieldblank, the report will include unposted journal batches for all accounting periods.


51/54

51

Start/End Date: (optional) Enter the batch effective date range for your report. If youleave the start and end date blank, the report will include unposted journal batchesfrom any date.

Source: (optional) Choose the journal entry source for your report. If you leave this field

blank, the report will include unposted journal batches from all sources.

Batch Name: (optional) Choose any unposted journal batch. If you leave this fieldblank, the report will include all unposted journal batches which comply with the otherparameters.

10.10.1.2 Selected HeadingsRefer to the selected heading descriptions below for additional information.

Batch Effective Date: For manual journals to prior periods, the last day of the period

you specified in your batch. For manual journals to future periods, the first day of theperiod you specified in your batch. For manual journals to the current period or forjournals created by feeder systems, the date on which the batch was created.


Line/Source Item: If you chose the Line Item type, REFERENCE_1 from theGL_JE_LINES table. If you chose the Source Item type, REFERENCE_4 from theGL_JE_LINES table.

Units: statistical amount, if any, associated with each journal line.

10.11Error JournalsReview your error journal batches and their associated journals. This informationallows you to trace your transactions back to the original source. Journal batchesbecome error journals if posting fails; they do not lose their error status until they areposted successfully.

The report prints the line number, account, transaction date, description, line/sourceitem, the debit or credit amount, and the statistical amount for each journal line. Totalsare provided for all journal lines within a journal, and all journals within a journal entrybatch. In addition, totals are provided for your journal source, and a grand total isprovided for all of the debit and credit amounts included in your report.

10.11.1.1 ParametersWhen you request this report, General Ledger prompts you to enter the following:


52/54

52

Type: Choose Line Item to generate a report showing REFERENCE_1 from theGL_JE_LINES table. Choose Source Item to generate a report showing REFERENCE_4from the GL_JE_LINES table. These references appear only if you used Journal Importand included a journal voucher number, an invoice date and number, or some othersource document information that helps you to identify the origin of this journal.

Posting Status: Choose the Error status.


Period: (optional) Choose any accounting period in your calendar. If you leave this fieldblank, the report will include error journal batches for all accounting periods.

Start/End Date: (optional) Enter the batch effective date range for your report. If youleave the start and end date blank, the report will include error journal batches from

any date.

Source: (optional) Choose the journal source for your report. If you leave this fieldblank, the report will include error journal batches from all sources.

Batch Name: (optional) Choose any error journal batch. If you leave this field blank, thereport will include all error journal batches which comply with the other parameters.

10.11.1.2 Selected HeadingsRefer to the selected heading descriptions below for additional information.

Batch Effective Date: For manual journals to prior periods, the last day of the periodyou specified in your batch. For manual journals to future periods, the first day of theperiod you specified in your batch. For manual journals to the current period or forjournals created by feeder systems, the date on which the batch was created.


Line/Source Item: If you chose the Line Item type, REFERENCE_1 from the

GL_JE_LINES table. If you chose the Source Item type, REFERENCE_4 from theGL_JE_LINES table.

Units: statistical amount, if any, associated with your journal line.

10.12Translation Trial Balance ReportReview your account balances and period activity after running translation.


53/54

53

General Ledger prints a separate page, including totals, for each balancing segmentvalue, listing accounts in ascending order by account segment value. For each translatedaccount, the report prints the description of the account segment value, account type,beginning balance, debits and credits, rate adjustment, and ending balance.

Parameters


From/To Balancing Segment: Enter the range of balancing segment values for yourreport.

Currency: Choose any currency other than your functional currency or STAT. GeneralLedger prints account balances translated to the foreign currency you specify. You mustrun foreign currency translation before you can report on translated account balances.

Period: Choose any open accounting period for which you ran translation.

Selected Headings


Account: description of your account segment value.

Accounting Flexfield: line for each account.

Account Type: one of the following account types for each account:

A: Asset

L: Liability

O: Owner's Equity

R: Revenue

E: Expense

The account type is determined by the account segment of the account.

Rate Adjustment: adjustment resulting from period rate differences between thereporting period and the previous period.

*: General Ledger marks each line with an asterisk if the account balance requiresretranslating as a result of posting activity or rate change.


54/54

11 OPEN/CLOSED ISSUES11.1

Open Issues

ID Issue Issue Description Responsibility Target Date Impact D

11.2Closed IssuesID Issue Resolution Responsibility Target Date Impact D

user training manual-gl

Documents