CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12
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....
Re: CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12
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..
Re: CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12
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???
Re: CREATE NEW REPORT FROM QUERY ANOTHER standard REPORT R12
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.