Receivables overview:

Accounts receivable is an asset account in the general ledger that documents money owed to a business by customers who have purchases goods or services on credit.
Accounts receivable can be contrasted with accounts payable, a liability account in the GL that documents money the business owes for the purchase of goods or services.
Accounts receivable, accounts payable and payroll are usually listed as the top three mission-critical business processes in a disaster recovery plan .

Receivables Workbenches:

Oracle Receivables provides four integrated workbenches that you can use to perform most of your day–to–day Accounts Receivable operations. You can use the Receipts Workbench to perform
most of
your receipt–related tasks and the Transactions Workbench to process your invoices, debit memos, credit memos, on–account credits, chargebacks, and adjustments. The Collections Workbench
lets you review customer accounts and perform collection activities such as recording customer calls and printing dunning letters. The Bills Receivable Workbench lets you create, update, remit,
and manage your bills receivable.

Each workbench lets you find critical information in a flexible way, see the results in your defined format, and selectively take appropriate action. For example, in the Transactions Workbench, you
can query transactions based on the bill–to or ship–to customer, currency, transaction number, or General Ledger date. You can then review financial, application, and installment information,
perform adjustments, create a credit memo, or complete the transaction. All of the windows you need are accessible from just one window, so you can
query a transaction once, then perform several operations without having to find it again.

Receivables Setups in R12:

Overview of Setting Up:

During setup, you define business fundamentals such as the activities you process and their accounting distributions, your accounting structure, and various control features. Setup is also the time
to define
comprehensive defaults that Receivables uses to make data entry more efficient and accurate. In addition, setup lets you customize Receivables to employ the policies and procedures that you
use in your business.
You can set up Receivables a number of different ways. The following graphic shows the most complete setup scenario. If you use the Oracle Applications Multiple Organization Support feature to
use multiple sets of books for one Receivables installation, please refer to the Multiple Organizations in Oracle Applications manual before proceeding. If you plan to use Oracle Cash Management
with Oracle Receivables, additional setup steps are required.

Note: If you plan to use Multiple Reporting Currencies (MRC) with Receivables, additional setup steps are required. For more information, refer to the Multiple Reporting Currencies in Oracle
Applications manual.

Related Product Setup Steps:

The following steps may need to be performed to implement Oracle Receivables. These steps are discussed in detail in the Setting Up sections of other Oracle product user guides.

Set Up Underlying Oracle Applications Technology

The Implementation Wizard guides you through the entire Oracle Applications setup, including system administration. However, if you do not use the Wizard, you need to complete several other
setup steps, including:

• performing system–wide setup tasks such as configuring concurrent managers and printers
• managing data security, which includes setting up responsibilities to allow access to a specific set of business data and complete a specific set of transactions, and assigning individual users to
one or more of these responsibilities.
• setting up Oracle Workflow

General Ledger Setup Steps:

The following table lists steps and a reference to their location within the Applications Implementation Wizard (AIW).

 Define Chart of Accounts

 Define Currencies

 Define Calendars

 Define Calendar Period Types

 Define Ledger

 Assign Ledger to a Responsibility

Define Chart of Accounts:

Define Segments:

Navigation: General Ledger --> Setups --> Flexfields --> Key --> Segments.

Query With Accounting Flexfield and click on New.

Give your coa name and save.

Click on Segments.

Enter your segments names.

and save your work.

Assign Flexfield Qualifiers to Company and Accounting segments.

Select Company segment and then Click on Flexfield Qualifiers.

Select Balancing segment qualifiers and save.

Select Accounting segment and then click on flexfield qualifiers.

Select Natural Account Segment and save.

Define Value sets:

Click on Value set.

Enter the value set Name and Size.

Save your work.

Like wise define value set for all reaming segments.

Assign Value sets to respective segments.

Save your Work.

Select Allow Dynamic inserts and Freeze Flexfield Defination and then click on Compile.

Wait untill the following program are successfully completed.

Define Values:

Navigation: General Ledger --> Setups --> Flexfields --> Key -->Values.

Enter the below information and click on find button.

Enter the company values names and save your work.

Like wish define values for all reaming segments.

Define Currencies:

Navigation: General Ledger --> Setup --> Currencies --> Define.

Enter information and save.

Define Calendar Period Types:

Navigation: Setup --> Financials --> Calendars --> Types.

Enter the information and save.

Define Calendar:

Navigation: Setup --> Financials --> Calendars --> Accounting.

Save.

Define Ledger :

See My Blog how to define Ledger in R12.

Assign Ledger to a Responsibility:

Navigation: System Administrator --> Profile --> Systems.

 Click on find.

Assign Ledger to GL Responsibility.

Save.

Oracle Inventory Setup Steps:

 Define Operating Unit.

 Define Inventory Organizations

 Define Items

Define Operating Unit:

See my blog how to define Operating unit in R12.

Define Inventory Organization:

Navigation: Inventory --> Setup --> Organizations --> Organizations.

Click on New.
Enter information in the required fields.

Save your work and click on othres.

click on Accounting information.

Enter the required information and save.

Click on Others and select the inventory information.

Under Inventory Parameters tab enter the following information.
Under Costing Information tab enter the following information.
Under Revision and Lot Serial And LPN enter the required information.
Under the other accounts tab enter the required information.
Save your work.

Define Items:
Navigation: Inventory --> Items --> Master items.
Enter the name and description.

Go to Tolls and click on copy from.

 Enter Finished good and then click on Apply and done button.

Receivable Setups:

 Define System Options

 Define Transaction Flexfield Structure

 Define Sales Tax Location Flexfield Structure

 Define AutoCash Rule Sets

 Define Receivables Lookups

 Define Invoice Line Ordering Rules

 Define Grouping Rules

 Define Application Rule Sets

 Define Payment Terms

 Define AutoAccounting
 Open or Close Accounting Periods

 Define Transaction Types

 Define Transaction Sources

 Define Collectors

 Define Approval Limits

 Define Remittance Banks

 Define Receivables Activities

 Define Receipt Classes

 Define Receipt Sources

 Define Payment Methods

 Define Statement Cycles

 Define System Profile Options

 Define Salespersons

 Define Customer Profile Classes

 Define Customers

 Define Remit–To Addresses

Define System Options:
Define your accounting, discount, tax, and invoice system options to control how Receivables works. System options determine your accounting method, set of books, accounting flexfields,
whether you use header or line–level rounding, and control the default operation of the AutoInvoice and Automatic Receipt programs.
System options also control how Receivables calculates tax on your transactions. You must specify a tax method, choose a Location Flexfield Structure, indicate whether to compound tax, select
the address validation to use, and define tax defaults and rounding options. As you can set up your system to calculate Sales Tax, Value Added Tax, or Canadian Tax, we recommend that you
carefully review the appropriate implementing tax essay before defining your system options.
Navigation: Receivables --> Setups --> System --> System Options.

Enter the required information in respective fields.

Define Transaction Flexfield Structure:

Transaction flexfields are descriptive flexfields that AutoInvoice uses to identify transactions and transaction lines. Receivables lets you determine how you want to build your transaction flexfield
structure and what information you want to capture.

There are four types of transaction flexfields:

• Line Transaction Flexfield

• Reference Transaction Flexfield
• Link–To Transaction Flexfield
• Invoice Transaction Flexfield
You must define the Line Transaction Flexfield if you use AutoInvoice. You can use the Line Transaction Flexfield to reference and link to other lines because the Line Transaction Flexfield is
unique for each
transaction line. AutoInvoice always uses the Line Transaction Flexfield structure for both the Link–to and Reference information when importing invoices. You must explicitly define the Link–to,
Reference,
and Invoice Transaction Flexfield structures only if this information is to be displayed on a custom window.
Receivables gives you the option of displaying Invoice Transaction Flexfield information in the reference column of invoice lists of values.
Use the System Profile Option AR: Transaction Flexfield QuickPick Attribute to select the Invoice Transaction Flexfield segment that you want to display. For example, if you want to be able to
reference the
order number for imported invoices when using an invoice list of values, you must assign the transaction flexfield segment that holds the order number to the AR: Transaction Flexfield QuickPick
Attribute
profile option. The order number will now display in the reference column of invoice lists of values.
Line Transaction Flexfield:
Use columns INTERFACE_LINE_ATTRIBUTE1–15 and INTERFACE_LINE_CONTEXT to define the Line Transaction Flexfield. Line Transaction Flexfields are unique for each record in the
interface table and therefore can be used as record identifiers.
Reference Transaction Flexfield:
Reference Transaction Flexfields have the same structure as the Line Transaction Flexfields.
Transactions 4 – 235 Reference Transaction Flexfields are used to apply a credit memo to an invoice or associate an invoice to a specific commitment.
For example, to refer a credit memo to a specific invoice, use the REFERENCE_LINE_ATTRIBUTE1–15 and REFERENCE_LINE_CONTEXT columns of the credit memo to enter the Line
Transaction Flexfield of the invoice. To refer an invoice to a specific commitment, use the REFERENCE_LINE_ATTRIBUTE1–15 and REFERENCE_LINE_CONTEXT columns of the invoice to
enter the Line Transaction Flexfield of the commitment.
Link–To Transaction Flexfield:
Link–To Transaction Flexfields also have the same structure as the Line Transaction Flexfield. Use Link–To Transaction Flexfields to link transaction lines together in the interface table. For
example, you might want to import tax and freight charges that are associated with specific transaction lines. If you want to associate a specific tax line with a specific transaction line, use the
LINK_TO_LINE_ATTRIBUTE1–15 and LINK_TO_LINE_CONTEXT columns of the tax line to enter the Line Transaction Flexfield of the invoice.
Invoice Transaction Flexfields:
Create a new flexfield with a similar structure as the Line Transaction Flexfield, but only include header level segments. For example, if the Line Transaction Flexfield structure has four segments
and the last two segments contain line level information, define your Invoice Transaction Flexfield using the first two segments only. Segments included in the Invoice Transaction Flexfield should
be included in the AutoInvoice grouping rules.

Define Sales Tax Location Flexfield:

Receivables uses the customer shipping address to determine the sales tax rate on transactions for all customers in the country that you define in the Systems Option window as your home
country. Proceed to the next step if you are not charging your customers tax based on their shipping address.
Following are the seeded Sales Tax Location Flexfield structures:
• Country
• State and City
• Province and City
• City
• Province
• State, County and City
Use the Key Flexfield Segments window to select the seeded Sales Tax Location Flexfield structure, or to set up a new structure, that you want Receivables to use to determine your sales tax
rates and to validate
your customer addresses.
You can confirm that the required segments are enabled by navigating to the Segments Summary window. Navigate back to the Key Flexfield Segments window to freeze your flexfield structure by
checking the
Freeze Flexfield Definition check box and then compiling the flexfield.
Note: When you define tax system options in the System Options window, use the list of values in the Location Flexfield Structure field to select the same Sales Tax Location Flexfield structure
that you selected in the Key Flexfield Segments window.

Navigation: Receivables --> Setup --> Financials --> Flexfield --> Key --> Segments.

Query with Sales Tax Location Flexfield

Enter the required information in respective filelds.

Save your work.
Like wise we can define other sales tax location flexfields,
Define AutoCash Rule Sets:

If you are using AutoCash, define your AutoCash rule sets before defining system parameters or customer profiles classes. AutoCash rules determine the sequence of application methods
Receivables uses when applying receipts imported using AutoLockbox to open debit items.

Navigation: Receivables --> Setup --> Receipts --> Autocash rule sets.

Define Receivables Lookups:

Receivables provides several default lookups which are used throughout the application to provide validated default values and list of values choices. You can add or update these to customize
your list of values and speed data entry. For example, you can define additional reasons for creating credit memos or enter the names of each freight carrier used by your business .

Navigation: Receivables --> Setup --> System --> Quickcodes --> Receivables.

Define lookups as you like.

Define Invoice Line Ordering Rules:

If you are using AutoInvoice, define invoice line ordering rules to specify how you want to order and number transaction lines after AutoInvoice groups them into invoices, debit memos, and credit
memos. Receivables provides many attributes that you can use to define your line ordering rules.
Navigation: Receivables --> Setup --> Transactions --> Autoinvoice --> Line Ordering rule.

Define Grouping Rules:

If you are using AutoInvoice, define grouping rules to indicate how you want to group transaction lines imported by AutoInvoice. For example, to include specific transaction lines on a single
transaction, certain attributes must be identical. Receivables provides many attributes that you can use to define your grouping rules.

Navigation: Receivables --> Setup --> Transactions --> Autoinvoice --> Grouping Rule.

Define Application Rule Sets:

Define Application Rule Sets to control how Receivables reduces the balance due for your open debit items when you apply payments using either the Applications window or Post QuickCash.
You can define your own application rule sets, assign them to transaction types, and specify a default rule set in the System Options window.

Navigation: Receivables --> Setup --> Receipts --> Application Rule sets.

Define Payment Terms:

Define payment terms to determine the payment schedule and discount information for customer invoices, debit memos, and deposits. You can also define proxima payment terms to pay regular
expenses such as telephone bills and credit card bills that occur on the same day each month and create split payment terms for invoice installments that have different due dates.

Navigation: Receivables --> Setup --> Transactions --> Payment terms.

Define AutoAccounting:

Define AutoAccounting to specify the general ledger accounts for transactions that you enter manually or import using AutoInvoice. AutoAccounting uses this information to create the default
revenue, receivable, freight, tax, unearned revenue, unbilled receivable, finance charges, bills receivable accounts, and AutoInvoice clearing (suspense) accounts.

Navigation: Receivable --> Setup --> Transactions --> Auto Accounting.

Like wise we should also define reaming auto accounting types.

Open or Close Accounting Periods:

Navigation: Receivables --> Control --> Accounting --> Open/Close Periods.

Define Transaction Types:

Define the transaction types that you assign to invoices, debit memos, commitments, chargebacks, credit memos, on–account credits, and bills receivable. Receivables uses transaction types to
default payment term,
account, tax, freight, creation sign, posting, and receivables information. Receivables provides two predefined transaction types: Invoice and Credit Memo.

Navigation: Receivables --> Setup --> Transaction --> Transaction Types.

Define Transaction Sources:

Define the transaction sources that you assign to invoices, debit memos, commitments, credit memos, on–account credits, and bills receivable. Receivables uses transaction sources to control
your transaction and transaction batch numbering, provide default transaction types for transactions in batch, and to select validation options for imported transactions. Receivables provides the
following predefined transaction sources: MANUAL–OTHER, DM Reversal, and Chargeback.
Navigation: Receivables --> Setup --> Transaction --> Sources.
Define Collectors:

Define collectors to assign to your customers through credit profile class assignments. Collectors can use the Collections windows and Receivables collection reports to keep apprised of a
customer’s past due items. Receivables provides a predefined collector called DEFAULT.

Navigation: Receivables --> Setup --> Collections --> Collectors.

Define Approval Limits:

Define approval limits to determine whether a Receivables user can approve adjustments or credit memo requests. You define approval limits by document type, dollar amount, reason code, and
currency.
Approval limits affect the Adjustments, Submit AutoAdjustments, and Approve Adjustments windows as well as the Credit Memo Request Workflow.

Navigation: Receivables --> Setup --> Transactions --> Approval Limits.

Define Remittance Banks:

Proceed to the next step if you already defined your remittance banks in Oracle Payables. Define all of the banks and bank accounts you use to remit your payments. You can define as many
banks and bank accounts as you need and define multiple currency bank accounts to accept payments in more than one currency.

Define Receivables Activities

Define Receivables Activities to provide default accounting information when you create adjustments, discounts, finance charges, miscellaneous cash transactions, and bills receivable.
Receivables also uses Receivables Activities to account for tax if you calculate tax on these activities.

Navigation: Receivables --> Setup --> Receipts --> Receivable Activities.

Like wise we should define reaming receivable actives also.

Define Receipt Classes:

Define receipt classes to specify whether receipts are created manually or automatically. For manual receipts, you can specify whether to automatically remit it to the bank and/or clear your
accounts. For automatic receipts, you can specify a remittance and clearance method, and whether receipts using this class require confirmation.

Navigation: Receivables --> Setup --> Receipts --> Receipts Class.

Click on Bank accounts.

Enter information in respective fields.

Save your work.

Define Payment Method:

Define the payment methods to account for your receipt entries and applications and to determine a customer’s remittance bank information. When defining payment methods, you must enter a
receipt class, remittance bank information, and the accounts associated with your payment receivables type. You can also specify accounts for confirmation, remittance, factoring, bank charges,
and short–term debt.

Navigation: Receivables --> Setup --> Receipts --> Receipts Class.

Define Statement Cycles:

Define statement cycles to control when you create customer statements. You assign statement cycles to customers in the Customer Profile Classes window.

Navigation: Receivables --> Setup --> Print --> Statement Cycle.

Define profile options:

Define profile options to provide default values for some Receivables operations, specify how Receivables processes data, and control which actions users can perform.

Navigation: Administrator --> Profile --> Systems.

During your implementation, you set a value for each Receivables user profile option to specify how Receivables controls access to and processes data. Receivables lets you govern the behavior
of many of
the windows that use profile options.

Profile options can be set at the following levels:

• Site: This is the lowest profile level. Site level profile option values affect the way all applications run at a given site.
• Application: These profile option values affect the way a given application runs.
• Responsibility: These profile option values affect the way applications run for all users of a given responsibility.
• User: These profile option values affect the way applications run for a specific application user. The values you enter for options at the User level supersede the values that your system
administrator has entered for you for these options.

Each of these user profile options affect the behavior of Receivables in different contexts. In Receivables, operations that profile options can affect include receipt application, the entry of
adjustments, the creation
and remittance of automatic receipts and taxes, and posting to your general ledger.
You may also have additional user profile options on your system that are specific to applications other than Receivables.

To change profile options at the Site, Application, or Responsibility level, choose the System Administrator responsibility, then navigate to the Personal Profile Values window. Query the Profile
Name field to
display the profile options with their current settings, make your changes, then save your work. You can change profile options at the user level in the Personal Profile Values window. To do this,
navigate to the Personal Profile Values window, query the profile option to change, enter a new User Value, then save your work. Generally, your system administrator sets and updates profile
values at each level.

Attention: For any changes that you make to profile options to take effect, you must either exit, and then reenter Receivables, or switch responsibilities.
Define Salespersons:

Define salespersons to allocate sales credits to invoices, debit memos, and commitments. If you do not want to assign sales credits for a transaction, you can enter No Sales Credit. If
AutoAccounting depends on salesperson, Receivables uses the general ledger accounts that you enter for each salesperson along with your AutoAccounting rules to determine the default
revenue, freight, and receivable accounts for transactions.

Define Customer Profile Classes:

Define customer profile classes to categorize customers based on credit, payment terms, statement cycle, automatic receipt, finance charge, dunning, and invoicing information. When you initially
set up your customers, you assign each customer to a profile class. To customize the profile class for a specific customer, use the Customer Profile Classes window.

Navigation: Receivables --> Customers --> Profile Classes.

In Profile Class window enter the following information.

In Profile class Amount tab enter the following information.

Save your work.

Define Customers:

Define customers and customer site uses to enter transactions and receipts in Receivables. When you enter a new customer, you must enter the customer’s name, profile class and number (if
automatic customer numbering is set to No). You can optionally enter customer addresses, contacts, site uses and telephone numbers. You must enter all the components of your chosen Sales
Tax Location Flexfield when entering customer addresses in your home country.

Navigation: Receivables --> Customers --> Standard.

Define Remit–To Addresses:

Define remit–to addresses to inform your customers where to send payments. Associate each remit–to address with one or more state, country, and postal code combinations.
For example, if you want your customers in California and Nevada to send their payments to a specific address, enter the remit–to address and associate the states CA and NV with this address.
Remit–to addresses are assigned based on the bill–to address on the transaction.

Navigation: Setup --> Print --> Remit-to-addresses.

Click on Create Remit to addresses.

Enter the required information

Click on Apply.

Enter the country name in the same page and then click on the GO.

Click on the Receipts form Create button.

Enter the following information and click on Apply button.

Project Accounting (Indirect Project)

Setups:

Set Organization Classifications

Set Organization Hierarchy
Set Implementation Options
Set Profile Options

Before this check the Department in COA and copy the same in the notepad and create
the organizations
Set Organization Classifications
Nav: Work structures---Organization---Description

Click on New
Paste the same in the Name and give the Address and give organization classification

Give the Project type class information as

Click on Yes
Give the Organization Classifications

Create one more for Advertising

Create One more Organization Classification for Construction Department
Create One more for HRMS Department
Create one more for Finance Department
Now Create the Organization Hierarchy
Nav: Workstructures---Organization---Hierarchy

Give the Name and Save

Give the Number and Date and Save

First select Query Business Group and select LE under it and click on Down Arrow
Select OU and save and click on Down Arrow

Select Organisations under OU and select Administration and click on Down Arrow
Select the Inventory under Administration

Now click on Up Arrow we can see how many Organizations are under this BG.

Now Switch to PC Responsibility and select the Implementation Options

Nav: Setup---System---Implementation Options
Give the required fields and click on Currency tab

Currency tab exchange rate as Corporate

Project Setup tab fill the fields

Staffing tab select advertising rule and give the hours

Expnd/Costing tab select the fields

Billing tab select Invoice Batch Source as Projects Invoices and save
Note: Implementation Options we will give at OU Level

Now we have to give Profile Options

Switch to System Administrator

Nav: Profile---System
Select Yes and save

Assign the profile option PA: Cross Project User View

Select yes and save

Now For PB Responsibility also assign the same profile options

Select yes and save

Select yes and save

Now assign one more profile option PA: Licensed to use project costing
Select Yes and save

For Billing also we can assign the same profile option

Select yes and save

Now we can Access the PC and PB Responsibilities

Switch to PC
Now we have to define Categories and types
Nav: Setup---Expenditure---Expenditure Categories

Give Expenditure Categories and save

Now Give the Revenue Categories

Nav: Setup---Expenditures---Revenue Categories
Create the Revenue Categories and save

Create Expenditure Types

Nav: Setup---Expenditures---Expenditures Types
Give for Labour Straight time and Overtime

For Material
For Crain Usage we have to take Usage

For Travel
Define Job
Nav: Work Structures---Job---Description
Give the Job

Define Position
Click on New

Give the Number and Position name

Give the Fields and Save

Now we have to assign the position to Employee

Nav: People---Enter and Maintain
If Already defined click on Find

Click on Assingment
Give the Position and click on Update

Click on Yes and Save

Now Assign the Employee to user

Already we have assigned

Now Define Rate Schedules for Employee and Job
Switch to PC
Nav: Setup---Expenditures---Rate Schedules

Give Organization, Schedule, Emp name and Rate and save

Give Organization, Schedule, Job Group, Job Name, Rate and Date and Save

Define Cost Multipliers

Nav: Setup---Costing---Labor---Cost Multipliers
Give the Name, Multiplier and Date and Save

Define Labor Costing Rules

Nav: Setup---Costing---Labor---Labor Costing Rules
Give the Costing Rule and click on Trans Defaults

Save it
Define Organization Labor Costing Rules
Nav: Setup---Costing---Labor---Organization Labor Costing Rules

Give the OU, Organization, Costing Rule and Job rate Schedule and Save

Now Define Resource Lists

Nav: Setup---Budget---Resource Lists
Give for Equipment and save

Give for Finance

Give Labor and Save

Give Material and Save

Define Service Type
Nav: Setup---Projects---Service Types

Give the Service Type as Internal and Save it

Define Work Type
Nav: Setup---Utilization---Work Type

Name it and Save it

Define Project Type
Nav: Setup---Projects---Project Type

Give the name, class, Service type and Work Type

Budget Option tab

Project Status tab

Save it

Now Create the template

Nav: Setup---Projects---Project Templates
Click on New

Give the Header details and save

Select Structures and click on Detail
Enable Financial Structure and click on Apply and close

Now Select Tasks and click on Detail

A window will be opened click on Find

Give the Task Name and number and date click on Create Peer Task to create same top
task
Click on Create Subtask to create a subtask for that

Save it
Now Select Currency and click on Detail

No Changes to be done so save and close

Select Key Members and click on Detail

Select the Employee Name and Role and save

Enable the Fields which are useful and disable the rest

Save and Change the Status to Approved and click on Setup Quick Entry
Give the Project Start date and Finish Date and save

Give the Trans duration date and save and close

Now Create Project
Nav: Projects

Find the Template and click on Find

Click on Copy to

Give the Project Name, Number, Dates and click on Ok.

Project will be created and status will be Unapproved so click on Open

Click on Change Status and Approve the Project and save and close
Now Your Template and Project is ready we can book the Expenditure

Before Booking the Expenditure we have to open the PA periods

Nav: Setup---System---PA Periods

Note: If we open PA Periods automatically GL Periods also will be opened as we have

enabled the option in Implementation options.
Click on Find

Set the Status as Open and Save

Click on Set Reporting Period and click on Ok
Now Check in GL Periods

Open the Period in GL Periods also

If we enable this option then it will be automatically open the period in GL also

Now we can Book the Expenditure

Nav: Expenditures---Pre Approved Batches---Enter
Give the Batch and Class and click on Expenditure, status will be working

Give the Employee Name, Organization as Advertising as we have took it in the Template
and give project number and task number and take the expenditure type as straight line
and give the quantity. And save.
Now Click on Submit

Now click on Release

Status will be Released

Now to generate debit line and credit line we have to do Autoaccounting

Copy the Expenditure Types to Account Segment and same copy to Notepad and
Departments also copy to Notepad
Copy with the Values as it is

Add the Expenditure Types from Notepad to Account Segment and Save
Now Define Rules

Create Rules for Company

Nav: Setup---Autoaccounting---Rules

Give the Company Value and Source must be constant and save it
Create Lookup Set for Department
Nav: Setup---Autoaccounting---Lookup Sets

Copy from the Notepad and save

Now Create Rules for the Department

Give the Rule Name and Source as Parameter and Value as Organisation and source as
lookup and assign the department lookup here and save
Now Create the Dr. Lookup set for Account Segment

Give the Accounts from the Notepad

Now Create Dr. Account Rule

Give the Rule Name, Source as Parameter and Value as Expenditure Type and source as
Lookup and assign the lookup here and save
Now Create the Rule For Location

Now Assign this to Assign Rules

Give the Name as Cost account and click on Find and Enable All Labor and Assign the
Rules which we created and save

Now Create the Clearing Account

Add the Liability Account in Account Segment
Add it in Lookup sets and Save

Now Create Rule for this Cr. Rule for Account

Give the Rule Name, Source as constant and give the Value for that and save

Now Assign that Cr. Rule to Assign Rules

Give the Name as Cost Clearing and click on Find and enable All Labor and assign the
Cr. Account Rule and Save

Now We have to Run the Program PRC: DISTRIBUTE LABOUR COST to calculate the
cost and generate the debit line
Give the Parameters as Expenditure Batch, Project Number and Employee name and
click on Ok.
Click on Submit and No

Status must be Normal click on View Output

We can find the Report as below

Check in Expenditure Inquiry Window

Nav: Expenditures---Expenditure Inquiry---Project
Give the Project Number and name and Click on Find

We can find the calculated amount

And for which organization it has calculated and click on item Details

Select Cost Distribution Lines and click on Ok

We can see the debit Line Generated and the amount

To generate the Credit line we have to run another program as PRC: GENERATE COST
ACCOUNTING EVENTS and there are no parameters for this, click on Submit and No.

Click on View Output

We can see the amount generated

Now Switch to Expenditure Inquiry window and we can see the credit line
Give the Project Number and Name and click on Find

Click on Item Details and click on Ok

Status will be Accepted and Credit line has to be generated

Go to System Options and enable Interface Labor Costs

Enable Interface Labor Costs

Run the Program PRC: CREATE ACCOUNTING to transfer to GL and parameters are
Click on Submit and No

Now Run the Program Validate Application Accounting Definition

Calculation of Overtime

We have to set Cost Multiplier

Nav: Setup---Costing---Labor---Cost Multiplier
Give the Cost Calculation as 2 as it is Overtime and save

Assign it to labor Costing Rule

Query your Labor Costing Rule and assign the OT

Save it
Now Book the Expenditure for Overtime

Give the Batch Name and click on Expenditures

Give the Employee name and Organization and task number and project number and
expenditure type as 40 as Straight Time and 4 as overtime quantity and save

Click on Submit
Click on Release

Now to calculate Cost, run the program Prc: Distribute Labor Costs

Give the parameters

Click on Submit and No

Click on View Output

See the output

Check it in Expenditure Inquiry Window

Give the Project Name, Number and click on Find
We can see the cost generated, click on Item details

We can See the Debit line generated

Now Run Another Program Prc: Generate Cost Accounting Events

We can See the Calculated amount

Now Check In Expenditure Inquiry window

Give the Project name, Number and Click on Find

Click on Item Details

We Can see Credit line has been generated

Run One More Program Prc: Update Project Summary Amounts for a Single Project

Click on Submit and No

Click on View Output

It will show the Balances

Click on PSI Window we can see the balances

Give the Project Number and Name and click on Find

It will show the same balances

Now Run Prc: Create Accounting

Parameters are
Click on Submit and No

Calculation of Usages
Crate one Dr. Usage a/c
Now create one usage clearing a/c in COA

Add this in Lookup sets

Create the Cr. Usage clearing rule

Now Assign the Dr. Usage to Usage cost

Now Assign the Cr. Rule Usage Clearing

Now Set the Rate Schedules for Non- Labor

Nav: Setup---Expenditures---Rate Schedules
Select the Expenditure Type and give the rate

Now Define Non-Labor Resources

Give Name and click on Cost Rates

Give the Rate and save

Create one more for 200 MT

Give the Rate and save

Create one more for 300 MT

Give the Rate and save

Now Switch to Implementation Options and enable the option for usages
Now book the Expenditure

For Usages we have to take class as Usages

Give the project number, expenditure type and quantity and save

Click on Submit
Click on Release
Run the program Prc: Distribute usage and Misc. costs
Give the Expenditure batch and Project number
Click on View Output

We can see the output

Check in Expenditure Inquiry

Give the Project Name and Number and click on Find

We can see the amount
Now Run one more program to generate credit line
Prc: Generate Cost Accounting Events
Click on View Accounting

We can see the output

Switch to Expenditure Inquiry window we can see the generated credit line
To check the amounts at summary level we have run the program
Prc: Update Project Summary Amounts for a Single Project
Parameters are
Click on View Output

We can see the Balances at summary level

Run One More program to transfer to GL
Prc: Create Accounting
Parameters are
 Oracle OM Setup Document in R12.2

Definition:

 Oracle Order management is one of the most important part of the oracle EBS. The Order Management Application provides many flexible features enabling
you to set up your system to begin processing different types of sales order.

 In this document we are going to see the basic setups of Order management in Oracle EBS R12.

 Few of the information that is required while setting up Oracle Order Management is shared through other modules like System Administrator for enabling
profile options, Oracle Pricing Manager for Price List setup.

 Firstly let’s add the Order Management Super User Responsibility to the User

Invoking: System Administrator→Security→Responsibility→Define

 Now let’s add the responsibility to the user
Invoking : System Administrator→Security→User→Define
 Run replicate seed data as below
Invoking: System Administrator→View→Request→Submit New Request
 Now if switch the responsibility to order management and try to invoke Sales Order or Sales Agreement it won’t allow us to process, it will prompt an error as below.

Order Management→Orders, Returns→Sales Orders

 In order to enable these functionalities we have to follow mandatory setups as below.
Prerequisites:

 Profile Options

 System Options

 System Parameters

 Shipping Parameters

 Transaction Types

 Document Sequence / Assignment

 Price List

 Customers
STEP 1: PROFILE OPTIONS

 For any module profile options is a mandatory setup which has to be followed.
Invoking: System Adminitrator→Profile→System
In Profile field enter these features:

 %GL%Led%NA%

 %HR%User%, %HR%Sec%, %HR%Bus%

 %MO%Oper%Unit%, %MO%Defaul %, %MO%Sec%

 So that the final output will appear as below.

STEP 2: SYSTEM PARAMETERS

 We have to enable our Inventory in Item validation Organization

Invoking: Order Management→Setup→Shipping Parameters→Define

 Query for Item validation Organization and provide the inventory organization you prefer to connect and save the form.
STEP 3: SHIPPING PARAMETER
Invoking: Order Management→Setup→Shipping→Shipping Parameters

 Provide the details as below for corresponding tabs in Shipping Parameters

 Here in below dialog box, the sub inventory is BANGLORE so that it will be the default staging for the goods.
Auto create Deliveries

 What happens if selected?

Pick release automatically creates deliveries based on the delivery grouping rules and assigns delivery lines to them. When pick releasing, the Auto create Deliveries check box in the pick release form defaults to
this parameter setting if you enter a warehouse. If you do not enter a warehouse, pick release uses this parameter setting from the organization of the warehouse on each sales order line.

 What happens if Cleared?

Pick release does not automatically create deliveries.

Auto Allocate check boxes

 What happens if Selected?

Pick release creates move orders and automatically allocates them.

 What happens if Cleared?

Pick release creates move orders. You must manually allocate the order lines using the Inventory Transact Move Orders window.
 Save and close the form above.

STEP 4: SYSTEM OPTIONS

 Here we are going to connect general Ledger and Operating Unit.

Invoking: Order Management→Setup→Customers→System Options

 If we have single operating unit it will show as default as below, if multiple please select any one of your choice.

 In case the Operating Unit doesn’t show up, indicates that there is the problem with your multiorg.

 Check completely the multiorg setups to solve it.

 Provide the general ledger name in NAME field and account details in the account fields respectively.
STEP 5: TRANSACTION TYPES

 Lets create a new Transaction type which are used to associate workflows for various phases of sales order processing.
Invoking: Order Management→Setup→Transation Types→Define

 Below dialog box appears.

 Enter either Order or Return for the Order Category depending on whether your new line type is for sales lines or return lines.

 The value Mixed is selected for order type which can contain both sales order and return lines.

 Let’s create a Transaction Line as order for understanding.

And Transaction Type as below.
 Order Category: Order

 Sales Document Type: Sales Order

 Transaction Type Code: ORDER

 Fullfillment Flow: Order Flow – generic

 Effective Date: Today

 Default Transaction Phase : Fullfillment

 In shipping tab mention the below details as well.

 Click on assign line Flows

 Line Type: Attach the Line created.

 Process Names: Line Flow – Generic as below.

 Click on Validate Workflows, a concurrent program runs on the background and save the dialog box.

STEP 6: DOCUMENT SEQUENCE & ASSAIGING

 Let’s create a sequence for a document which will be followed for the sales order.
Invoking: Order Management→Setup→Documents→Define
Assigning:
Invoking: Order Management→Setup→Documents→Assign

 Mention the transaction type and sequence name we created.

STEP 7: PRICE LIST

 In oracle R12 in order to create a price list we have to add new responsibility called Oracle Pricing Manger, hence create a new responsibility from system administrator- security define and assign
to the user as below.
 Now switch the responsibility to Oracle Pricing Manager→Price List→Price List Setup

 Make sure the below Profile Options before creating the Price List

Profile Options:
QP: Pricing Transaction Entity = Order Fulfillment
QP: Source System Code = Oracle Pricing

 Here the product attribute feature updates the priority depending upon the Item Category, Item Number, All Items etc., depending on which the price will be taken.
Save and close the dialog box.

STEP 8: Creating CUSTOMERS

 Lets create a customer for our sales order

Order Management→Customers→Standard

 The below dialog box opens.

 Click on the create button below.

 Name any organization of your choice.

 And account type as Internal.

 Provide a valid address as below.

 Save the box and add the same address or any other for your Ship to address as well.
 Click on apply which completes customer creation.

 Now we are all set to go, open the sales order

Invoking: Order Management→Orders, Returns →Sales Order

 The below screen will appear, from which you can book, release and ship confirm sales order.

 The Oracle Order Management Application provides many flexible features enabling you to set up your system to begin processing order information.

 This completes the setup procedure for Order Management