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

how we can stop the transaction for not transfer to the reporting ledger at the time of entering the transaction in pl

2441

---

I have a requirement where during the consolidation into USD (from GBP books) I want use two different exchange rates for two consolidations. Child SOB is same but the Parent SOB's are different. How can this be done in Oracle Financials? Answers will be Appreciable. Thank You.

1955

---

I have created an invoice and made the payment in Accounts payable. Now the payment status is Negotiable and accounting status is processed. I reconciled the transaction in Cash Mgmt, The status changed from negotiable to Reconciled in CM. I checked the payment status for the invoice in payment window(AP), the payment status changed to RECONCILED UNACCOUNTED i.e correct but the accounting status is remain processed which is not the correct. I hope the transaction will be correct if the accounting status would have changed to PERTIAL . Please suggest any solution for the above query.

5294

---

Hi guys, any person available ap,ar material pls send me this mail.id sreenathapps09@gmail.com

1891

---

How do write a discoverer report to identify zero dollar suppliers/invoices where the supplier is on hold?

2691

---

I am created credit memo in at but while trying to complete it showing error message-hz_party_location

1439

---

There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.

5328

---

Anyone provide the oracle fin/scm definetions

2385

---

Give examples & explain the below mentioned activity. "Analyzing the documents provided by the client and thereby identifying the test cases to be tested for the application assigned (FA, AP and GL)"

2253

---

I am currently working in reputed Org as a Oracle apps end user (AR). Learned R12 functional course, but no real time exp as in support or implementation project.Please guide. thank you.

2194

---

Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.

2271

---

Explain Customization process?

1931

---

What is Difference between Auto Copy Journal and recurring journal?

1788

---

Recurring Problem Posting i have Journals for sep 2018 that i approved but they are not available to post even though the period is open in Oracle R12 Issues

1772

---

Please post the setups required to approve the payable invoice in AP.

2235

---