My Oracle Support Banner

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:

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


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

FRM-41830: List of values contains no entries.


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.





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.