Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 195 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to combine Recognized Revenue and Order Line Quantity when invoice Line exist Adjustment
Hi,
Please refer below screenshot
I using subject area ‘Costing – New COGS and Gross Margin Details Real Time’ to compose an OTBI report, and we found an issue, when invoice transaction Line exist Adjustment for price ,the total quantity might duplicate calculated, the quantity become total 400, but actual the transaction quantity is only 200 , we need to combine the Recognized Revenue and Order Line Quantity when transaction Line exist Adjustment for price, how to achieve this purpose on OTBI report? or if anyone have SQL can provide me to compose an BIP report, I will appreciate it.
Regards ,
Eric
Best Answer
-
Hi
Please review the OTBI help center documentation link
https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/25b/faosm/Costing-New-COGS-and-Gross-Margin-Details-Real-Tim-SA-447.html
Also, Please review the OTBI subject area lineage Mapping details and identify the database tables/columnsTo know the OTBI analysis query generated please review the NQSQuery.log of the report.
KB112797 Fusion Applications: How to Get nqquery Using Manage Session
0
Answers
-
Hi Rajasekhar,
After I remove the column 'Transaction Line Number' , the issue is resolved, thanks for the information that you provided.
Regards
Eric
0 -
Hi Eric
Glad to know issue is resolved.
Please mark the post with status "Accepted the Answer".
Thank you in advance.
0