ERPstuff - Oracle EBS Community

hello,

I am registering a report in oracle apps. I need to bind a subinventory parameter to the organization parameter in a report. Subinventory parameter list of values will depend only on the choice of the oganization from the list of values of the parameter. Both parameters i have created with validation type: table.
i have created the subinventory flexfield with the following where clause:

WHERE ORGANIZATION_ID=NVL(:$FLEX$.P_ORG_ID,ORGANIZATION_ID)

where "P_ORG_ID" is the token of organization id in the rdf file.

when I assign the value set to the parameter subinventory inthe program parameters window i get the following error message:

APP-FND-00798: Invalid reference P_ORG_ID in value set attached to segment SUBINVENTORY

Please check the WHERE clauses of your table validated value sets.

Can you help me please...

Hi,

For example if you have two value sets
1.organization code
2.subinventoory code

In first valueset (1_vs) u should select orgaanization code from table name in table valueset and pass organization id in the meaning field.

Then for the second valueset(2_vs) ,U should enter as select subinventory code from table name
In where /order by clause of secon valueset u should enter as
organization=:$FLEX$.1_vs.
This will display only the subinventories present in that particular organizatin which u have selected in first parameter.


Regards
Prabhakaran.R
prabhakaranraj@gmail.com

thanks a lot for your help. Can you please tell me what organization in : organization=:$FLEX$.1_vs.
refers to? is the token used from the rdf file or the parameter name I 'm using?

thank you .
i used ID table column for organization and it finally worked