How to combine Recognized Revenue and Order Line Quantity when invoice Line exist Adjustment

Hsu Chih Yuan

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

Rajasekhar Bandaru-Oracle

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/columns

https://community.oracle.com/customerconnect/discussion/479636/r13-scm-and-procurement-otbi-subject-areas-to-database-lineage-mapping-spreadsheet

To know the OTBI analysis query generated please review the NQSQuery.log of the report.

KB112797 Fusion Applications: How to Get nqquery Using Manage Session

Hsu Chih Yuan

https://community.oracle.com/products/oracleanalytics/discussion/comment/68273#Comment_68273

Hi Rajasekhar,

After I remove the column 'Transaction Line Number' , the issue is resolved, thanks for the information that you provided.

Regards

Eric

Rajasekhar Bandaru-Oracle

Hi Eric

Glad to know issue is resolved.

Please mark the post with status "Accepted the Answer".

Thank you in advance.