Invoicing Rule And Accounting Rule Are Null In Ar

 

Invoicing Rule And Accounting Rule Are Null In Ar Interface Tables [ID 404458.1]
	Modified 30-MAR-2009     Type PROBLEM     Status MODERATED

In this Document
  
  
  
  

---

This document is being delivered to you via Oracle Support's (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Order Management - Version: 11.5.10.2
This problem can occur on 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
accounting rule with Subs 3 month monthly. However, for the line with
immediate, it geneates 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.

Note 359681.1 is not acceptable, because when creating the new accounting rule, it does not
generate the appropriate GL entry

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

STEPS
The issue can be reproduced at will with the following steps:
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.

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

In procedure Prepare_Interface_Line_Rec, while populating
invoicing and accounting rule id, the condition was IF
p_line_rec.accounting_rule_id = 1 or
p_line_rec.accounting_rule_id is NULL, due to this when
accounting rule was IMMEDIATE (ie.e rule_id is 1), the values
were populated as NULL.

This issue has been fixed in the file OEXPINVB.pls in version <115.221.11510.33>

This is explained in the following bug:
Bug.<5725539>:

Solution

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch. 5615384 which will be released in
Mid of Jan, 2007

2. Ensure that you have taken a backup of your system before applying
the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:
OEXPINVB.pls in version <115.221.11510.33>
You can use the commands like the following:
strings -a $XX_TOP/filename |grep '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.

References

- DATAFIX: INVOICING RULE AND ACCOUNTING RULE WHICH ARE ATTACHED TO EXISTING ITEMS
- INVOICING RULE AND ACCOUNTING RULE ARE NULL IN AR INTERFACE TABLES

---

 

 包:OE_Invoice_Pub

过程:Prepare_Interface_Line_Rec

下图右则选择区域