Technology Stack - EBS (MOSC)

MOSC Banner

Call PLSQL procedure using form personalization

edited Aug 20, 2021 11:01AM in Technology Stack - EBS (MOSC) 9 commentsAnswered

Hi Team

My requirement is to call the custom report throgh form personlization after the invoice in paybales got validated. It should trigger my custom report. In form personalization , i am using execute stored procedure logic, where i developed one custom procedure with errbuf , retcode and invoice_id as my parameter  and used fnd_request.submit_request API to call that custom report  . Upto here is ok.

Coming to form personalization , i am getting syntax issue.

This is my logic :

In action tab>execute_procedure

='declare

p_retcode NUMBER;

P_ERRBUF  VARCHAR2(2000);

begin

XX_INVOICE_PRINTING(p_retcode, p_errbuf,'''||${item.INV_SUM_FOLDER.INVOICE_ID.value}||''');

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center