Skip to Main Content

DevOps, CI/CD and Automation

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 is a function of Program Units being called in a Oracle Report?

orchidDec 10 2012 — edited Dec 10 2012
Hello All,

I am troubleshooting an report that is generated by an Oracle report program (i.e. <report_name>.rdf). This report program is called from a push button (PB) in an Oracle form. I trying to find out if the calculations of all grades (e.g. A, B, C, D & F) are functioning properly, and I have found that all the calculation functions are stored in the program units. My question is:

How is each of these functions in the program units of an Oracle report being triggered or called?

For example, in Oracle Forms we have triggers associated w/ an item, block, form level or PB object. Does Oracle Report works in a similar manner?

Any help, suggestions or advices would be greatly appreciated.

Thanks in advance!

Comments

yoonas
Hi,

It can be called in report triggers(before, after, etc), sql, format trigger.

Regards
Yoonas
orchid
Thanks for your prompt response. Yes, some of the functions in the Program Unit can be found in the report Triggers. Further digging, I found the calculation functions of the program unit are attached to specific columns in 'G_Features' of Groups. So, how do the calculation functions get executed when the report runs?

Thanks again.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 7 2013
Added on Dec 10 2012
2 comments
1,567 views