Invoice API - AR_INVOICE_API_PUB.create_single_invoice - Not Working For Weekly Revenue Recognition - Error 'A Rule Start Date Must be Provided' (Doc ID 1573723.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

You are able to create manual invoices, from the Transactions workbench, that use weekly revenue recognition.
You are also able to create an invoice with weekly rule where period = 'Week'.

However, you create all invoices using AR_INVOICE_API_PUB and you are not able to create invoices that use weekly revenue recognition.

The following error is received:

A Rule Start Date Must be Provided

The API had been ending in error because accounting_rule_duration column was missing.

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