R12: AP: Cannot Attach New Account Derivation Rule to Journal Line Type Getting Error: "FRM-41830: List of values contains no entries" (Doc ID 2875814.1)

Last updated on JULY 29, 2022

Applies to:

Symptoms

When attempting to attach the new Derivation Rule to the Payables, Event Class = Invoices, Journal Line Type = Item Expense, the following error occurs.

The issue can be reproduced by following the steps to Create pl/sql function to be used by Custom source.

1. Log in as the Payables Manager Responsibility -> Setup -> Accounting Setup -> Subledger Accounting Setup
2. Go to Accounting Methods Builder -> Sources -> Custom Sources.
3. Create a new Custom Source using an attribute from Invoice Line Level.
4. Go to Transaction Accounting Builder -> Account Derivation Rules. Create a new Account Derivation Rule using the Custom Source of above step.
5. Go to Accounting Methods Builder -> Methods and Definitions -> Application Accounting Definitions. Use Event Class = Invoices.
6. Click on Journal Line Definition button. Select Journal Line Type = Item Expense. Under the Account Derivation Rule tab, select the segment selected in Step4, the ADR created above is not listed in LOV. The FRM-41830: List of values contains no entries" is displayed.

Changes

Cause

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