CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12

ARWA MAHJUB
I NEED TO CREATE NEW REPORT FOR CASH MANAGEMENT IN ERP R12, I COPY standard REPORT FROM CASH MANAGEMENT (CE) extended "RDF", AND COPY QUERY AND RUN THIS QUERY IN TOAD , THIS QUERY NOT RETURN RESULTS.? HOW I CAN USE QUERY FROM standard REPORT "RDF" TO NEW REPORT. THANK YOU....
Reply | Threaded
Open this post in threaded view
|

Re: CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12

ErmanArslansOracleBlog
Administrator
Check the query.
It may have some conditions (where) in the end.
You may need to run  apps initilize before that..
The solution for your case should be designed according to the where conditions used in your query.
Remember, in EBS we have VPD for the security.
I mean, a user can see some data where another does not..
There are lots of ways to do this, but sometimes you see the where conditions are in place in the end of the queries for supplying this isolation..
Reply | Threaded
Open this post in threaded view
|

Re: CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12

ARWA MAHJUB
THANK YOU ... HOW I CAN USE CEP_STANDARD.init_security IN REPORT BUILDER "RDF" AFTER CREATE PACKAGE CEP_STANDARD IN REPORT BUILDER, HOW I CAN USE IT? FOR VIEW DATA IN APPS???
Reply | Threaded
Open this post in threaded view
|

Re: CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12

ErmanArslansOracleBlog
Administrator
This is a developer question. You can always read the documentation.. This question is related with developing custom reports.
CEP_STANDARD.init_security is, I think, a custom package/procedure.
Please ask it to your developers.