Unable To Get Custom Fields In Invoice XML File (Doc ID 1472511.1)

Last updated on JUNE 03, 2022

Applies to:

Goal

Scenario:

One has introduced custom fields and the same has to be included in Invoice.

While generating XML file it is giving only custom fields number/ID instead of custom field name.

It is causing error while trying to apply the base sample stylesheet.

However if one is adding the field name manually then it is not giving error. And this custom field names needs to be in XML.

For example :

Add custom fields to the AR_ITEMS of output flist of fm_inv_pol_prep_invoice.c file. There in the log we observed that for custom fields it is giving Id instead of name.

The custom field name: CODE_FLD_EMI_AMOUNT
Id: 10005

In the /invoice object the storage type of buffer is text/pin_flist. There in buffer it is storing the fields with Id values.

Later try to export the invoice in XML format. Try with two formats.

1. In PIN_FLIST_TO_XML we used PIN_XML_BY_SHORT_NAME flag. For this, it generating the tag in the below mentioned format.
e.g.:<>200</>

2. In PIN_FLIST_TO_XML we used PIN_XML_BY_NAME flag. For this, it generating the tag in the below mentioned format.
e.g.: <10005>200</10005>

Solution

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