Invoicing Rule And Accounting Rule Are Null In AR Interface Tables (Doc ID 404458.1)

Last updated on AUGUST 02, 2016

Applies to:

Oracle Order Management - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

On 11.5.10.2 in Production:
Creating an order in Order Management, within this order, there are 2 lines with multiple accounting rule.
The first line has Invoicing rule = Bill in Advance and Accounting Rule = Subs 3 month monthly.
The second line has Invoicing Rule = Bill in Advance and Accounting Rule = Immediate.
After an order got booked, picked, shipped, and closed this order, it is ready for Autoinvoice Interface.

Querying up the Autoinvoice lines and notice that the system brings in the rule with Subs 3 month monthly.
However, for the line with immediate, it generates a NULL value with the Accounting Rule and Invoicing Rule field.
When run Autoinvoice, the system generates two invoices.
Requiring that with an order on the same ship date that this be on the SAME invoice.

ERROR
Invoicing rule and accounting rule are null in ar interface tables

STEPS
The issue can be reproduced at will with the following steps:
Create an order in Order Management.
Within this order, there are 2 lines with multiple accounting rule.
The first line has Invoicing rule = Bill in advance and Accounting rule = Subs 3 month monthly.
The second line has Invoicing Rule = Bill in advance and accounting rule = immediate.
After an order got booked, picked, shipped, and closed this order, it is ready for Autoinvoice Interface.

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot generate 1 invoice for same day ship.
Accounting rule and invoicing rule disappears if they are bill in advance and immediate in the AR interface tables

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms