Friday 5 July 2013

REPORT REGISTRATION IN ORACLE APPS

REPORT REGISTRATION IN ORACLE APPS:


CUSTOMISE/DEVELOP REPORT BY USING REPORT BUILDER >> THEN MOVE THAT REPORT TO DATABASE USING WINSCP TOOL AS SHOWN BELOW


 LOGIN INTO E-BUSSINESS SUITE


Go to application developer >> Executable


 Give valid executable name followed by fields then save.


 Go to program >>


Give valid name to program and executable name as same as the name of the executable in the before slide then set parameter



 Set parameter name as what u want to display to the end user then token field must be same as what you given in the user parameter of your report then save .



 Same as the above statement


Go to application developer >>validation >> set
 

 Give valid name to value set then and select your list type as you want,select your validation type as your need>> Edit information


 choose your application, table name and value and then click test.


Go to system administrator>>


 Then click request>>



Add program to the request then save


Go to view >>request
 

Click submit a new request >>

 Then select single request >> click ok



Choose your report name and give input parameter >>



Choose input parameter from LOV>> Then click ok


Click no to submit


Click find>>


Refresh data>> view output

Finally output of your report will be generated.

BY
S.PRADEEPKUMAR 

No comments: