Planner Workbench - Create Order Query Using Buyer - LOV Is Empty (Doc ID 2128629.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

VCP 12.1.3.9.1

PROBLEM
-------------
We get an error message (FRM-41830: List of values contains no entries) when trying to create query with Orders type, for buyers. Please check the attached screen shot for the error.

Simple Order query
First field attempted is Buyer - Equals - no LOV values presented..

trace file - pnzlaq031_ora_51391_502205846.zip

PARSING IN CURSOR #140172623975584 len=147 dep=0 uid=98 oct=3 lid=98 tim=1458912294020165 hv=178261145 ad='1741748e8' sqlid='8qjp8ps5a034t'
SELECT DISTINCT h.buyer_name hidden, h.buyer_name display FROM msc_system_items h WHERE h.plan_id = :1 and h.buyer_name is not null order by hidden

There is not any bind passed for plan_id since there is not any plan_id context when building the query

END OF STMT
PARSE #140172623975584:c=999,e=387,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=1458912294020164
BINDS #140172623975584:
Bind#0
 oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
 oacflg=01 fl2=1000000 frm=00 csi=00 siz=24 off=0
 kxsbbbfp=7f7c7ba857b8 bln=22 avl=00 flg=05
EXEC #140172623975584:c=2000,e=2048,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=1422593937,tim=1458912294022270
FETCH #140172623975584:c=0,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1422593937,tim=1458912294022372

STEPS
--------
Open query form for Order Query
Try to add Buyer / Equals /

EXPECTED BEHAVIOR
----------------------------
can create query based on buyer names

BUSINESS IMPACT
----------------------
cannot create this type of query.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms