Setup Treasury in Oracle EBS R12

By -

 Setting up Treasury in Oracle E-Business Suite (EBS) R12.3 involves configuring the Oracle Treasury module to manage financial instruments, cash management, risk management, and other treasury-related activities. Here's a step-by-step guide to set up Treasury in Oracle EBS R12.3:


Step 1: Enable Treasury Responsibility


Navigation: System Administrator > Security > Responsibility > Define

Enable the Treasury responsibility for users who need access to the Treasury module.


Step 2: Define Financial Instruments


Navigation: Treasury > Instruments

Set up financial instruments, such as money market instruments, bonds, or derivatives.


Step 3: Set Up Market Data (Optional)


Navigation: Treasury > Market Data

Configure market data parameters, including interest rates, exchange rates, and security prices.


Step 4: Define Counterparties


Navigation: Treasury > Counterparties

Set up counterparties, including banks and other financial institutions.


Step 5: Configure Cash Management


Navigation: Treasury > Cash Management

Set up cash management parameters, including cash positions, forecasts, and liquidity planning.


Step 6: Set Up Deal Capture (Optional)


Navigation: Treasury > Deal Capture

If using deal capture, configure deal capture settings and transaction types.


Step 7: Define Risk Management (Optional)


Navigation: Treasury > Risk Management

If using risk management, configure risk management parameters, instruments, and risk evaluations.


Step 8: Set Up Hedge Management (Optional)


Navigation: Treasury > Hedge Management

If using hedge management, set up hedge management parameters, strategies, and designations.


Step 9: Define Accounting Rules


Navigation: Treasury > Accounting Rules

Configure accounting rules to determine how financial instruments are accounted for.


Step 10: Set Up Exposure Management (Optional)


Navigation: Treasury > Exposure Management

If using exposure management, define exposure types and manage financial exposures.


Step 11: Configure Deal Settlement (Optional)


Navigation: Treasury > Deal Settlement

If using deal settlement, configure deal settlement parameters and payment methods.


Step 12: Define Cash Pools (Optional)


Navigation: Treasury > Cash Pools

Set up cash pools to consolidate cash from multiple accounts.


Step 13: Set Up Treasury Reports (Optional)


Navigation: Treasury > Reports

Utilize various Treasury reports to monitor Treasury activities and positions.


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