On Using The Manage Autoinvoice Lines The Interface Distribution Segment Values 0's Get Suppressed (Doc ID 1908985.1)

Last updated on AUGUST 02, 2022

Applies to:

Symptoms

On : 11.1.7.0.0 version, Bill Customers-Create and Process Bill

 While updating select the cell of segment , right click -> change the format to character/string . Change the value for distribution line. 

And then click save. This will update correct value in DB , but on refersh it will again show these segment value as number.

On trying to import interface lines with distributions , if the Autoinvoice process fails for the first time and he used the Mange AutoInvoice and
corrects any value on the distributions the segment values for the code combination are getting modified.

The leading '0' are getting removed causing an incorrect value in the segment fields.

STEPS TO REPRODUCE
-------------------
From billing Manager> Manage AutoInvoice Lines
In the excel downloaded make any change to the values on teh interface
distributions.

Click on Save .
Select the option to refresh the data after the save.

Check the segment values for the interface distributions on the excel .

See that the 0's are suppressed.
Ex if the segment 2 value was 000 after the save it becomes 0.
The same value appears on the ra_interface_distributions_all .

Cause

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