ERPstuff - Oracle EBS Community

Hi All,

I need to generate two duplicate lines for each distribution line for the same invoice line in RA_INTERFACE_DISTRIBUTIONS_ALL table.

Can somebody suggest how it can be done?
Thanks,
Esp

Hi,

I will elaborate the requirement.

The source is data import. When we import data using Auto Invoice interface, every distribution should automatically create two more duplicate lines with the same amount (one line should be with negative amount to match the total line amount). It?s a Spanish format.

Example:
Distribution line ONE 500?
Distribution line TWO ?500?
Distribution line THREE 500?

Could someone please advice how to do it?

Thanks.