My Oracle Support Banner

R12: PSI: Invoices: Negative Values export with <> Sign instead of - for column 'Project Amount' (Doc ID 2018366.1)

Last updated on FEBRUARY 23, 2019

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On release 12.1.3:

PSI > Invoice Summary screen:
Negative values exported to excel with <> sign instead of - .

-This seems to happens with only column 'Project Amount'.
-Other columns works correctly.

Steps to reproduce the issue:
-----------------------------
1. System Profile Values form:
Profile 'Currency Negative Format' set to <XXX> at Site level.

2. In PSI:
a. Query an existing project (Project = WSI506769)

b. Click "Invoices" button.

c. In the Invoice Summary screen:
For Draft Invoice #6:

Project Amount = <106,945.20>
Invoice Amount = <106,945.20>

d. Do File >> Export to export data to excel spreadsheet.
View the spreadsheet and the amount are shown:
Project Amount = <106,945.20> <=== this is NOT correct
Invoice Amount = -106,945.20 <<== this is correct




Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.