Call PLSQL procedure using form personalization
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}||''');