Setup Receivables on Oracle EBS R12

By -

 Setting up Receivables in Oracle E-Business Suite (EBS) R12.3 involves configuring the Oracle Receivables module to manage customer invoices, receipts, and accounts receivable. Here's a step-by-step guide to set up Receivables in Oracle EBS R12.3:


Step 1: Define Customers


Navigation: Customers > Customers > Standard

Set up customer master records by defining customer details, such as name, address, and contact information.


Step 2: Define Transaction Types


Navigation: Setup > Transactions > Transaction Types

Create transaction types to categorize different types of transactions (e.g., invoices, credit memos, receipts).


Step 3: Define Receipt Classes


Navigation: Receivables > Receipts > Receipt Classes

Set up receipt classes to group receipts by similar characteristics.


Step 4: Define Receipt Sources


Navigation: Receivables > Receipts > Receipt Sources

Create receipt sources to identify the source of the receipt (e.g., cash, check, credit card).


Step 5: Define AutoAccounting Rules


Navigation: Setup > System > AutoAccounting

Define autoAccounting rules to automatically assign accounting codes to transactions.


Step 6: Set Up Transaction Sources


Navigation: Receivables > Setup > Transactions > Sources

Define transaction sources to identify the source of the transaction (e.g., manual, imported).


Step 7: Define Revenue Recognition Rules (Optional)


Navigation: Revenue > Rules

If using revenue recognition, set up revenue recognition rules.


Step 8: Define Remit-To Addresses (Optional)


Navigation: Customers > Addresses > Remit-To Addresses

Create remit-to addresses for customers to specify the address to which payments should be sent.


Step 9: Set Up Transaction Batch Sources (Optional)


Navigation: Setup > Transactions > Batches > Sources

Define transaction batch sources to identify the source of the transaction batches (e.g., manual, imported).


Step 10: Define Credit Management Rules (Optional)


Navigation: Credit > Management > Rules

If using credit management, define credit management rules.


Step 11: Define Invoice Printing (Optional)


Navigation: Setup > Transactions > Documents > Printing

Configure invoice printing options, such as the invoice template and delivery method.


Step 12: Set Up Dunning Letters (Optional)


Navigation: Customers > Dunning Letters > Dunning Letter Setup

If using dunning letters, set up dunning letter templates and assign them to customers.


Step 13: Review Receivables Reports (Optional)


Navigation: Receivables > Reports

Utilize various Receivables reports to monitor invoicing, receipts, and accounts receivable.


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