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...
create a value set that depends on another
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
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
Who is online
Users browsing this forum: No registered users and 1 guest