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

Unable to view Purchase order PDF in UI on purchase orders over £9,999,999.00

in Purchasing 4 comments

We have a high value purchase order of more than £10mill in our system but when trying to view the Purchase order PDF from the UI it will not load. I have tested values of a lower value and anything under £9,999,999.00 will load no problem, it appears that when it spans into that extra digit that it fails.

I have attempted to view the document from the data model and I have received a ORA-01722 error.

Upon investigation the XML field that is experiencing the issue is the string value FormattedUnitPrice – this value comes from the following SQL:
PO_BIP_HELPER.format_price(Line.UNIT_PRICE) As FormattedUnitPrice 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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