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

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: Migration from Oracle 11.5.5 to 12
Goto Forum:
  


Current Time: Thu Dec 08 06:02:40 CST 2016

Total time taken to generate the page: 0.14947 seconds