What is profitability? How do you map 'segment wise
profitability' in Oracle?



What is profitability? How do you map 'segment wise profitability' in Oracle?..

Answer / soumendu

The Accounting standards in various countries expects the
organization earning revenue from multiple product segments
to show the segment wise profitability information as a
part of the Financial Reporting.

Here is how you can set up the same in R11i.

1. Set up an item category as 'Product Segment'.
2. In the GL Set of books, create a chart of account
segment as 'Product Segment'. Give validation as table, and
link it to the product segment field in the item category
table.
3. Set up the cost of goods sold account in such a way that
for each item, the corresponding 'Product Segment' value is
debited during a shipment.
4. In the item attributes for invoicing, change
the 'Product Segment' value in the 'Revenue Account' field
to the corresponding value for each item.
5. In AR, set up the auto accounting to pick the 'Product
Segment' Value from the 'Standard Lines' for Revenue
Account.
6. Create an FSG report to capture Total Revenue, Total
Cost and the Profitability for each Product Segment.


In R12 there is a feature called 'Supporting Reference'
which can provide you with the same information. This means
that you need not create a chart of account segment
called 'Product Segment' in your ledger. However you will
need to create a custom report to provide you with the
profitability since segment wise revenue information is
available in AR and segment wise cost information is
available in 'Cost Management' for Discrete inventory
and 'OPM Financials' for OPM

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Apps Financial Interview Questions

Can Adjustments be imported?

0 Answers  


What is Auto Accounting in Receivables?

2 Answers   KPIT,


Tell me steps for Period closing Process in AP?

1 Answers  


encumbrence set ups?

0 Answers   ABC, Hexaware,


Define Requition?

3 Answers  






Hi all, I have setup my AP and created 3 invoice batches which as seen validated yet when i try to make payment i get the following error"APP-SQL - 10006: the date you entered is not an open accounting period." I have opened the calendar for that month yet it giving me this error. Any help will be appreciated.

4 Answers   IBM,


What is Reporting of financial data in a project.

0 Answers  


How do we depreciate Assets in Oracle Applications?

2 Answers  


How tp determaine that multi org is already implemented ?

1 Answers   IBM,


we have purchased a loptop from the supplier, we have made the payment to supplier through check and the supplier has taken the money from the org. bank and even the transaction has been reconciled with cash management. But due some reason we have returned the loptop to the supplier. Now How this real time scenario will be resolved in the Payable module.

4 Answers  


Is it possible to match PO from Order Management in AP, if so how ? How does the P.O matching process works in AP?

1 Answers   Cipla, GSK, Oracle,


can u make payment across two legal entity ? ex:- one primary ledger, two legal entity and one legal entity have "A" operating unit and another legal entity have "B" Operating unit .. i posted invoice in "A" OU, can i make payment through "B" OU ? if Yes what is mandatory setups ?

2 Answers   Cap Gemini,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)