My Oracle Support Banner

Create Invoice with Invoicing and Accounting Rules Using AR_INVOICE_API_PUB.trx_line_rec_type Does Not Have Column ACCOUNTING_RULE_DURATION (Doc ID 1501693.1)

Last updated on MARCH 31, 2017

Applies to:

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


Attempting to create an invoice with Invoicing and Accounting Rules using API AR_INVOICE_API_PUB and receive the following error:

For rules of type Variable Duration, you must provide the number of periods for this accounting schedule.

The IN parameter type TRX_LINE_TBL_TYPE, which is tied to TRX_LINE_REC_TYPE doesn't have the column ACCOUNTING_RULE_DURATION.

This causes issues in the validation and invoices are not created.


To view full details, sign in with your My Oracle Support account.

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

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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