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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How do u bridge the gaps in functional understanding of AP,GL,FA. explain with some live examples.

2078


What are register in India localisation?

1582


What is the Use of Grouping Rule in Receivables ? is it mandatory field ?

1065


We are running Oracle EBS 11i and yesterday whilst doing my month-end I forgot to select "calculate finance charge" on form ARXSUPST AR Print Statement run. I am struggling to get to My Oracle and was hoping someone out there might have experienced or heard of a similar problem. What are my options to rectify this situation... I look forward to you inputs..... Thank you Regards Salie

2165


Define the activities of the Configuration Manager (AP,GL,FA) in the team. Give examples

2027






I am traying to access oracle functiona/ technical interview questions asked by the consultancy "infosys", but i cant find anything when i go the to the links, i need the oracle erp techno functiona questions pls, Thanks, in advance Tovia

1932


What do you mean by Category Set ? and what is its Relevance ?

1989


What is difference between primary and secondary ledger

622


What is the use of mo: security profile, while configure multiorg?

624


Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.

1791


What is the use of gl set of books name, while configure multiorg?

657


What is the Process of Reconciliation Between AP to GL

1177


Re: While you are in implemenation what are u faced the issues ? tell me what some ap & GL issues?

1968


How to do the analysis of discounts lost and fixing the root cause?

652


What is the procedure for requition import?

1901