Can Oracle Provide A Reason Why There Are Leading Spaces Appended In The Standard Package OE_INVOICE_PUB? (Doc ID 730412.1)

Last updated on OCTOBER 20, 2019

Applies to:

Goal

Can Oracle Provide A Reason Why There Are Leading Spaces Appended To The Standard
Package OE_INVOICE_PUB?

See Example Below: 

This problem of leading spaces is coming from standard package OE_INVOICE_PUB.
This package is called in our Order Line workflow(OEOL) to create interface line in RA_INTERFACE_LINES_ALL.

Please see the procedure
Prepare_Interface_Line_Rec where in this leading spaces are added .See the below code
present in Prepare_Interface_Line_Rec

p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE10 := NVL(TO_CHAR(p_line_rec.ship_from_org_id), '0');
p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE11 := '0';
p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE12 :=
LPAD(TO_CHAR(NVL(p_line_rec.Shipment_Number,0)),30);
p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE13 :=
LPAD(TO_CHAR(NVL(p_line_rec.Option_Number,0)),30);
p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE14 :=
LPAD(TO_CHAR(NVL(p_line_rec.Service_Number,0)),30);
p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE15 := NULL;
p_x_interface_line_rec.SET_OF_BOOKS_ID := oe_sys_parameters.value
('SET_OF_BOOKS_ID',
p_line_rec.org_id);
p_x_interface_line_rec.LINE_TYPE := 'LINE';
p_x_interface_line_rec.WAREHOUSE_ID := p_line_rec.ship_from_org_id;

Solution

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