$NaN Is Displayed On Customers Invoice (Doc ID 1591916.1)

Last updated on OCTOBER 13, 2023

Applies to:

Symptoms

The user is getting $NaN(Not a Number) displayed instead of dollar amount on customer invoices for the accounts on which there are credit and adjustments passed.
Also this issue was not observed in last month, there is no any changes in invoicing process, also this issue was not observed during trial billing.
However, it is happening in actual billing and invoicing.


STEPS
-----------------------
The flow of invoicing process is as follows :
On execution of invoicing utility, Flist gets converted into XML file and this XML file gets converted into HTML file, which is then exported to Power invoice application where the customer can view their invoices.

After executing invoicing utility the data is correctly populated in the Output flist, the issue is there when this flist data gets converted into XML file using BRM policy opcodes.
The user has a stylesheet which is used as a base in order to generate the HTML template.

There is a function used in this stylesheet format-number () which is used to convert number into string, looks like this function is throwing the NaN error when it tries to read the value from XML.

As data is looking correct in output flist, it is suspected that there is issue in the XML file which is getting generated by BRM policy opcodes.

Changes

Cause

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