Login  Register

CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12

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

CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12

ARWA MAHJUB
3 posts
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
| More
Print post
Permalink

Re: CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12

ErmanArslansOracleBlog
Administrator
5738 posts
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
| More
Print post
Permalink

Re: CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12

ARWA MAHJUB
3 posts
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
| More
Print post
Permalink

Re: CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12

ErmanArslansOracleBlog
Administrator
5738 posts
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.