Change of behavior after patch 5603774: Please supply both an invoicing rule and an accounting rule for this invoice (Doc ID 783385.1)

Last updated on JULY 13, 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.
OEXPINVB.pls



Goal

After installing patch 5603774 there a change in the application behaviour.

If 'accounting rule' is not null but 'invoicing rule' is null then the Receivables AutoInvoice process will fail with the error:

Please supply both an invoicing rule and an accounting rule for this invoice

 

This was not the case before installing the patch.

The file which introduces this change is $ONT_TOP/patch/115/sql/OEXPINVB.pls 

With version 115.221.11510.45 the message appears.

It was fixed in release 11i10 - version 115.221.11510.33.

The Result of the patch above is that now whenever the lines have an accounting rule assigned as Immediate, OM no longer passes a NULL value to  RA_INTERFACE_LINES_ALL.ACCOUNTING_RULE_ID, instead it passes 1 (=Immediate Accounting Rule)

This Accounting rule period type may not match the period type assigned to the set of books.

The issue is that if the Period Type of the Immediate Rule Does NOT match the period type assigned to the Accounting rule, the discrepancy exists and the error message is presented.

Solution

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