My Oracle Support Banner

Service Contracts Authoring: 'No entries found for List of Values' When Trying to add Service/Usage Line (Doc ID 188635.1)

Last updated on MARCH 06, 2018

Applies to:

Oracle Service Contracts - Version 11.5.6 to [Release 11.5]
Information in this document applies to any platform.


Attempting to add a Service Line to a Contract. No values appear in the LOV.
The following error message is displayed:


'No entries found for List of Values'.


Steps to Reproduce:

(R) Service Contracts Manager
(N) Launch Contracts
Created a Service Contract:
1. Select Tools from the toolbar.
2. Select New.
3. Select Category = Service Agreement; press Create button.
4. Enter contract header and summary information.
5. Open the Lines tab.
6. Open the Parties subtab.
7. Select Line Type = Service
8. Select the LOV for Name. You receive the message
'No entries found for List of Values'.

Review the trace for the SQL statement in the "Trace File (with Binds)"

The trace reveals that the ORG_ID is -99 when in fact the organization is set.

Setup Organization id = 41


Validation Steps:

1. Get the Item validation org from contract creating:
Review at the contracts header the Item validation org through
help-tools-examine. This solution applies if the INV_ORGANIZATION_ID has the value -99.

2. Reviewed Inventory setups for Service items are setup correctly in Items Master Setup in OM.

Review the Oracle Contracts for Service Concepts & Procedures guide for more details.

3. Make sure the ORACLE_SERVICE_ITEM_FLEXFIELD is setup, see <Note 142483.1>

4. Make sure the following profile options are setup to correct organizations:
MO: Operating Unit
OE: Item validation ORG
QP: Item validation ORG
ASO: Product ORG
OM: Item Validation Org
Log in as System Administrator to review profile option setups by choosing
profile OM: Item Validation Org, this has changed.

5. Check setup as follows:
OM responsibility > Setup > Parameters

6. Make sure the following profiles are also setup:
HR:User Type
HR:Businsess Group




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.