AutoInvoice Interface not loading TAX Lines
AutoInvoice will load tax line only if you have successfully. linked the TAX line to it's Invoice line.
The TAX lines will be ignored if it cannot be linked with Invoice Line's. To link Tax Line with Invoice Line you must use the Line Transaction Flexfield.

The segment values of the line transaction flexfield uniquely identify any given line in the
RA_INTERFACE_LINES table. Use the following example to load TAX lines attached to Invoice Line:-
 
 
Attributes Line Tax Line
INTERFACE_LINE_CONTEXT 'STD. ORDER' 'STD. ORDER'
INTERFACE_LINE_ATTRIBUTE1 '1000000' '1000000'
INTERFACE_LINE_ATTRIBUTE2 '01'  '01' 
INTERFACE_LINE_ATTRIBUTE3 'LINE' 'TAX' 
LINK_TO_LINE_CONTEXT null  'STD. ORDER'
LINK_TO_LINE_ATTRIBUTE1 null  '1000000'
LINK_TO_LINE_ATTRIBUTE2 null '01' 
LINK_TO_LINE_ATTRIBUTE3 null 'LINE'

The INTERFACE_LINE_ATTRIBUTE1 is an order number, INTERFACE_LINE_ATTRIBUTE2
is the Order line # and INTERFACE_LINE_ATTRIBUTE3 is LINE_TYPE invoice lines and tax lines.

The combination of the three INTERFACE_LINE_ATTRIBUTE's makes each row in the
RA_INTERFACE_LINES unique, and the LINK_TO_LINE_ATTRIBUTE's are used to link this TAX line to INVOICE LINE.

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.