GL Setup List

download GL Setup List

of 88

Transcript of GL Setup List

  • 7/21/2019 GL Setup List

    1/88

    Please click on this link, and then right click on gl.pdf to save on your PC

    Topics covered in the above article are

    General Ledger Overview

    Functions and Features

    General Ledger Accounting Cycle

    Global Accounting EngineAccounting Methods

    SetO!"ooks

    Chart o! Accounts

    #alidation and #alue Sets

    Creating Accounting Fle$!ields %

    &e!ining the Accounting Fle$!ield Structure

    &e!ining 'ierarchies

    Accont 'ierarchy Manager %

    Set o! "ooks O(tions

    &e!ining Shorthand Aliases

    Maintain the General Ledger Chart o! Accounts

    )ournal Processing in General Ledger

    )ournal Creation Methods

    )ournal Co*(onents

    )ournal Entry level in!or*ation

    +*(orting )ournal Entries

    eversing )ournal Entries

    Posting )ournals

    Creating eversing )ournals

    http://www.apps2fusion.com/training_demo/ranu/oracle-gl/http://www.apps2fusion.com/training_demo/ranu/oracle-gl/http://www.apps2fusion.com/training_demo/ranu/oracle-gl/http://www.apps2fusion.com/training_demo/ranu/oracle-gl/
  • 7/21/2019 GL Setup List

    2/88

    eviewing and Correcting "alances

    &rilling &own to )ournal &etail

    -Accounts

    .sing A((lications &eskto( +ntegrator to Enter )ournals

    )ournal i*(ort !ro* Feeder Syste*s

    )ournal Entry Auto*ation

    Per!or*ing )ournal Entry Functions

    )ournal Entry -y(es

    )ournal Co*(onents

    Manual )ournal Entries

    eversing )ournal Entries

    Creating eversing )ournals

    .sing A&+ to Create )ournal Entries /re!er student guide ,second round01

    Overview o! +*(orting )ournal Entries

    +*(orting )ournals /21 )ournals 3 +*(ort 3 un

    +*(orting )ournal e!erences

    eviewing )ournal +*(ort &ata

    )ournal +*(ort #eri!ication Process

    Posting )ournalsOverview o! AutoPost

    eversing )ournals Auto*atically

    )ournal eversal Criteria

    Financial e(orting

    44i .tili5ing Standard Financial e(orts

    un Financial e(orts with A&+

    Multi(le e(orting Currencies

    Foreign Currency Conce(ts

    Multi(le Currency Accounting

    Conversion Overview

    &e!ining Conversion ate -y(es

    Entering &aily ates

  • 7/21/2019 GL Setup List

    3/88

    evaluation Overview

    evaluation Process

    Period ates

    -ranslation Overview

    -ranslation with 'istorical ates and A*ounts

    -ranslating Owners6 E7uity Accounts

    Foreign Currency Listings

    Foreign Currency e(orts

    8uick e!erence

    Setting General Ledger Profile Options

    During your implementation, you set a value for each profile option in your GeneralLedger application to specify how your General Ledger application controls access to andprocesses data.

    In general, profile options can be set at one or more of the following levels: site,application, responsibility and user. Use the Update Personal Profile ptions window toset your profile options only at the user level. !our system administrator uses the Update"ystem Profile ptions window to set profile options at different levels.

    Profile Options not Owned by General Ledger

    #he following profile options affect the operation of General Ledger, but are not $owned$by General Ledger:

    MO: Operating Unit%% #his profile option controls which operatingunit a particular responsibility corresponds to, and is used only if you haveinstalled multiple organi&ation support. 'or more information, please seeMultiple Organizations in Oracle Applications.Note: General Ledger(s )ccount In*uiry window ignores the setting ofthis profile option. #his allows you to drill down to your subledgersindependent from their multiple organi&ation setup. )s a result, when youdrill down to subledger details, General Ledger will show you all of the

    transactions that comprise an account balance, regardless of whichorgani&ation originated the transaction.

    Profile Options Owned by General Ledger

    !ou can set the following profile options in General Ledger applications.

    Profile Option User System Administrator Requirements

  • 7/21/2019 GL Setup List

    4/88

    User User Resp App Site Required !efault "alue

    +udgetary ontrol Group ## ptional

    Daily -ates indow: /nforceInverse -elationship During/ntry

    ## ptional 0o

    Dual urrency ## ptional

    Dual urrency Default -ate#ype

    ## ptional

    '"G: )ccounting 'le1field ptional )ccount

    '"G: )llow Portrait Print"tyle

    ptional 0o

    '"G: /nforce "egment 2alue"ecurity

    ptional 0o

    '"G: /1pand Parent 2alue ptional 0o

    '"G: 3essage Detail ptional 3inimal

    GL )4/: "aving )llowed ## ptional !es

    GL: wners /*uity#ranslation -ule

    ## ptional P#D

    GL "et of +oo5s ID ## ## ## ## 06)

    GL "et of +oo5s 0ame -e*uired

    GLDI: )utoopy/nforcement Level

    ## ptional 0one

    GLDI: +udget i&ard/nforce "egment 2alue"ecurity

    ## ptional 0o

    GLDI: +udget i&ardPrivileges

    ##

    ptional

    /ntryUpload"ubmit

    GLDI: 7ournal i&ardPrivileges

    ##

    ptional

    /ntryUpload"ubmit

    GLDI: -eport i&ardPrivileges

    ## ptional Define, "ubmit

    Intercompany: "ubsidiary ptional

  • 7/21/2019 GL Setup List

    5/88

    Intercompany: Use)utomatic #ransaction0umbering

    ptional

    7ournals: )llow 3ultiple

    /1change -ates

    ptional 0o

    7ournals: )llow 0on%+usiness Day #ransactions

    ## ptional

    7ournals: )llow PostingDuring 7ournal /ntry

    ptional 0o

    7ournals: )llow Preparer)pproval

    ## ptional 0o

    7ournals: Default ategory ptional

    7ournals: Display Inverse

    -ate

    ptional 0o

    7ournals: /nable Prior Period0otification

    ## ptional 0o

    7ournals: 'ind )pprover3ethod

    ptional Go Up3anage% menthain

    7ournals: 3i1 "tatistical and3onetary

    ptional 0o

    7ournals: verride -eversal3ethod

    ## ptional !es

    Use Performance 3odule ptional !es

    $ey

    !ou can update the profile option.

    ## !ou can view the profile option value but you cannot change it.

    therwise, you can not view or change the profile option.

    %udgetary &ontrol Group

  • 7/21/2019 GL Setup List

    6/88

    )ssign budgetary control groups when you enable budgetary control for your set ofboo5s. +udgetary control groups include a set of options which are used to enforcebudgetary control based on combinations of 8ournal entry source and category. !ou canalso define budgetary control options for the detail and summary accounts for which youwant to enforce budgetary control.

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application, responsibility or user level.

    !aily Rates 'indow: (nfor)e *n+erse Relations,ip !uring (ntry

    Use this profile option to specify whether to enforce the automatic calculation of inversee1change rates in the Daily -ates window. hen the profile option is set to !es and youenter a daily rate to convert currency ) to currency +, General Ledger automaticallycalculates the inverse rate 9currency + to ) and enters it in the ad8acent column. If eitherrate is changed General Ledger automatically recalculates the other.

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application or responsibility level.

    !ual &urren)y

    hoose the dual currency for your set of boo5s if you want to enable the dual currencyfeature and calculate weighted%average rates for specific accounts. !ou can choose anycurrency other than your functional currency. !ou must ensure that each set of boo5s hasonly one dual currency.&aution: #his profile option is used to support an old General Ledger feature called Dual

    urrency. e recommend that you use 3ultiple -eporting urrencies instead. "et thisprofile option only if you currently useDual urrency. "etting this profile option invo5esadditional Dual urrency processing which may fail if you are not using Dual urrency.If you set this profile option, you must also set the Dual urrency Default -ate #ypeprofile option.

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application or responsibility level.

    !ual &urren)y !efault Rate -ype

    hen using Dual urrency, you can either specify a transaction rate for each transactionor use the daily rate associated with the transaction date. Use this profile option to specifythe default currency conversion type 7ournal Import should use to determine the dailyrate if you do not enter a transaction rate.&aution: #his profile option is used to support an old General Ledger feature called Dualurrency. e recommend that you use 3ultiple -eporting urrencies instead. "et thisprofile option only if you currently useDual urrency. If you set this profile option, youmust also set the Dual urrency profile option.

  • 7/21/2019 GL Setup List

    7/88

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application or responsibility level.

    .SG: A))ounting .le/field

    hoose the General Ledger application reporting fle1field. 'or your General Ledgerapplication, select the account as your reporting fle1field.

    #he default value for this profile option is account.

    !ou cannot view this profile option at the user level. !our "ystem )dministrator must setthis profile option at the site or application or level.

    .SG: Allow Portrait Print Style

    ontrol the print orientation of your 'inancial "tatement Generator reports that are less

    than or e*ual to ;< characters wide. !ou can print these reports in either portrait style 9;? character wide. #he following values areavailable to you:

    0es: !our General Ledger application prints reports that are less than or e*ual to;< characters wide in portrait 9;< character wide.No: !our General Ledger application prints reports that are less than or e*ual to;< characters wide in landscape 9=>? character wide.

    If this profile option is not enabled, or your reports are more than ;< characters wide,your General Ledger application produces landscape style 9=>? character wide orlandwide style 9=;< character wide reports, depending on the report character width.

    !ou can set this profile option at the user level. r, your "ystem )dministrator can setthis profile option at the site, application, responsibility or user level.

    .SG: (nfor)e Segment "alue Se)urity

    ontrol whether your defined security rules will apply to reports produced using '"G.#he following values are available to you:

    0es:If security rules are defined that prevent you from accessing specific accountsegment values, then you cannot produce financial information for those samesegment values when you run '"G reports. 'or e1ample, if you are e1cluded fromusing any accounts for cost centers =

  • 7/21/2019 GL Setup List

    8/88

    0es:'"G uses the rollup group to determine whether to e1pand a parent valueinto its child ranges. If the parent value belongs to a rollup group, '"G does note1pand the parent value into its child ranges. If the parent value does not belongto a rollup group, '"G e1pands the parent value into its child ranges.No: '"G uses the summary flag associated with the fle1field assignment to

    determine whether to e1pand a parent value into its child ranges. If the summaryflag is set to !es, '"G does not e1pand the parent value into its child ranges. If thesummary flag is set to 0o, '"G e1pands the parent value into its child ranges.

    #he default value for this profile option is 0o.

    !ou can set this profile option at the user level. r, your "ystem )dministrator can setthis profile option at the site, application, responsibility or user level.

    .SG: Message !etail

    "pecify the level of detail in your error message log file when you re*uest your 'inancial

    "tatement Generator reports. !our General Ledger application divides error messagesinto the following three catalogs:&atalog *:contains all detail memory figures, detail timings, and "@L statementswhich is useful for program debugging.&atalog **: contains all file and function names, and all messages which giveprocess information. #his is useful for finding out where a process failed.&atalog ***: contains only error messages and other important messages, andtherefore gives the least amount of information for program debugging.

    !ou specify the level of detail for your error message log file by setting this profileoption to one of the following values:

    None:0o messages.

    Minimal:atalog III messages.Normal: atalog II and III messages..ull: atalog I, II, and III messages.

    #he default value for this profile option is 3inimal.

    !ou can set this profile option at the user level. r, your "ystem )dministrator can setthis profile option at the site, application, responsibility or user level.

    GL A1(: Sa+ing Allowed

    "pecify whether to allow account hierarchy changes to be saved from )ccount 4ierarchy

    /ditor. #he following values are available:0es:!ou can save changes to account hierarchies from )ccount 4ierarchy /ditor.No: !ou can only view account hierarchies from )ccount 4ierarchy /ditor. !oucannot save changes.

    #he default value for this profile option is !es.

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application, responsibility, or user level.

  • 7/21/2019 GL Setup List

    9/88

    GL: Owners (quity -ranslation Rule

    "pecify the rule General Ledger follows to translate owners( e*uity accounts when youhave not entered specific historical rates or amounts. #he following values are available:

    P-!:#he Period%to%Date rule is used to translate owners( e*uity accounts. 'or

    each period for which you translate owners( e*uity accounts, the historical rate isset to the period%average rate.0-!:#he !ear%to%Date rule is used to translate owners( e*uity accounts. 'or eachperiod for which you translate owners( e*uity accounts, the historical rate is set tothe period%end rate.

    #he default value for this profile option is P#D.

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application, or responsibility level.

    GL Set of %oo2s *!

    #his profile option displays the current "et of +oo5s ID when you are in the "ystem)dministrator responsibility.

    !ou cannot change the value of this profile option. Instead, you set the profile option GL"et of +oo5s 0ame and your General Ledger application automatically determines anddisplays the value for GL "et of +oo5s ID.

    GL Set of %oo2s Name

    "pecify your set of boo5s. #his option also associates a set of boo5s with a responsibility.

    !ou cannot view this profile option at the user level. !our "ystem )dministrator can setthis profile option at the site, application or responsibility level.

    GL!*: Auto&opy (nfor)ement Le+el

    "pecify the enforcement level for the -eport i&ard(s )utoopy function. #he followingvalues are available to you:

    None:!ou can choose to wor5 with copies or originals of e1isting reports andreport ob8ects.(nfor)e &opy:hen wor5ing with e1isting reports or report ob8ects, you must

    create copies rather than use the originals that are stored in the applicationsdatabase.(nfor)e Original:hen wor5ing with e1isting reports or report ob8ects, youmust wor5 with the originals that are stored in the applications database.

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application, responsibility, or user level.

    GL!*: %udget 'i3ard (nfor)e Segment "alue Se)urity

  • 7/21/2019 GL Setup List

    10/88

    "pecify whether segment value security is enforced when using the GLDI +udgeti&ard. #he following values are available to you:

    No:"egment value security is not enforced.0es:"egment value security is enforced.

    !ou can only view this profile option at the user level. !our "ystem )dministrator must

    set this profile option at the site, application, responsibility, or user level.

    GL!*: %udget 'i3ard Pri+ileges

    "pecify the +udget i&ard usage privileges. #he following values are available to you:None:!ou cannot use this feature.(ntry:!ou can only enter budget data in a budget wor5sheet.(ntry4 Upload:!ou can enter budget data and upload that data to the GeneralLedger interface table.(ntry4 Upload4 Submit:!ou can enter budget data, upload that data, and submitbudget import processes.

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application, responsibility, or user level.

    GL!*: 5ournal 'i3ard Pri+ileges

    "pecify the 7ournal i&ard usage privileges. #he following values are available to you:None:!ou cannot use this feature.(ntry:!ou can only enter 8ournals in a 8ournal wor5sheet.(ntry4 Upload:!ou can enter 8ournals and upload them to the General Ledgerinterface tables.(ntry4 Upload4 Submit:!ou can enter 8ournals, upload them, and submit 8ournal

    import processes.!ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application, responsibility, or user level.

    GL!*: Report 'i3ard Pri+ileges

    "pecify the -eport i&ard usage privileges. #he following values are available to you:None:!ou cannot use this feature.!efine:!ou can define reports but cannot submit them.Submit:!ou can submit reports but cannot define them.!efine4 Submit:!ou can define and submit reports.

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application, responsibility, or user level.

    *nter)ompany: Subsidiary

    "pecify the subsidiary name 9defined on the "ubsidiaries window to which aresponsibility can enter intercompany transactions using the /0#-) system.

  • 7/21/2019 GL Setup List

    11/88

    !ou cannot view this profile option at the user level. !our "ystem )dministrator must setthis profile option at the site, application, or responsibility level.

    *nter)ompany: Use Automati) -ransa)tion Numbering

    "pecify whether General Ledger uses automatic transaction numbering for intercompanytransactions made in the /0#-) system. #he following values are available to you:No:!ou must enter uni*ue transaction numbers manually.0es:General Ledger generates transaction numbers automatically.

    !ou cannot view this profile option at the user level. !our "ystem )dministrator must setthis profile option at the site or application level.

    5ournals: Allow Multiple (/),ange Rates

    "pecify whether you want to allow multiple conversion rates within a 8ournal entry. #hefollowing values are available to you:

    0es: !ou can override the converted amount when you enter 8ournals.No: !ou cannot override the converted amount when you enter 8ournals.#he default value for this profile option is 0o.

    !ou can set this profile option at the user level. r, your "ystem )dministrator can setthis profile option at the site, application, responsibility or user level.

    5ournals: Allow Non#%usiness !ay -ransa)tions

    "pecify whether you want to allow posting on non%business days. +usiness and non%business days are defined on the #ransaction alendar. #he following values are available

    to you: 0es:!ou can post transactions on non%business days.No: !ou cannot post transactions on non%business days.

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application, responsibility, or user level.

    5ournals: Allow Posting !uring 5ournal (ntry

    In earlier releases of General Ledger, this profile option specified whether you wanted toallow posting from the /nter 7ournals window. )s of -elease ==, security over posting ishandled by racle )pplications( function security features.

    If you are a new customer, this profile option will not appear in any lists of availableprofile options. If you are an e1isting customer, the profile option will appear, butGeneral Ledger will ignore any value you have set for it.

    5ournals: Allow Preparer Appro+al

  • 7/21/2019 GL Setup List

    12/88

    "pecify whether preparers can approve their own 8ournal batches. #he following valuesare available to you:

    0es:Preparers are allowed to approve 8ournal batches that fall within theirauthori&ation limit.No: Preparers cannot approve their own 8ournal batches.

    #he default value for this profile option is 0o.

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application, responsibility or user level.

    5ournals: !efault &ategory

    "pecify the default 8ournal entry category. hen you enter manual 8ournal entries, thecategory will default to the category you specify here.

    !ou can set this profile option at the user level. !our "ystem )dministrator can set this

    profile option at the site, application, responsibility or user level.

    5ournals: !isplay *n+erse Rate

    "pecify how you enter and display conversion rates in the /nter 7ournals window. #hefollowing values are available to you:

    0es:!ou can enter and display conversion rates in the functional%to%foreignformat, that is, the rate by which you multiply a functional amount to determinethe foreign amount.No: !ou can enter and display conversion rates in the foreign%to%functionalformat, that is, the rate by which you multiply a foreign amount to determine the

    functional amount.#he default value for this profile option is 0o.

    !ou can set this profile option at the user level. r, your "ystem )dministrator can setthis profile option at the site, application, responsibility or user level.

    5ournals: (nable Prior Period Notifi)ation

    "pecify whether General Ledger should notify you when you are entering a 8ournal for aprior period. #he following values are available to you:

    0es:General Ledger will display a message when you are entering a 8ournal for a

    prior period. !ou have to confirm that this is what you want to do.No:General Ledger will not notify you when you enter a prior period 8ournal.!ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application, responsibility, or user level.

    5ournals: .ind Appro+er Met,od

  • 7/21/2019 GL Setup List

    13/88

    "pecify the default approval method for the 7ournal )pproval process. #he followingvalues are available to you:

    Go Up Management &,ain:#he 8ournal batch moves up the approval hierarchyuntil it has been approved by an approver whose authori&ation limit is sufficient toallow approval. #he 8ournal batch must be approved by all intermediate approvers

    as well.Go !ire)t:#he 8ournal batch is sent directly to the first approver in the approvalhierarchy who has an authori&ation limit high enough to allow approval. #hepreparer(s direct manager receives a courtesy notice.One Stop -,en Go !ire)t:#he 8ournal batch is first sent to the preparer(smanager for approval. If further approvals are re*uired, the 8ournal batch is sentdirectly to the first approver in the approval hierarchy who has an authori&ationlimit high enough to allow approval.

    #he default value for this profile option is Go Up 3anagement hain.

    !ou cannot view this profile option at the user level. !our "ystem )dministrator must set

    this profile option at the site, application, or responsibility level.

    5ournals: Mi/ Statisti)al and Monetary

    hoose whether to enable users to enter statistical amounts along with monetary amountsin the /nter 7ournals window. #he following values are available to you:

    0es: !ou can enter statistical amounts along with monetary amounts when youenter 8ournals. #he window appears only for those accounts for which you definea statistical unit of measure.No: !ou are not able to enter statistical amounts along with monetary amounts inthe /nter 7ournals window.

    #he default value for this profile option is 0o.

    !ou can set this profile option at the user level. r, your "ystem )dministrator can setthis profile option at the site, application, responsibility or user level.

    5ournals: O+erride Re+ersal Met,od

    "pecify whether users can override the default reversal method when they reverse a8ournal. #he default reversal method is specified when you define 8ournal categories. #hefollowing values are available to you:

    0es:Users can change the default reversal method when they are reversing

    8ournals.No:Users cannot change the default reversal method when they are reversing8ournals.

    !ou can only view this profile option at the user level. !our "ystem )dministrator mustset this profile option at the site, application, responsibility, or user level.

    MR&: Reporting Set of %oo2s

  • 7/21/2019 GL Setup List

    14/88

    "ee: 3ultiple -eporting urrencies

    Use Performan)e Module

    "pecify whether General Ledger concurrent programs will ma5e use of the statistical data

    collected by the General Ledger ptimi&er program to enhance the performance of someconcurrent programs. #he concurrent programs affected include Posting, "ummari&ation,3ass)llocations, onsolidation, !ear /nd arry 'orward, +udget -ange )ssignmentsand 4istorical -ates )ssignment.

    #he default value for this profile option is !es, and we strongly advise you 0# changeit unless specifically told by racle ustomer "upport.

    G/0/-)L L/DG/- '-/@U/0#L! )"A/D @U/"#I0"

    0#/0#":

    )U0# I0@UI-!6D-ILL D0+UDG/#")L/0D)-0"LID)#I0-""%2)LID)#I0U--/0I/", -/2)LU)#I0, #-)0"L)#I0, 02/-"I0,-/2)LU)#I0DU3/0# "/@U/0/"

    'L/B'I/LD"'"GGL+)L I0#/-3P)0! "!"#/3I0#/-3P)0! 7U-0)L"7U-0)L /0#-!, -/2/-"I0G, -/U--I0G7U-0)L I3P-#3)"" )LL)#I0"G/0/-)L L/DG/- % 3-P/06L"/ P/-ID"P/ C )PPLI)#I0

    "/G3/0# "/U-I#! -UL/"

    )U0# I0@UI-!6D-ILL D0

    @U/"#I0"=. hat "ubledgers does racle General Ledger ==i Drilldown support?. hat are the application ob8ects that support 2iew )ccounting and Drilldown

    http://download.oracle.com/docs/cd/A60725_05/html/comnls/us/mrc/prodtop.htm#contentshttp://download.oracle.com/docs/cd/A60725_05/html/comnls/us/mrc/prodtop.htm#contents
  • 7/21/2019 GL Setup List

    15/88

    >. here in racle General Ledger ==i can Drilldown be accessedE. hat are the -elease ==i "ubledger drilldown featuresF. Get the following message on Drilldown % 'unction not available to this

    responsibility. hange responsibility or contact your system administrator.. hen you drill down to )B Payables or -eceivables from GL, you get the message

    '-3%EF< @uery caused no records to be retrieved.

    @U/"#I0" C )0"/-":

    = hat "ubledgers does racle General Ledger ==i Drilldown support )nswer

    %%%%%Drilldown from racle General Ledger ==i is supported for racle Payables, racle-eceivables, racle )ssets 9e1cept depreciation, Pro8ects, Purchasing, Inventory, andor5 in Process 9IP.

    ? hat are the application ob8ects that support 2iew )ccounting and Drilldown)nswer%%%%%%

    GLHImportH-eferenceH#able 9modified 'or /1ample Invoices imported fromPayables into GL goes to this table from GLHInerface table.GLH"LHLI0AHIDGLH"LHLI0AH#)+L/GLH7/HLI0/" 9modifiedGLH"LHLI0AHIDGLH"LHLI0AH#)+L/

    0ew views in the database:

    ')H)/LHGLH2')H)/LH"LH3-H2')H)/LH"LH2

    > here in racle General Ledger ==i can Drilldown be accessed)nswer%%%%%%!ou can drilldown from GL )ccount In*uiry window and the GL 7ournal /ntry andGL 7ournal In*uiry windows. 0av: #ools %% Drilldown

    E hat are the -elease ==i "ubledger drilldown features)nswer%%%%%%% /1panded "ubledger drilldown, to other subledgers.% 2iew )ccounting Lines window.

  • 7/21/2019 GL Setup List

    16/88

    F Get the following message on Drilldown % 'unction not available to thisresponsibility. hange responsibility or contact your system administrator.)nswer%%%%%%3a5e sure you have the orrect 3enu attached to the -esponsibility you are

    Using to drill down.

    hen you drill down to )B Payables or -eceivables from GL, you get the message'-3%EF< @uery caused no records to be retrieved.)nswer%%%%%Make sure you set the Profile Option AX: Application Name to Null.

    +UDG/#"@U/"#I0"

    =. an you disable budgetary control for a set of boo5s?. Is there a limit to the number of periods in a budget year or how many years a budget

    can span>. hy don(t my Detail budgets roll up to my 3aster budgetE. I was able to post a budget 8ournal to a closed period, whyF. 4ow many (urrent( budgets can you have. hy don(t my budget amounts appear on '"Gs. hat is a funding budget;. hy is my budget re*uiring budget 8ournals )t the set of boo5s level that option is

    not enabledJ. hy can(t I in*uire on my budget amounts from I0@UI-/6+UDG/#" navigation

    path=. 4ow many times can a budget be purged=E. hy don(t my asset and liability budgets roll forward=F. hy do you receive an advisory warning during funds reservation of a manual

    8ournal entry, even though there are sufficient funds in the account=. hy is there no value in the -/@U/"#HID column of GLH+UDG/#HI0#/-')/

    for rows with data that failed to be uploaded by the +udget "preadsheet Uploadprogram !ou are trying to open the ne1t budget year. )fter navigating to the formand *uerying the budget, you notice the Kpen 0e1t !ear button is grayed out. !oufind that )ccount code combinations are not being added to the +udget rgani&ation

    @U/"#I0" C )0"/-":

  • 7/21/2019 GL Setup List

    17/88

    =. an you disable budgetary control for a set of boo5s)0"/-%%%%%%%!es you can however e1isting encumbrances are not cleared from the feeder systems.

    #herefore it is not recommended. If you do change the budgetary control options foran e1isting set of boo5s, you must do two things for the change to be reflected.%%-un the Period 3ap 3aintenance concurrent re*uest, it must complete successfully.%%/1it racle )pplications and restart.!ou must completely e1it the application...it is not sufficient to select "ign on againfrom the racle )pplications "pecial menu. -ef: racle GL User(s Guide, -el ==, 2ol=, page ?%J. 4ow many times can a budget be purged)0"/-%%%%%%%) budget can only be purged one time. #he archive6purge functionality was notdesigned to be a maintenace tool in the budgeting process.

    =E. hy don(t my asset and liability budgets roll forward)0"/-%%%%%%%#his is the current functionality. )n enhancement re*uest has been logged.

    =F. hy do you receive an advisory warning during funds reservation of a manual8ournal entry, even though there are sufficient funds in the account)0"/-%%%%%%%!ou are getting the advisory warning because your transaction is going against adetail account where no budget has been entered. "o even though there are sufficientfunds on the summary level, there are not sufficient funds at the detail level. #hefunds chec5ing6reservation process will loo5 at the funds chec5 level for the detailaccount first, and then the funds chec5 level for the summary account. #he warning isalerting you to the fact that the detail account you are entering a transaction againstdoes not have sufficient funds available. hen you 5now there are sufficient funds atthe summary level, you must either change your funds chec5 level on your detailaccount to none 9to only loo5 at the summary level, or enter a sufficient budget to allthe detail accounts that you will be entering transactions against, if you don(t want tosee the warning. -eference%0ote =

  • 7/21/2019 GL Setup List

    20/88

    "tatus M pen+udget Periods +loc5%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'irst M 7)0%J Last M D/%JLatest pen !ear M =JJ%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

    P-+L/3 /BPL)0)#I0%%%%%%%%%%%%%%%%%%%#he last day of the Last Period defined in your +udget has already passed.

    "LU#I0 D/"-IP#I0%%%% %%%%%%%%%%%%%%%%#he Define +udget form loo5s at the periods you have defined as $'irst$ and $Last$.nce the $Last$ date has passed, you will no longer be able to open the ne1t year9#he $pen 0e1t !ear$ button will be grayed out. General Ledger views this +udgetas finished since the end date has e1pired. )ccording to the General Ledger User(sGuide for -elease =

  • 7/21/2019 GL Setup List

    21/88

    N Dropped 6 recreated summary template."LU#I0 D/"-IP#I0%%%%%%%%%%%%%%%%%%%%+udgeting must be enabled in the )ccount ombination screen.-esponsibility M General Ledger "uper User

    GUI 0avigation M "etup6)ccounts6ombinationsDo a *uery to pull up the desired combinations 9@uery /nter6@uery -un.3a5e sure the )llow +udgeting bo1 has been chec5ed for all the account codecombinations within the range you assigned.

    "LU#I0 /BPL)0)#I0%%%%%%%%%%%%%%%%%%%%)ssigning budget account ranges will assign accounts within the given range if theyhave been enabled for budgeting. therwise, they will fail.

    )L/0D)-:

    @U/"#I0":=. !ou want to change the period dates because of a change in business needs or amista5e was made when it was set up. 4ow can you fi1 this

    ?. an I add an ad8usting period to my calendar>. !ou defined a Period #ype and now have decided that you want to change the periods

    per year that are associated with the Period #ype. 4ow can you do thisE. hat are the year types ('iscal( and (alendar( used forF. !ou are setting up a new set of boo5s and a calendar and are not sure how much of

    the first year you need to define in the calendar. Do you need to define an entire yearfor the first year in your calendar if you are only going to open the last period in thatyear

    . !our calendar year is changing from a fiscal year to a calendar year, and you alreadyhave a set of boo5s that is using the fiscal year calendar. 4ow can you change yourcalendar in GL

    . !ou opened a period by mista5e and want to set the status bac5 to 'uture /nterable.4ow can you do this

    ;. #he year was specified incorrectly on your calendar periods. 4ow can you fi1 thisJ. #he !ear #ype in your Period #ypes form is not what you want. !ou used 'iscal

    instead of alendar or visa versa. an it be changed=

  • 7/21/2019 GL Setup List

    22/88

    correct period dates. !ou can run onsolidation to move the General Ledger balancesfrom the old set of boo5s to the new set of boo5s. 'or step by step instructions on theonsolidation process, refer to the racle General Ledger User(s Guides. #his mayalso mean that you need to re%install your subledgers so they will use the new set ofboo5s. -eferences:0ote F.=% "cripts to chec5 calendar setup

    ? an I add an ad8usting period to my calendarAnswer: !ou can only define the number of periods that is specified by the Period#ype you are using for your set of boo5s. 'or e1ample, if, for your set of boo5s, youare using a Period #ype of 3onth, and 3onth is defined to have =? periods per year,you can only define =? periods of Period #ype 3onth for any one year, on thealendar form.

    > !ou defined a Period #ype and now have decided that you want to change the periodsper year that are associated with the Period #ype. 4ow can you do thisAnswer:nce you define a Period #ype and save it, you cannot change it. If you

    need to change the number of periods then you have to define a new Period #ype anda new "et of +oo5s to use that new Period #ype.

    E hat are the year types ('iscal( and (alendar( used forAnswer:#he !ear #ype 9'iscal or alendar is used only to determine which twodigits to append to the system generated period name. -egardless of which !ear #ypeis used, the (!ear( entered on the alendar form must be the same for all periods inyour fiscal year % whether it is a calendar year or a fiscal year.If !ear #ype M alendar: #he last ? digits of the ('rom( date for the period are used.If !ear #ype M 'iscal: #he last ? digits of the value in the (!ear( are used.

    F !ou are setting up a new set of boo5s and a calendar and are not sure how much ofthe first year you need to define in the calendar. Do you need to define an entire yearfor the first year in your calendar if you are only going to open the last period in thatyearAnswer:0o, you do not have to define the entire year. !ou only define the periodsyou need, but of course without gaps between periods. -emember to define one priorperiod if you will be translating. /1ample: !ou want to start entering transactions for7anuary ?

  • 7/21/2019 GL Setup List

    23/88

    = reate a new calendar and set of boo5s%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%reate a new calendar, with the correct periods, and define a new set of boo5s thatuses that calendar. -un onsolidation to move your balances from the e1isting set ofboo5s to the new set of boo5s. !ou may also need to re%install your subledgers so they

    will use the new set of boo5s.

    -

    ? Update the e1isting calendar%%%%%%%%%%%%%%%%%%%%%%%%%%%%a Define the periods for your short year 9)pril through December. !ou must define

    the number of periods that are e1pected for the Period #ype you are using. In thise1ample, it is =?. "o you will need to define J regular periods, and > ad8ustingperiods. #he !ear must be defined as the ne1t se*uential year. Define the periodsfor the ne1t year. #his is the first year that runs from 7anuary through December.

    #he !ear must be defined as the ne1t se*uential year.

    !ou opened a period by mista5e and want to set the status bac5 to 'uture /nterable.4ow can you do thisAnswer:#his is 0# supported. !ou can not set a period status bac5 to futureenterable after it has already been opened. If you do, it will cause corruption in theglHbalances table.

    ; #he year was specified incorrectly on your calendar periods. 4ow can you fi1 thisAnswer: !ou cannot ma5e changes to calendar periods in the form if the period is inan open budget year, open encumbrance year, or the status is pen, 'uture /nterableor losed. #he solution is to create a new set of boo5s that uses a new calendar withthe correct period dates. !ou can run onsolidation to move the General Ledger datafrom the old set of boo5s to the new set of boo5s.#his may also mean that you need tore%install your subledgers so they will use the new set of boo5s.

    J #he !ear #ype in your Period #ypes 'orm is not what you want. !ou used 'iscalinstead of alendar or visa versa.Answer:#he !ear #ype 9'iscal or alendar, is used only to determine which twodigits to append to the system generated period name. hat are the year types ('iscal(and (alendar( used for

    =

  • 7/21/2019 GL Setup List

    24/88

    ?. hat do the consolidation -un options mean>. GLB)-: "hows a difference in December onsolidation.E. onsolidation of translated balances caused wrong numbers for misclassify account.F. 4ow do you 5eep from doubling the data when re%running onsolidation. hen consolidating for the first time choose!#D )mount.

    . onsolidation of #wo 3aster rgani&ations into ne.;. onsolidation List of 2alues for Period contains no entries.J. larification of 7ournal #ype and )verage +alance Processing.=

  • 7/21/2019 GL Setup List

    25/88

    >. GLB)-: "hows a difference in December onsolidation !ou e1ecuted theconsolidation process and an unbalanced 8ournal is generated. If you loo5 at theonsolidation )udit -eport, there is a difference.

    Answer:#he problem is that the consolidation rules were defined with overlappingaccount ranges. -eview consolidation rules and fi1 the overlapping ranges:a. 0avigate to onsolidation6Define.b. @uery up the consolidation.c. Press K)ccount -ules +uttond. Loo5 for the rules with overlapping ranges and update them.e. -epeat > and E for the $"egment -ules$ +uttonhen you have overlapping ranges in the consolidation rules, the same information isconsolidated more than once and it can generate an unbalanced 8ournal.

    E. onsolidation of translated balances caused wrong numbers for misclassify account

    Anwer:!ou had an )""/# account that was classified as an e1pense, thereby causingit to close out into retained earnings at the end of the fiscal year. !ou chose only tocorrect the account type and 8ust ma5e a 8ournal entry to correct the balances in thefirst period of the 0ew !ear. !ou then ran translation for the 'irst period of the 0ew!ear. #hen you ran the consolidation program, and posted the entry in theconsolidated set of boo5s. #he balance the above mentioned account did not appear tobe correct. #he problem is that you did not ma5e the entry to correct the balances inthe first period in the consolidated set of boo5s, thereby getting only period to dateactivity in the account. )fter you made the entry the year to date balance was correct.

    F. 4ow do you 5eep from doubling the data when re%running onsolidationAnswer:!ou want to 5now how to prevent data from doubling when you re%run a

    onsolidation. !ou ran onsolidation once. #hen you ran it again. #he data hasdoubled. If you ran onsolidation a second time and re%posted the data, it would bedoubled. !ou need to reverse out the previous onsolidation 7ournal as follows:-esponsibility M General Ledger "uper UserGUI 0avigation M 7ournals6/ntera. @uery up the onsolidation 7ournalb. lic5 on the K3ore )ctions buttonc. lic5 on the K-everse 7ournal button to reverse.!ou need to reverse out the previous onsolidation 7ournal. Usually onsolidation isrerun because there is a problem6error in the first run. In this case, the previous postedbatch needs to reversed.

    . hen onsolidating for the first time choose !#D )mount.Answer:hen running consolidation for the first time, it is best to run a !#Dconsolidation instead of a P#D consolidation. P#D consolidation will onlyconsolidate the period net activity. If you want to consolidate the subsidiary boo5(sbeginning balances, you will need to run a !#D consolidation. )lso, if you areconsolidating a first%ever translated period, the using P#D consolidation is probably a

  • 7/21/2019 GL Setup List

    26/88

    bad idea %% due to a lac5 of history you cannot really distinguish the translated beginbalances from the translation ad8ustment for the new rate. +oth get clumped into thebegin balance.

    . onsolidation of #wo 3aster rgani&ations into ne

    Answer:!ou would li5e to 5now if there is any documentation that discusses theconsolidation of two master organi&ations into one. !ou would li5e to 5now how tomigrate from multiple master organi&ations to a single master and > children. "ee theracle )pplications -elease =

  • 7/21/2019 GL Setup List

    27/88

    GLH+)L)0/" and GLHD)IL!H+)L)0/". 'or a non%consolidation set ofboo5s:- !ou do not select a 7ournal #ype.- Posting will update the GLH+)L)0/".- Posting will update GLHD)IL!H+)L)0/" if average balance processing is

    enabled'or a consolidation set of boo5s:% #he lin5 e1ists between GLH+)L)0/" and GLHD)IL!H+)L)0/" 9i.e.,causing a post to update both tables- !ou can specify the 7ournal #ype 9"tandard or )verage- #he "tandard 7ournal #ype usage will cause GLH+)L)0/" only to be updated.- #he )verage 7ournal #ype usage will cause GLHD)IL!H+)L)0/" only to be

    updated.- In a consolidation set of boo5s, with )verage Daily +alance enabled you would

    want more control over average balances maintained by date. 4ence the optionwas provided to allow posting using a 8ournal type of )verage which affects only

    the GLHD)IL!H+)L)0/". hen does the calculation of averages occur

    Answer: Data is stored in the GLHD)IL!H+)L)0/" table and information iscalculated and output at run time based on the *uery or report being run. 0ote: =

  • 7/21/2019 GL Setup List

    28/88

    =. 0avigate to the #ransfer onsolidation Data "et window by clic5ing ononsolidation6#ransfer6Data "et.?. @uery the Data "et by placing your cursor in the 3apping "et and clic5ing the listof values icon on your toolbar.>. hen you enter the "ubsidiary Default Parameters Period, the only calendar

    displayed in your list of values is the Parent calendar. #his does not match thecalendar for one or more of the subsidiaries you want to consolidate. *n order tosele)t from your list of +alues4 a )alendar for t,e subsidiaries4 w,i), do not s,are

    t,e same )alendar as t,e parent4 you will need to do t,e following:

    -esponsibility M General Ledger "uper UserGUI 0avigation M onsolidation6#ransfer6Data "etGUI 'rom 0ame M GLB-"# 9#ransfer onsolidation Data "et=. 0avigate to the #ransfer onsolidation Data "et window by clic5ing ononsolidation6#ransfer6Data "et.?. @uery the Data "et, which has the mapping you would li5e to consolidate byplacing your cursor in the 3apping "et field and clic5ing on the list of values icon on

    your toolbar.>. "elect the "ubsidiary Default Parameters (Period( you would li5e to consolidatefrom the list of values.E. "elect the Parent Period ("tandard( value you would li5e to consolidate from the listof values.F. lic5 on the K@uery 3appings button to *uery the mappings in the mapping set.. lic5 on the K)pply Defaults button to apply the defaults for these mapping sets.. !ou should now be able to select the mapping9s which contain the subsidiary withthe calendar that is different than the Parent calendar.=. nce you select the "ubsidiary Period for that mapping set, the subsidiary

    calendar should be displayed in your list of values.?. !ou can then save these settings and the calendars will be set up for the Data "et.0ote: =

  • 7/21/2019 GL Setup List

    29/88

    account code combination you defined in the )ccount -ule, not the value you wereintending."olution Description%%%%%%%%%%%%%%%%%%%%#o correctly map your subsidiary accounts, "egment > )ction should be (Use -ollup

    -ules 'rom(, instead of (0ot )ssigned(. #hen under the -ollup -ules section, map arange of detail values from your subsidiary set of boo5s into one detail value in yourparent set of boo5s. !ou can enter multiple rollup rules for a single segment as long asthe segment values specified in each rule do not overlap. !ou can enter more than onesubsidiary segment range as long as the segment values included in the ranges do notoverlap. A))ount rules o+erride segment rules if t,ere is any )onfli)t6

    -""%2)LID)#I0@U/"#I0":

    =. 4ow do I enable cross validation?. hy are my cross validation rules not wor5ing>. an you use parent values in your cross%validation rulesE. 4ow are cross validation rules evaluatedF. here is the ross%2alidation -eport and ross%2alidation -ules Listing -eport

    located. an the ross%2alidation -ules 2iolation -eport Disable )ccount ode

    ombinations. an you define cross validation rules for a set of boo5s

    @U/"#I0" C )0"/-"%%%%%%%%%%%%%%%%%%%%%= 4ow do I enable cross validation

    Answer:!ou navigate to "etup6'inancials6'le1fields6Aey6-ules. !our rules are notwor5ing and6or you cannot see anything in your list of values for )pplication"tructure and 'le1field #itle. Using General Ledger "uper User -esponsibility0avigate to "etup6'inancials6'le1field6Aey6"egmentshec5 chec5bo1 for ross%2alidate "egments "ave

    ? hy are my cross validation rules not wor5ingPossibly these code combinations were created before your rules were established.0ow after turning on the cross%validation rules they are not ta5ing effect. #his is theway the system wor5s. -ules are not retroactive. #hey apply only to segment valuecombinations entered after they are defined and enabled. !ou may have to disablethese code combinations if they are not longer considered valid. 0avigate to"etup6)ccount6combinations. @uery your combination.

    > an you use parent values in your cross%validation rules

  • 7/21/2019 GL Setup List

    30/88

    -,e )ross#+alidation rules are independent of t,e +alue ,ierar),y6 (+en if a

    parent +alue falls under t,e range of an (/)lude type )ross#+alidation rule4 its

    ),ildren are not e/)luded unless t,e ),ild +alues also fall under t,e range6

    E 4ow are cross validation rules evaluated

    #o pass a rule, a combination must be included in at least one Include element, andmust not be included in any /1clude element. #he combination is considered to beincluded in an element if all of the segment values fall within the low and high rangeof that include or e1clude element. #he ross 2alidation -ules are evaluatedalphabetically. #he /1clude elements are loo5ed at first. "ee0ote =

  • 7/21/2019 GL Setup List

    31/88

    =E. hat populates the "#)#U"HD/ in the GLHD)IL!H-)#/" #able=F. an the user conversion type be suppressed in the list of values on the enter 8ournals

    form

    @U/"#I0" C )0"/-":

    = 4ow to run revaluation again in a previous period.Answer: !es, you can run revaluation more than once in a period. +ased on the-evaluation calculation, any additional 8ournal entries posted after the initial-evaluation 8ournal has been posted, will be pic5ed up in the balances that aresubse*uently revalued in that same period. #he subse*uent -evaluation 8ournal entrywill then represent the incremental change in the revalued balance, due to theadditional 8ournal entries posted )fter the initial -evaluation. 0ote: =

  • 7/21/2019 GL Setup List

    32/88

    F )re there scripts that can be used to e1tract data necessary to verify revaluationformulaAnswer:!#D script: "@L select codeHcombinationHid,#-)0"L)#/DH'L)G,U--/0!HD/,P/-IDH0/#HD-, P/-IDH0/#H-, +/GI0H+)L)0/H D- ,

    +/GI0H+)L)0/H - ,P/-IDH0/#HD-H+/@, P/-IDH0/#H-H+/@,+/GI0H+)L)0/HD-H+/@, +/GI0H+)L)0/H - H+/@'rom GLH+)L)0/"here D/H3+I0)#I0HID M O "/#H'H+A"HI D M O )0DP/-IDH0)3/ M O P#D script:"@L select codeHcombinationHid, #-)0"L)#/DH'L)G, U--/0!HD/,P/-IDH0/#HD-, P/-IDH0/#H-, P/-IDH0/#HD-H+/@,P/-IDH0/#H-H+/@,'rom GLH+)L)0/"

    here D/H3+I0)#I0HID M O "/#H'H+A"HI D M O )0DP/-IDH0)3/ M O 0ote: ==JJ.=

    an you change the automatic reversal entries for revaluationAnswer:-evaluation assumes that the customer will want reverse the 8ournals in thefollowing period as to not do so would mean the -eali&ed urrency e1change gain orloss is not recogni&ed in that months accounts. 7ournals created by revaluation aretherefore mar5ed available for reversing in the ne1t non%)d8usting period see. In ==iyou can also automatically reverse 8ournals by categorybut this is not obligatory. 0ote: =??=.=

  • 7/21/2019 GL Setup List

    33/88

    ?. #a5e the total of assets and liabilities and multiply this amount by the period endrate.

    >. #a5e the total of your retained earnings and use the historical amount or 3ultiplyby historical rate 9whichever way you have defined it.

    E. )dd =,? and > together. #his should e*ual the amount in your translation

    ad8ustment account, with the opposite sign.F. 3a5e sure no other entries have been made to the account. If there are they wouldhave to be bac5ed out in order to reconcile the amount. 0ote: = is included in GL Patchset / ==;;> = and

  • 7/21/2019 GL Setup List

    34/88

    urrent 3onth 4istorical -ate M /nding #ranslated balance."et to !#D: #ranslated urrency !#D M 'unctional urrency !#D N -ate !#Dtranslation of wner(s /*uity )ccounts calculation does not ta5e into account thehistorical rates that were in effect at the time of each transaction in the account.'or =

  • 7/21/2019 GL Setup List

    35/88

    F. an document se*uencing be used for some categories in a set of boo5s, but not all. ill a reversed 8ournal have the same se*uence as the original 8ournal.

    @U/"#I0" C )0"/-"%%%%%%%%%%%%%%%%%%%

    = Is Document "e*uencing valid for budget 8ournalsAnswer%%%%%%Document se*uences only apply to actual 8ournal entries. +udget and encumbrance8ournal entries will not wor5 with document se*uencing.

    ? here do you setup the GL document se*uencing so you can see the categories!ou have created document categories for each of your companies and have lin5edthese categories to an assignment in the "e*uence )ssignment form. 0avigationM"etup:'inancials:"e*uences:)ssign 9'0D"0)"@. hen you go into the 8ournalsentry form and try to select the new category that you have created, you do not see the

    new category. !ou have the same setup in )P and it wor5s fine. Is there somewhereelse they need to setup the categories)nswer%%%%%%Document categories for 7ournal /ntries must be setup in GL. 'ollowing is a briefe1planation of how to set up document se*uencing for 8ournal entries. In "ystem)dministrator -esponsibility, you need to set the profile option ("e*uential0umbering( to Partially Used at the )pplication 9GL and -esponsibility 9your GLresponsibility levels and commit. In your GL responsibility:a. 7ournal categories % create a new record and set the reversal method to "witchDr6r and commit. 9"etup: 7ournal: ategoriesb. Document "e*uences % create a new record as follows: )pplicationMGLR'romMOstart dateR #ypeMmanualR Dist... )ccessMGL and commit. 9"etup: 'inancials:"e*uences: Define.c. "e*uence assignments % create a new record with: )pplicationMGLR ategoryM#est1y&R "+MOyour set of boo5s nameR 3ethodMmanualR "tart DateMOstart dateR"e*uenceM#est1y& and commit. 9"etup: 'inancials: "e*uences: )ssign/nter a new 8ournal and tab through Document 0o. )nd do not enter a number. #hisshould result in the following error: )PP%=>; % $#he se*uence #est1y& is typemanual. !ou must enter a value.$ +y entering a number you should be able to save the7ournal /ntry. GL document categories are not available to the "ystem )dministrationresponsibility and cannot be setup there. &reation of do)ument )ategories inSysAdmin updates .N!7!O&7S(8U(N&(S7&A-(GOR*(S but w,en )reated

    in GL t,e re)ord is inserted into GL75(7&A-(GOR*(S6#hus, categories mustbe setup through a GL responsibility 9e.g. GL "uperuser with the re*uired GL setupforms6menu functions enabled.0#/: #his above e1ample is not a complete setup of document se*uences. In orderto use document se*uences with programs such as 8ournal import that willautomatically assign a se*uence number, you must set up an automatic se*uence andcreate an assignment with an automatic method.

  • 7/21/2019 GL Setup List

    36/88

    > 4ow is the profile option ("e*uential 0umbering( used)nswer%%%%%%"e*uential 0umbering assigns numbers to documents created by forms in racle

    financial products. "e*uential numbering provides a method of chec5ing whetherdocuments have been posted or lost. 0ot all forms within an application may beselected to support se*uential numbering. "e*uential numbering has the followingprofile option settings:)lways Used % !ou may not enter a document if no se*uence e1ists for it.0ot Used % !ou may always enter a document.Partially Used % !ou will be warned, but not prevented from entering a document,when no se*uence e1ists.Users can see this profile option, but they cannot update it. #his profile option isvisible and updatable at the site, application and responsibility levels. #he internalname for this profile option is U0I@U/:"/@H0U3+/-".

    E an you set up document se*uences for 7ournal ategories in the "ystem )dmin-esponsibility)nswer%%%%%%0o you have to set up document se*uencing for 7ournal ategories in the GeneralLedger responsibility as this updates an e1tra table in GL.

    F an document se*uencing be used for some categories in a set of boo5s, but not all)nswer%%%%%%!es. Document se*uencing is specific to to the combination of set of boo5s6category."o yes you can have some categories within a set of boo5s that have documentse*uencing while other categories in the same set of boo5s do not have documentse*uencing.

    ill a reversed 8ournal have the same se*uence as the original 8ournal.)nswer%%%%%%It can do if an automatic method is assigned to the se*uence as well as a manualmethod. -eversals are generated by the system, so the system considers them to beautomatic transactions. 'or document se*uences to be applied to automatictransactions, the category must have a document se*uence assignment with a methodof automatic. 3anual method refers to 8ournal entries that you enter manually on the/nter 7ournals form. )utomatic method refers to transactions that are generatedautomatically by General Ledger.

    'L/B'I/LD":

  • 7/21/2019 GL Setup List

    37/88

    =. 4ow do you disable a segment value and code combinations so 8ournals will not becreated with these accounts

    ?. If the )ccounting 'le1field structure is not fro&en, why does the "horthand )lias form9'0D''3") allow updates

    >. 4ow do you update segment *ualifiers or rollup groups for an e1isting value

    E. 4ow do you add a new value to an e1isting segmentF. 4ow do I 5now which accounts are inactive. an you add or delete segments to an e1isting accounting fle1field structure. hich table stores the parent value and its( child ranges;. hat tables store segment values and their descriptionsJ. Do all segments of your accounting fle1field have to be enabled and displayed=

  • 7/21/2019 GL Setup List

    38/88

    @U/"#I0" C )0"/-":= 4ow do you disable a segment value and code combinations so 8ournals will not be

    created with these accounts!ou must disable the segment, and disable every code combination that uses that

    segment. In version == and prior, you must disable each code combinationindividually. 4owever, in ==i, you can disable a range of code combinations using thenew Segment "alue *n,eritan)e program6

    ? If the )ccounting 'le1field structure is not fro&en, why does the "horthand )lias form9'0D''3") allow updates#his form should become non%updateable and non%insertable if the fle1field is notfro&en. +ug = 4ow do you update segment *ualifiers or rollup groups for an e1isting value!ou need to unfree&e all fle1fields that use the value set. #hen you should be able to

    update the values. "ee note =

  • 7/21/2019 GL Setup List

    39/88

    as 3ass )llocations(. #he only supported solution therefore, is to have all segmentsdisplayed from the start, and for them to remain that way.

    =

  • 7/21/2019 GL Setup List

    40/88

    = !ou receive )PP%=FE and -)%J. )pply patch F;> or '0D Patchset '

    9==FFE

    = !ou received )PP%

  • 7/21/2019 GL Setup List

    41/88

    ? hange the segment name to a proper name 9if necessary> hange the value set value type from constant to char and default value 9ifnecessaryE free&e the accounting fle1 field and recompile

    ?F Disabling an account code segment value does not prevent transactions to be enteredto all account code combinations. Is this a bug#his is the functionality of the application. Disabling the segment value does notdisable the account code combinations associated with it. Disable the account codecombinations separately or run the Inherit "egment 2alues process which will disableall the account code combinations associated with this particular segment valueautomatically.

    ? hat is the difference between 4ierarchical and 0on%hierarchical "ecurity #ype4ierarchical "ecurity: #his feature combines 'le1 2alue "ecurity and 'le1 2alue4ierarchy. #he end result is (a fle1 value is secured if one of it(s parents is secured(.

    ith non%hierarchical security, the child values do not inherit the parent security.

    ? hy can you update the "egment 2alues form 9'0D''3"2 when the fle1fieldstructure is fro&en!ou do 0# need to Unfree&e 'le1fields to amend "egment @ualifiers from'0D''3"2 ==.F.?; 9'0D patchset onwards, for -elease ==i. Due to customerre*uests, patch =E;?has been raised to reflect this change to functionality,since the ==i User(s Guide does not advise of the change.

    ?; "hould -ollup Groups be fro&enIt is recommended that -ollup Groups be fro&en unless they are being modified.4owever, if they are not fro&en, there should not be any effects on General Ledgerreports, functions, or other processes.

    ?J Do you need to have an )ccounting 'le1field segment that is flagged with theIntercompany *ualifier#he intercompany segment is an optional Intercompany feature for the Intercompany"egment +alancing. It is 0# re*uired in order to do intercompany balancing. It is8ust another way to do the intercompany balancing, instead of using different naturalaccounts to trac5 intercompany balances, you can use the intercompany segment inthe hart of )ccounts to record the same detail. It is more 8ust a matter of preferenceof how you want to trac5 the intercompany transactions. -efer to 0ote =F==>

  • 7/21/2019 GL Setup List

    42/88

    /ntry -econciliation is a set of forms and reports that enable the user to selectivelycross%reference transactions in the General Ledger. nce the balance of a group oftransactions is &ero, the user can mar5 them as reconciled. #his functionality enablesthe transactions in any account that should balance to &ero 9for e1ample, an Inter%company suspense account to be reconciled.

    >= hat is the recommended numbering for the )ccounting 'le1field structure andwhy#he )ccounting 'le1field structure re*uires consecutive segment numbers beginningwith =, such as =,?,>..... Gaps in numbering li5e =? "ome of the segment separators are displayed as *uestion mar5s 9, whyhec5 the descriptions of the "egment 2alues. If the same segment separator value9ie: dash is used in the segment value description, the actual segment separator onthe chart of accounts will appear at times as a $$ Do not use the segment separator in

    the description and this should resolve the issue.

    '"G:@U/"#I0"%%%%%%%%=. hat is the difference between printing standard reports and printing '"Gs?. hat are the valid print styles for printing '"Gs>. 4ow can I create the Landwide ?FF print styleE. hat should the profile option '"G: )llow Portrait Print "tyle be set toF. 4ow can I verify if the '"Gs are set up for dynamic printing. 4ow can I get rid of the error message $)pplication 'ile "erver cannot open file$ I

    get this error message when trying to view the '"G output.. hat profile options should be set with regards to printing of '"G reports;. 4ow do I fi1 an '"G created with too many rows per page 9; instead of J. 4ow do I correct '"G reports that only print one line followed by a blan5 page

    @U/"#I0" )0D )0"/-"%%%%%%%%%%%%%%%%%%%%%= hat is the difference between printing standard reports and printing '"Gs

    #he standard reports use the "- drivers when they are generated, whereas, the'"Gs do not use the "- drivers at all. #he standard reports have a predefined printstyle and driver assigned to them. hen an '"G is submitted, its( initial style isD!0)3I which calls the GL routine 'DUG"# which in turn will select anappropriate print style.

    ? hat are the valid print styles for printing '"Gs#here are four valid print styles for printing: ;< or O 9portrait, ;=%=>? 9landscape,

    =>>%=;< 9landwide, and =;=%?FF 9landwide ?FF. '"G will automatically pic5 thesmallest one of these that can hold your report, and use that as your print style.

  • 7/21/2019 GL Setup List

    43/88

    Landwide ?FF does not come seeded with racle )pplications. If there is a need touse the ?FF style, you will have to create this new style.

    > 4ow can I create the Landwide ?FF print styleUnder the system administrator responsibility, navigate to the Define Print "tyle

    form 9Install6Printer6"tyle. !ou can create a new style of Landwide ?FF by copyingthe Landwide style as a new record, and changing the column setting to ?FF 9leavingother settings the same. #he same driver that is assigned to the Landwide style canbe assigned to the Landwide ?FF style.

    E hat should the profile option '"G: )llow Portrait Print "tyle be set to#he portrait print style is only available if the '"G: )llow Portrait Print "tyle is set

    to !es. therwise, reports that are ;< characters wide or less will be printed aslandscape, or you might receive an error when attempting to print portrait reports.

    F 4ow can I verify if the '"Gs are set up for dynamic printing

    Under the system administrator responsibility, navigate to the Define oncurrentProgram form 9oncurrent6Program6Define. @uery the short name -G-)-G.3a5e sure that the style is set to Dynamic. )lso, ensure that the row and columnsettings are set to &ero.

    4ow can I get rid of the error message $)pplication 'ile "erver cannot open file$ Iget this error message when trying to view the '"G output.#his error message usually means that the '"G did not bring in any data. !our '"G

    report may be referencing a period that does not e1ist in the calendar. r, there mightnot be any data for the period that you are running the '"G for.

    hat profile options should be set with regards to printing of '"G reports3a5e sure that you have set the following profile options: Printer oncurrent:

    -eport opies

    GL+)L I0#/-3P)0! "!"#/3

    @U/"#I0"

    =. Does or5flow need to be installed?. Does GI" eliminate the standard intercompany 8ournals>. Do the subsidiaries have to be local to the instance which has the GI" systemE. Is GI" similar to /0#-)F. hat is the benefit of entering Intercompany #ransactions through GI". an the (Intercompany "egment @ualifier( be used with GI". Do all the sets of boo5s that use GI" have to be on the same instance of racle;. hich responsibility should I use to enter the transaction in GI" for a given

    subsidiaryJ. an I see the intercompany transactions for all my subsidiaries using one

    responsibility

  • 7/21/2019 GL Setup List

    44/88

    =

  • 7/21/2019 GL Setup List

    45/88

    !es if you assign a set of boo5s that has parent privileges to your responsibility thenyou should be able to view all the transactions between subsidiaries.

    =. Is a separate value set re*uired for the Intercompany +alancing "egmentE. 4ow does the new Intercompany "egment improve intercompany accountingF. an Intercompany "egments be used with clearing companies. 4ow are Intercompany 8ournal lines created in General Ledger ==i. Is it possible to implement Intercompany +alancing "egment in an e1isting "et of

    +oo5s;. In -el ==i with the intercompany segment, is it possible to have a security rule on the

    +alancing segment without it affecting the intercompany segment, since they sharethe same value set

    J. 4ow are lines identified that are created by automatic intercompany balancing 4owdo you determine which rows in the GLH7/HLI0/" table have been created by theautomatic intercompany balancing process

    @U/"#I0" C )0"/-"%%%%%%%%%%%%%%%%%%%= hat is the Intercompany "egment in ==i Is it bac5ported

    )nswer%%%%%%#he Intercompany "egment 'le1field @ualifier can be used with the Intercompany+alancing feature in -elease ==i. #he user can assign a segment to be theintercompany segment. hen a 8ournal entry that affects multiple balancing segmentvalues is posted, the Intercompany +alancing feature will automatically create8ournal lines to ensure each balancing segment value is balanced, and the balancingsegment value of the appropriate trading partner will be automatically entered as theintercompany segment value for each 8ournal line. #he Intercompany +alancingfeature is only available in -elease ==i, and has not been bac5ported to -elease ==.

  • 7/21/2019 GL Setup List

    46/88

    ? 4ow do I define Intercompany )ccounts in -elease ==i

    )nswer%%%%%%

    % 0avigate to the Intercompany )ccounts form 9"etup6)ccounts6Intercompany.% "pecify the "ource and ategory that apply to the intercompany account9s you aredefining.% "elect "ummary or Detail +alance.% omplete the learing ompany Usage and Default ptions tabs.% Define your specific balancing segments and accounts in the Intercompany Detailregion.

    > Is a separate value set re*uired for the Intercompany +alancing "egment)nswer%%%%%%

    #he intercompany segment shares the same value set as the balancing segment and isused in the account combination that racle General Ledger creates to balanceintercompany 8ournals. #hey can use separate values sets, but they must be identical.

    E 4ow does the new Intercompany "egment improve intercompany accounting)nswer%%%%%%- "pecified intercompany accounts means *uic5er reconciliations.- 3aintain granularity for due%to and due%from companies trac5ing, even for

    multicompany transactions.- !ou can now balance intercompany 8ournals based on multiple

    parameters,including:

    - 7ournal "ource 7- 7ournal ategory- +alancing "egment 2alue

    % !our intercompany accounting rules may also include different accounts based onwhether the balancing amount should be posted to a credit account 9due to or debitaccount 9due from. )t the 8ournal source and category level, you can choose adefault clearing company against which all trading partners balance. !ou can alsospecify whether intercompany 8ournal balancing is performed at a summari&ed levelfor each trading partner or at the 8ournal line level.

    F an Intercompany "egments be used with clearing companies)nswer%%%%%%!es. !ou can designate one company to act as the trading partner for all subsidiarycompanies in the organi&ation for certain types of intercompany transactions.

    4ow are Intercompany 8ournal lines created in General Ledger ==i

  • 7/21/2019 GL Setup List

    47/88

    )nswer%%%%%%Using Intercompany functionality there are four options to automatically account forintercompany transactions in a single set of boo5s."tandard Intercompany +alancing: )utomatic Intercompany creates generic

    balancing lines against the intercompany accounts that are defined for specificsources and categories./nhanced Intercompany +alancing: #his allows definition of separate intercompanyaccounts to record more detail for the intercompany 8ournals and trac5 theintercompany balances.Intercompany "egment +alancing: Instead of using different natural accounts to trac5intercompany balances, it is possible to use an intercompany segment in your chart ofaccounts to record the same detail as enhanced intercompany balancing.learing companies: It allows to define one company to act as the trading partner for

    all subsidiary companies in the organi&ation for certain types of intercompanytransactions.

    Is it possible to implement the Intercompany +alancing "egment in an e1isting "et of+oo5s)nswer%%%%%%racle General Ledger does not have a process to change the accounting fle1fieldstructure of an e1isting set of boo5s. It is not supported or recommended to add a newsegment to an accounting fle1field structure that is being used. In this case, it isnecessary to define a new set of boo5s that includes the new Intercompany segment.

    ; In -el ==i with the intercompany segment, is it possible to have a security rule on thebalancing segment without it affecting the intercompany segment, since they sharethe same value set)nswer%%%%%%!es it is possible. /nable security on the value set. /nable security on the balancingsegment in the accounting fle1field structure. !o not enable se)urity on t,einter)ompany segment in t,e a))ounting fle/field stru)ture6

    J 4ow are lines identified that are created by automatic intercompany balancing 4owdo you determine which rows in the GLH7/HLI0/" table have been created by theautomatic intercompany balancing process)nswer%%%%%%#he 0L! way you will be able to distinguish such transactions is from the entry inthe D/"-IP#I0 column. #he description column contains% $Intercompany lineadded by Posting$

    7U-0)L /0#-!, -/2/-"I0G, -/U--I0G@U/"#I0"

  • 7/21/2019 GL Setup List

    48/88

    =. 4ow to delete a 7ournal +atch #he delete icon is greyed out. #he 8ournal batch doesnot have 8ournals associated and it is unposted.

    ?. hy does an accounting period not appear in the accounting periods list of values onthe 8ournal entry form

    >. hy can not a 8ournal batch be deleted or modifiedE. hich report shows details of a posted 8ournal batchF. Is there a report that displays information on one specific 8ournal entry %

    unposted6posted. an a posted 8ournal batch be deleted. Is possible to restrict users from entering negative amounts in 8ournal lines;. 4ow to set up 8ournal approval in General LedgerJ. 4ow do you attach an /1cel spreadsheet to a 8ournal entry in racle General Ledger=. hy is the reversal period of a 8ournal being cleared out after the period is changed=E. ) 8ournal entry with a source set up for automatic reversal is not reversed.=F. Does the reversal program generate separate reversal batches%8ournals for each

    8ournal in a batch that is reversed=. 4ow do you reverse a 8ournal entry that was already reversed, but its( reversed 8ournal

    was deleted=. 4ow do you restrict the ability to reverse unposted 8ournals=;. 4ow do you automatically generate a reversal 8ournal entry for a 8ournal category in

    the previous accounting period=J. 4ow does the application determine the default period when a recurring 8ournal is

    generated?

  • 7/21/2019 GL Setup List

    49/88

    b. hen the 'ind 7ournals window appears, clic5 on the (B( in the upper right corner toclose the window.

    c. lic5 the -eview +atch button on the /nter 7ournals form. #his will bring up the'ind +atches window to *uery the batch.

    d. /nter the batch 0ame and the Period.

    e. lic5 the 'ind button and the batch should be displayed on the +atch window now.f. 0ow it is possible to clic5 on the delete icon to delete the unposted 8ournal batch.

    ? hy does an accounting period not appear in the accounting periods list of values onthe 8ournal entry form)nswer%%%%%%

    #he accounting period list of values displays periods that have a closing status ofpen 9 or 'uture /nterable 9'. 0ew 8ournal entries can be defined in open andfuture enterable accounting periods. 0ew 8ournal entries can be posted only in openaccounting periods.

    > hy can not a 8ournal batch be deleted or modified)nswer%%%%%%

    ) 8ournal batch can not be deleted or modified under the following circumstances:a. #he source is fro&enb. 'unds have been reserved for the batchc. 'unds are in the process of being reserved for the batchd. #he batch is in the process of being postede. #he batch is postedf. #he batch is approvedg. #he batch is in the process of being approved

    ) 8ournal batch should not be updated if it comes from a sub%ledger. hangingaccounting information in a 8ournal that originated in a sub%module willunsynchroni&e the accounting information between the ledger and the sub%ledger.Instead of changing the sub%ledger 8ournal, define a new 8ournal to ad8ust theaccounting information if necessary. ) 8ournal batch that has funds reversed can notbe updated because the funds would not be re%reserved appropriately.

    E hich report shows details of a posted 8ournal batch)nswer%%%%%%

    7ournals % General9=;< har and 7ournals % General9=>? har reports displayinformation relating to a particular 8ournal batch.

    F Is there a report that displays information of one specific 8ournal entry %unposted6posted)nswer%%%%%%

  • 7/21/2019 GL Setup List

    50/88

    0o. General Ledger reports display information of 8ournal batches that are postedor unposted.

    an a posted 8ournal batch be deleted)nswer

    %%%%%%0o, a posted 8ounal batch can not be deleted. -everse it to nullify the accountingeffects of the posted 8ournal batch.

    Is possible to restrict users from entering negative amounts in 8ournal lines)nswer%%%%%%%

    Unfortunately, it is not possible to restrict users from entering negative amounts in8ournal entry lines.

    ; 4ow do you easily copy a 8ournal entry from one set of boo5s to another

    )nswer%%%%%%#here is no standard feature to copy 8ournal entries between sets of boo5s.

    4owever, there are some alternatives. "ee0ote ?

  • 7/21/2019 GL Setup List

    51/88

    General Ledger automatically submits the )uto-everse program when a period isopened if the profile option, GL: Laun), AutoRe+erse After Open Period4 is set to!es. If a 8ournal is created after the period has already been opened, then the)uto-everse program will need to be submitted manually.

    => Does the reversal program generate separate reversal batches%8ournals for each8ournal in a batch that is reversed)nswer%%%%%%

    !es. hen a batch is reversed, General Ledger creates a reversing 8ournal entry foreach 8ournal entry in the batch. 0ote that this also generates a separate reversal batchfor each reversed 8ournal.

    =E 4ow do you reverse a 8ournal entry that was already reversed, but its reversed 8ournalwas deleted

    )nswer%%%%%%General Ledger does not allow you to reverse a 8ournal entry twice.onfirm that

    the first reversed 8ournal entry does not e1ist in the system.ontact racle "upport for the solution to0ote =EF.=.

    =F 4ow do you restrict the ability to reverse unposted 8ournals)nswer%%%%%%

    Unposted 8ournals can be posted, this is the intended functionality.)dditional information can be found in0ote =?

  • 7/21/2019 GL Setup List

    52/88

    =; 4ow do you insert an additional ad8usting 8ournal entry into an unposted recurring

    8ournal batch #he 8ournal was added to the 8ournal on the /nter 7ournals form, but itwas not included in the recurring 8ournal batch as e1pected.)nswer

    %%%%%%#o generate an additional 8ournal in a recurring batch you must update thedefinition of the recurring batch.hen you create a manual 8ournal entry on the /nter7ournals form, the "ource is set to 3anual and a new batch with a "ource of3anual is created. #he "ource for the recurring 8ournal9s is recurring. #his new8ournal will not be combined with the original recurring 8ournal batch since they havedifferent sources. 4owever, you can update the unposted recurring batch withadditional lines and amounts.

    =J Is it possible to generate recurring 8ournals automatically)nswer

    %%%%%% In -elease ==i, the automatic 8ournal scheduling feature enables you toautomatically generate 8ournals for:

    a. -ecurring 7ournalsb. 3ass )llocations63ass +udgetsc. "tep%down allocation setsd. Parallel )llocation sets

    ?

  • 7/21/2019 GL Setup List

    53/88

    J. )re Descriptive 'le1fields allowed to be imported through the 7ournal Importprocess

    =

  • 7/21/2019 GL Setup List

    54/88

    b GLH7/H4/)D/-"c GLH7/HLI0/"d GLHI3P-#H-/'/-/0/"

    an you run 7ournal Import for )d8usting Periods0o. 7ournals can only be imported into an open or future enterable, non%ad8ustingperiod for releases ==.F. and prior.Please see0ote =

  • 7/21/2019 GL Setup List

    55/88

    0o. #hese options are not available for 7ournal Import. #here is a setup optionavailable for the number of lines to process at once that affects 7ournal Import. UsingGeneral Ledger "uper User,navigate to "etup6"ystem6ontrols.

    3)"" )LL)#I0"@U/"#I0"

    ==. Does the 3ass)llocation program chec5 cross validation rules=?. an you copy a 3ass)llocation to a 3ass+udget )llocation=>. )re 3ass )llocation6+udget formulas specific to sets of boo5s=E. an you use the onstant 9 segment type with parent segment values=F. 4ow are 3ass)llocation entries calculated: 'ull vs. Incremental

    @U/"#I0" C )0"/-"%%%%%%%%%%%%%%%%%%%

    = Does the 3ass )llocation program chec5 cross validation rules)nswer%%%%%%#he validation portion of the program does 0# chec5 for violations of account crossvalidation rules. Invalid lines will be created and you will have to correct the resulting8ournals in the /nter 7ournals indow before you post.

    ? an you copy a 3ass )llocation to a 3ass +udget )llocation)nswer%%%%%%0o, it is not possible to ma5e a copy from one to the other.

    > )re 3ass )llocation6+udget formulas specific to sets of boo5s)nswer%%%%%%-,ey are spe)ifi) to t,e a))ounting fle/field stru)tures4 not to sets of boo2s . Ifyou have two sets of boo5s using the same fle1field structure you could run a3ass)llocation defined in one or the other set of boo5s. #he responsibility you are inwould determine which set of boo5s the 8ournal entry would be created for.

    E an you use the onstant 9 segment type with parent segment values)nswer%%%%%%!es, but you can only do so if there is a summary account associated with the parent.#o use summary accounts in the formula, all segments in the formula must beassigned a segment type of onstant 9.

    G/0/-)L L/DG/- % 3-@U/"#I0"

  • 7/21/2019 GL Setup List

    56/88

    =. hat is 3-?. an 3- be used with the 3ultiple rgani&ation feature of racle )pplications>. hat )pplications support 3- featureE. hen do the transactions entered in subledgers get converted to the reporting

    currencyF. hen an I in*uire on these reporting currency transactions in the subledger . an I use the same responsibility for both Primary and -eporting sets of boo5s. Does opening the period in the Primary set of boo5s also open it in the -eporting set

    of boo5s;. an I use a different chart of accounts for my reporting set of boo5sJ. hen budgets are defined in the Primary set of boo5s do they get recorded in

    -eporting set of boo5s=. Do I have to define conversion options for each set of boo5s=E. an I change the effective date once I start using 3-=F. In what ways does the Profile option 3: perating Unit affects 3-=. 4ow do document numbers get assigned to 8ournals=. hen subledger posting is done for the primary set of boo5s does it also occur for the

    reporting set of boo5s=;. hen revaluation is run in the primary set of boo5s does it also revalue the balances

    in the reporting set of boo5s=J. 4ow does 3- handle 8ournal import from non%racle feeder systems?. Do the primary set of boo5s and reporting set of boo5s calendars have to be the same

    in General Ledger 9i.e. have the same first ever period@U/"#I0" C )0"/-"%%%%%%%%%%%%%%%%%%%= hat is 3-

    3- is a feature that allows for transactions to be recorded in more than one set ofboo5s6functional currency by way of assigning reporting set of boo5s to a primary setof boo5s. #he chart of accounts and calendar have to be the same for the primary andreporting set of boo5s .

    ? an 3- be used with the 3ultiple rgani&ation feature of oracle applications!es , the operating unit6organi&ation must be the same for both the primary andreporting sets of boo5s.

    > hat )pplications support the 3- feature

  • 7/21/2019 GL Setup List

    57/88

    )ssets, ash management, ost 3anagement, General Ledger, Payables, Pro8ects,Purchasing, -eceivables.999*n+entory does not support MR&6999

    E hen do the transactions entered in subledgers get converted to the reporting

    currency#he transactions are converted to the reporting currency at the time of original entry

    F hen an I in*uire on these reporting currency transactions in the subledger#hey are available immediately in the sub%ledgers as the transactions are converted atthe time of original entry in the subledger.

    an I use the same responsibility for both Primary and -eporting set of boo5s0o, two responsibilities have to be set up, one for the primary and reporting set ofboo5s respectively.

    Does opening the period in the Primary set of boo5s also open it in the -eporting setof boo5s0o, periods have to be opened in both sets of boo5s individually.

    ; an I use a different chart of accounts for my reporting set of boo5s0o, both primary and reporting sets of boo5s must use the same chart of accounts andcalendar. nly the functional currency can be different .

    J hen budgets are defined in the Primary set of boo5s do they get recorded in-eporting set of boo5s0o, budgets have to be defined separately in the reporting set of boo5s.

    = Do I have to define conversion options for each set of boo5s

  • 7/21/2019 GL Setup List

    58/88

    In release == and ==iconversion options are defined for each combination of racle)pplication and operating unit for which you want to convert transactions to yourreporting set of boo5s.

    =E an I change the effective date once I start using 3-

    0o, it is strongly recommended not to change the effective date.

    =F In what way does the profile option 3 % perating unit affect the 3-If a reporting set of boo5s is assigned to a primary set of boo5s then this profileoption should be set to the same operating unit for both the Primary and -eporting setof boo5s.

    = 4ow do document numbers get assigned to 8ournalshen a 8ournal is entered in the primary set of boo5s the document number assignedis determined by the primary set of boo5s and it will be the same number in thereporting set of boo5s also.

    = hen sub ledger posting is done for the primary set of boo5s does it also occur forthe reporting set of boo5s"ubledger posting process to General ledger must be done multiple times once for theprimary set of boo5s and then repeated for each reporting set of boo5s assigned to theprimary set of boo5s.0ote: #he one step "ubledger posting feature is available by applying the relevantpatch.

    =; hen revaluation is run in the primary set of boo5s does it also revalue the balancesin the reporting set of boo5s0o, revaluation must be run in the primary set of boo5s and in each of the reportingset of boo5s .

    =J 4ow does 3- handle 8ournal import from non%racle feeder systems)fter 8ournal import is done for you primary set of boo5s from non%racle feedersystem and the 8ournals are posted successfully in the primary set of boo5s Generalledger creates converted 8ournals in the reporting set of boo5s .

    ?

  • 7/21/2019 GL Setup List

    59/88

    ?? 4ow does reversing a 8ournal in the primary set of boo5s affect the reporting set ofboo5shen a 8ournal is reversed in the primary set of boo5s General ledger will alsoreverse the corresponding 8ournal in the reporting set of boo5s. #he reporting 8ournaluses the same conversion rate that was used to create the original entry .

    ?> Do the primary set of boo5s and reporting set of boo5s calendars have to be the samein General Ledger 9i.e. have the same first ever period0o. #he first ever calendar period in the primary set of boo5s does not have to be thesame as the associated reporting boo5. #he =st 3- Period is used by our historicaltransactions6balances conversion programs and does not need to be entered if you arenot going to be using them. #he replication of data from the primary boo5 to thereporting boo5 is controlled by the 'rom6#o /ffective dates in the )ssign "et of+oo5s form, onversion ptions window. !ou can further control thesources6categories to convert or not to convert in the GL onversion -ules window.

    P/06L"/ P/-ID%%%%%%%%%%%%%%%%@U/"#I0"=. If we open the first period of the new year, can we still process entries for the prior

    year9s?. I opened the first period of the new year without closing the prior year. ill this cause

    a problem>. #he first period of my new fiscal year was opened and closed. hat are the

    ramifications to the roll forward process and retained earningsE. e opened a period by mista5e and need to set the status bac5 to future enterable

    an we do thisF. e created new periods after the last period defined was opened. 0ow we can not see

    those new periods on the pen6lose form.. an I add a =>th period to my calendar. 4ow do you open a permanently closed period;. Is there a way to automatically open General Ledger periods

    @U/"#I0" C )0"/-"%%%%%%%%%%%%%%%%%%%= If we open the first period of the new year, can we still process entries for the prior

    year9s)nswer%%%%%%!es. !ou can still create entries for any period that has a status of open or 'uture/nterable. !ou can post to any period that has a status of pen. If you post in a priorfiscal year, the balanced will be rolled forward and retained earnings will be updatedas needed.

    ? I opened the first period of the new year without closing the prior year. ill this causea problem

  • 7/21/2019 GL Setup List

    60/88

    )nswer%%%%%%0o. losing a period in General Ledger does nothing more than close that period.#here is no processing that goes on behind the scenes when yo