Forum Stats

  • 3,854,962 Users
  • 2,264,441 Discussions
  • 7,905,847 Comments

Discussions

Automatically Trigger report while saving the Receipt in Purchasing

666373
666373 Member Posts: 138
edited Jan 2, 2009 4:56AM in Reports
Hi,

My requirement is to fire my custom report automatically when user saves the receipt in Purchasing. Please suggest me how can i do that?

Thanks,

Regards,
AS

Answers

  • Denis Segard-Oracle
    Denis Segard-Oracle Member Posts: 2,139 Gold Badge
    Hello,

    http://download-uk.oracle.com/docs/cd/B14099_17/bi.1012/b14048/pbr_evnt.htm

    Oracle® Application Server Reports Services Publishing Reports to the Web
    10g Release 2 (10.1.2)
    B14048-02

    17 Using Event-Driven Publishing

    Modern business processes often require the blending of automation into the work environment through behind-the-scenes
    functions and procedures. Behind-the-scenes tasks can include the automatic production of output such as an invoice
    that prints automatically when an order is processed, a Web site that is automatically updated with current data,
    or an automatic e-mail with fresh report output when a transaction is completed.

    Regards
    Denis Segard-Oracle
  • shishu
    shishu Member Posts: 223
    Hi,
    Have you tried through Trigger on table, create one procedure which will run the desire report automatically as soon as row inserted in the table, or you can try through Alert also.

    Shishu Paul
This discussion has been closed.