Home / Interview Questions / ERP Functional Interview Questions / General Ledger Interview Questions Part 6

General Ledger Interview Questions Part 6

1.How many flex fields structures can you create for GL?

“N” No of flexfield structures can be created in GL



2.What is a value set? What are the format types?

 A group of values and related attributes you assign to an account segment or to a descriptive flexfield segment. Values in each value set have the same maximum length, validation type, alphanumeric option, and so on.

Format types:

  • Char
  • Date
  • Date time
  • Number
  • Standard date
  • Standard date time
  • Time



 3.what do you mean by dynamic inserts?

 An Accounting Flex fields feature that allows you to enter and define new combinations of segment values directly in a flexfield pop–up window in Oracle Payables and Oracle General Ledger. The new Combination must satisfy any cross–validation rules before it is accepted. Your organization can decide if an Accounting Flexfield supports dynamic insertion. If an account does not support dynamic insertion, you can only enter new combinations of segment values using the Define Accounts window.


4.what are the pre-requisites for chart of accounts?

To set up your chart of accounts:

  1. Define value sets
  2. Define your account structure
  3. Define rollup groups to create summary accounts
  4. Define your account segment values.
  5. Define Security Rules to restrict user access to certain account segment values.
  6. Define cross–validation rules to control the account combinations
  7. Define or enable descriptive flex fields.
  8. Define account shorthand aliases to speed entry of account segment values.
  9. Define summary accounts to create and maintain summary balances for quick reporting and online inquiry.
  10. Create account combinations.

If you allow dynamic insertion, you can create new account combinations automatically as you use them during journal entry. If you do not allow dynamic insertion, define new account combinations manually in the GL Accounts window.



5.what is an accounting calendar and a transaction calendar?

 Accounting Calendar: Account calendar contains period types and ranges of periods and it is mandatory.

Transaction Calendar:  It will define the business days & non-business days it is optional, to arrive the average balances it is used.



6.what are the types of recurring journals?

 Recurring journals are 3 types

  • Skeleton journals
  • Standard journals
  • Formula journals



7.Explain journal source and category?

 Journal Source: Origin of Journal, whether manual, recurring, allocation, budget, consolidation.

Journal Category: Shows the type of journal, Actual, budget, adjustment, expenses



8.What is encumbrance? Different types of encumbrance.

 Encumbrance is the reserve for future out comings out of the budget amount.

 Commitment – General Ledger has the following predefined encumbrance types: An encumbrance you record when you complete a purchase requisition.

 Obligation  – An encumbrance you record when you turn a requisition into a purchase order.


9.Difference between budget journals and budget amount.

 To enter the budget amounts we use budget journal. The amounts, which are there in the budget, are called as budget amounts.


10.What do you mean by list type? What are the different list types?

 A list of values that appear while we enter the data in flex fields.

Three types of list types

  • Pop list                                <10
  • List of values                     10-200
  • Long list of values              >200



11.Maximum number of segments in chart of accounts.




12.Maximum number of periods in period type. 




13.Maximum number of reporting set of books 



14.Total number of key flex fields in oracle application 




15.The amount computed by dividing an aggregate balance by the number of calendar days in the related range is.

Average balance



16.What budget is used only for Reporting purpose where we don’t enforce any budgetary control.

Planning budget



17.An entity responsible for entering and maintaining budget data is.

Budget organization



18.Allocation methods of mass budget.

Full and Incremental




About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

Apps Technical Interview Questions Part 5

[et_pb_section bb_built=”1″ _builder_version=”3.0.52″ background_image=”https://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg” parallax=”on” parallax_method=”off” inner_shadow=”on”][et_pb_row _builder_version=”3.0.52″ parallax=”on” parallax_method=”off” background_position_1=”top_left” background_repeat_1=”no-repeat” make_fullwidth=”on” use_custom_width=”on” custom_width_percent=”100%” …

Leave a Reply