Sequence Assignments frm-41830:list of Value contains no entries.

Symptoms

============================================================

GL > Setup > Financials > Sequences > Document > Assign (Form title:sequence Assignments)

Click Sequence Column Show tips:frm-41830:list of Value contains no entries.

Solution

============================================================

SELECT NAME,
DOC_SEQUENCE_ID,
Application_name,
Fnd_application_vl. application_id
From Fnd_document_sequences, FND_APPLICATION_VL
WHERE fnd_document_sequences. application_id = Fnd_application_vl. application_id
and:application_id = fnd_document_sequences. application_id
and ((: Method_code = ' M ') OR TYPE in (' G ', ' A '))
and (To_date (: start_date) between Start_date and NVL (End_date, to_date (: start_date)))
and (To_date (: end_date) is null or end_date is null or to_date (: end_date) <= end_date)
ORDER by NAME;

Sequence Assignments Frm-41830:list of Value contains no entries.