Error during Set Of Books Creation

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
abbas9001
Posts: 86
Joined: Mon Jun 04, 2007 12:26 pm
Location: India

Error during Set Of Books Creation

Post by abbas9001 »

I have created Currency, Calender, Structure and added valuset and values.
I only have two segments created
Now while creating set of books at the time entering Retained Earning account one the segments has values in LOV however other one doesnt have it and when clicked on details button I see the following Error:

No entries found for List of Values
--------------------------------------------------------------
APP-FND-01436: List of Values cannot find any values for you to choose

Cause: The List of Values execution failed to find any values.

Cause: The SQL statement specified to fdlfch() failed to return any values.

Action: Check the message stack for any SQL statement failure messages. Check to make sure your SQL statement works in SQL*Plus. (ROUTINE=fdlfch)
--------------------------------------------------------------
No entries found for List of Values

Replies highly appreciated.
karthikeyanp1981
Posts: 463
Joined: Thu Nov 09, 2006 4:50 pm
Location: India
Contact:

Post by karthikeyanp1981 »

Refer Metalink Note: Doc ID:Note:177789.1
immkhan
Posts: 1
Joined: Wed Nov 28, 2007 9:43 am
Location: Pakistan

Post by immkhan »

The value-set which you attach with the segment may be incorrect. Check the value-set and the values in the value-set. Also make sure that you freeze and compiled the flexfield.
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Pl download Financials document and verify steps seems you missed step(s). thanks
anusha_rao
Posts: 54
Joined: Tue Jul 24, 2007 1:00 am
Location: India

Post by anusha_rao »

hi
retained earnings account is mandatory ,check whether you have defined it or not.
check your values for the segments.
rao
senior apps consultant
chennai
india
GreenChain
Posts: 3
Joined: Thu Nov 29, 2007 2:13 am
Location: India
Contact:

Post by GreenChain »

The value set will display values only if the values are active. Please go through the values listed in the value set and if required add some values and test the Set of Books Creation. Also ensure that the value set is independent.
jakkasumankumar
Posts: 8
Joined: Sat Oct 13, 2007 9:36 am
Location: India

Post by jakkasumankumar »

hi,
verify the values whether u have created the Retained Earnings a/c.
if so, verify whether Allow Dynamic Inserts is enabled or not.

suman
Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot], Semrush [Bot] and 33 guests