My Oracle Support Banner

Create Accounting Issue: How To Derive Different Unearned Revenue Accounts Based On Invoice Lines Item Type ? (Doc ID 753254.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


Sub-Ledger accounting provides a powerful mechanism for you to control how the system will generate accounts for you.

In this note, we take an example of "customizing" the Unearned Revenue accounts used by Create Accounting.

Following is the scenario:
You use Revenue Contingencies, with 'Customer acceptance functionality'. The revenue gets deferred when invoice is generated and an accounting distribution is created against unearned revenue account. You want to define accounting such that the GL Account used for Unearned Revenue is derived based on the invoice line item type.

To do the above, you can use the ProdChars item category set of an item to determine whether an item is, let's take the values: INSTALL, SERVICE, or PRODUCT. Following are the rules you want to implement in deriving the GL account:

  1. If the first two segments of Prod Chars are SERVICE and INSTALL, then this is an INSTALL item,
  2. Else if the first segment of Prod Chars is SERVICE, then this is a SERVICE item,
  3. Else this is a PRODUCT item.


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

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