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 AUGUST 21, 2023

Applies to:

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:

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

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