Order Import Not Picking Payment Term ID Value From Order Lines Interface Table OE_LINES_IFACE_ALL (Doc ID 2973960.1)

Last updated on SEPTEMBER 14, 2023

Applies to:

Symptoms

Order line interface table oe_lines_iface_all is populated with value for payment term id. When order import is executed, the program Order Import does not pick payment term value from the lines interface table. On the imported order, the payment term value is blank on order line. The order line payment term defaulting rule was disabled before Order Import was executed. 

STEPS

The issue can be reproduced at will with the following steps:
1. Login to SQL Developer database tool > Via PLSQL script populate OE_LINES_IFACE_ALL and OE_HEADERS_IFACE_ALL table
2. Login to Oracle Applications > Navigate to Order Management responsibility
3. Navigate to menu path > Order, Returns > Order Import > Submit program

Changes

Cause

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