Setup of GL (General Ledger) on Oracle EBS R12

By -

 Setting up General Ledger in Oracle E-Business Suite (EBS) R12.3 involves several configuration and master data setup steps. Here's a step-by-step guide to set up General Ledger in Oracle EBS R12.3:


Step 1: Define Chart of Accounts


Navigation: General Ledger > Setup > Financials > Flexfields > Key > Values

Define the chart of accounts, which represents the organization's structure for recording financial transactions.


Step 2: Define Accounting Calendar


Navigation: General Ledger > Setup > Financials > Calendars > Accounting

Define the accounting calendar to specify the fiscal periods and accounting periods for financial reporting.


Step 3: Define Currencies


Navigation: General Ledger > Setup > Financials > Currencies

Define the currencies used for financial transactions and reporting.


Step 4: Define Conversion Rates (if applicable)


Navigation: General Ledger > Setup > Currencies > Rates

Set up conversion rates for different currencies to perform currency conversions.


Step 5: Define Ledger


Navigation: General Ledger > Setup > Financials > Ledgers

Define the primary ledger or secondary ledger(s) for parallel accounting, if required.


Step 6: Define Ledger Sets


Navigation: General Ledger > Setup > Financials > Ledger Sets

Create ledger sets to group multiple ledgers for reporting and inquiry purposes.


Step 7: Define Accounting Options


Navigation: General Ledger > Setup > Financials > Accounting Options

Define accounting options like journal entry reversal, intercompany, and consolidation settings.


Step 8: Define Subledger Accounting Options (if applicable)


Navigation: General Ledger > Setup > Financials > Accounting Options > Subledger Accounting Options

Set up subledger accounting options to control accounting entries generated from subledgers.


Step 9: Set Up Journal Sources


Navigation: General Ledger > Setup > Journals > Sources

Define journal sources for different sources of journal entries (e.g., manual, subledger).


Step 10: Set Up Journal Categories


Navigation: General Ledger > Setup > Journals > Categories

Define journal categories to group journal entries based on the business purpose.


Step 11: Set Up Journal Descriptions


Navigation: General Ledger > Setup > Journals > Descriptions

Create journal descriptions to specify the purpose and details of journal entries.


Step 12: Define Journal Entry Descriptions


Navigation: General Ledger > Setup > Journal Entry > Descriptions

Define journal entry descriptions to capture additional information about journal entries.


Step 13: Set Up AutoReverse for Repeating Journals (if applicable)


Navigation: General Ledger > Setup > Journals > Reversal Criteria

Set up auto-reverse criteria for repeating journals that need to be automatically reversed.


Step 14: Define Journal Approval Limits (if applicable)


Navigation: General Ledger > Setup > Journals > Approval Limits

Define journal approval limits for different users or roles.


Step 15: Review and Set Up Security Rules (if applicable)


Navigation: General Ledger > Security > Security Rules

Set up security rules to restrict access to specific ledger data based on user roles.


Step 16: Review General Ledger Reports


Navigation: General Ledger > Reports

Use various General Ledger reports to review financial transactions and balances.


Comments

Post a Comment

Popular posts from this blog

Oracle DBA Queries

By -
 Useful Queries for Checking Concurrent Requests and Programs  Hi DBAs, As an Apps DBA we have to monitor the Concurrent jobs status and details frequently,This can be done with the help of the below queries. -- Concurrent Program Queries for Apps DBA: -- Query 1:For checking the locks in concurrent jobs  SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,inst_id,id1, id2, lmode, request, type FROM gV$LOCK  WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM gV$LOCK WHERE request>0) ORDER BY id1,request; -- Query 2:For checking the concurrent programs running currently with Details of Processed time-- and Start Date  SELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME,round(((sysdate-a.actual_start_date)*24*60*60/60),2) AS Process_time,  a.request_id,a.parent_request_id,a.request_date,a.actual_start_date,a.actual_completion_date,(a.actual_completion_date-a.request_date)*24*60*60 AS end_to_end,  (a.actual_start_date-a.request_date)*24*60*60 AS lag...
Read more

Setup of BOM (Bill of Material) on Oracle EBS R12

By -
Setting up Bill of Material (BOM) in Oracle E-Business Suite (EBS) R12.3 involves several configuration and master data setup steps. Here's a step-by-step guide to set up BOM in Oracle EBS R12.3: Step 1: Define BOM Parameters Navigation: Bills of Material > Setup > Parameters Define BOM parameters, such as the default BOM type, effective date, and organization. Step 2: Define BOM Item Attributes Navigation: Bills of Material > Setup > Attributes Define BOM item attributes, such as item categories and planning attributes. Step 3: Define BOM Structures Navigation: Bills of Material > Setup > BOM Structures Define BOM structures to represent different types of BOMs (e.g., Engineering, Production). Step 4: Create Bill of Material (BOM) Navigation: Bills of Material > Engineer > Bills > Bills Create the BOM by entering the header data (e.g., assembly item, BOM type) and adding the components along with their quantities and item attributes. Step 5: Define Compo...
Read more

Interview Questions and Answers on O2C (Order to cash) in Oracle EBS R12

By -
  Order-to-Cash (O2C) Basics: What is the Order-to-Cash (O2C) cycle, and what is its significance in Oracle EBS? Answer: The O2C cycle represents the end-to-end process of receiving customer orders, processing them, delivering goods or services, and receiving payments. It is a critical business process in Oracle EBS for revenue generation. What are the key components of the O2C cycle in Oracle EBS? Answer: The key components include Order Management, Pricing, Shipping, Invoicing, Receivables, and Cash Management. Order Management: Explain the role of Order Management in the O2C cycle, and how does it handle order creation, modification, and processing? Answer: Order Management is responsible for creating, modifying, and processing customer orders. It ensures that orders are accurate, fulfillable, and meet customer requirements. What are the various order types in Oracle Order Management, and how are they used within the O2C cycle? Answer: Order types include standard orders, sa...
Read more