My Oracle Support Banner

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

Last updated on NOVEMBER 09, 2019

Applies to:

Oracle Fusion Receivables - Version 11.1.5.0.0 and later
Oracle Fusion Receivables Cloud Service - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

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

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.