You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

PO Custom report with Total Currency Converted Ordered Amount

Summary:



Content (required):

I am trying to write the custom query to get the PO total orderd amount , where I am using the" PO_BIP_HELPER.get_ordered_display (PHA.PO_HEADER_ID,'0','TXN','H',PHA.CURRENCY_CODE)" but When I do the Mutliplication with Currency Rate and When I run the data view I am getting an error saying "ORA-01722: invalid number" ,

Can any one help me

Thanks in Advance

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

PO_BIP_HELPER.get_ordered_display(PHA.PO_HEADER_ID,'0','TXN','H',PHA.CURRENCY_CODE)*PHA.RATE AS "PO_TOTAL"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!