Technology Stack - EBS (MOSC)

MOSC Banner

Call PLSQL procedure using form personalization

edited Aug 20, 2021 11:01AM in Technology Stack - EBS (MOSC) 10 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