Home » Applications » Oracle Fusion Apps & E-Business Suite » report parameter
report parameter [message #314656] Thu, 17 April 2008 07:10
Messages: 110
Registered: March 2007
Senior Member

I have created an independent value set "TESTING" that contains a list of values, which i have added, for the descriptive flexfield "Transaction history" in the "miscelleneous issue" form in the invetory module.
I have attached the value set "TESTING" to the column "Attribute 1" in the table "mtl_material_transactions".
I have also created a report that select "Attribute 1" Column from "mtl_material_transactions".

Now, I need to create a parmeter that allows the user to enter one of the values of the value set "TESTING" and if the parameter left blank it will result in all the records of the original query.
Kindly note that in all the historical rows "Attribute 1" column is NULL.

What do I have to add in the query, report builder, and applications?

Please help...
Previous Topic: Reporting in Functional Currency
Next Topic: Cycle Count - ABC Initialization - group options
Goto Forum:

Current Time: Wed Aug 23 10:34:38 CDT 2017

Total time taken to generate the page: 0.10735 seconds