Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to invoke a report by name instead of ID?

104680Jan 10 2008 — edited Feb 10 2020
Hello,

We have developed several shared reports which are invoked from other applications. In Active Studio we select the Report and use "Copy Shortcut" option in left menu to get a web link such this:

http://work/oraclebam/ReportServer/default.aspx?Event=ViewReport&ReportDef=4&Buttons=False

We have two environments: a development and production. We are exporting reports in development and importing in production (using icommand), but ids change everytime, so the parameter above (ReportDef) is not the same as before and we have to re-custom all apps again. The problem is we have several (200+) reports and takes a long time to update all reports, tests and so on.

Any idea if is possible calling a report by name instead of ID?

Thank you too much,

Rogério

Comments

vijayrsehgal-Oracle 
30511, 00000, "invalid DDL operation in system triggers"
// *Cause:  An attempt was made to perform an invalid DDL operation
//          in a system trigger. Most DDL operations currently are not
//          supported in system triggers. The only currently supported DDL
//          operations are table operations and ALTER?COMPILE operations.
// *Action: Remove invalid DDL operations in system triggers.
971895
For that account,it has trigger. that's why it is raising the trigger.
i.e database level trigger ..ask dba to resolve this one.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 20 2013
Added on Jan 10 2008
#integration-b2b, #integration-general, #soa-process-management
8 comments
5,560 views