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 do I submit a concurrent request (for PL/SQL program) from RDF

586134Dec 2 2009 — edited Dec 11 2009

Hi,

I have a requirement i need to call a PL/SQL program using concurrent request from Oracle RDF, I am using below code.

-> PL/SQL program has two input parameters

Case:- 1

reqid :=
fnd_request.submit_request ('SQLAP','IPCS_ACH_VENDOR_PAYMENT1','','', FALSE,
:P_PAYMENT_BATCH,'N' , '', '' ,
'','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','');

If i ran the above rdf i am getting below errors from concurrent request log

ORACLE error 6550 in FDPSTP
Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GEN_ACH'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Case :- 2

reqid :=
fnd_request.submit_request ('SQLAP','IPCS_ACH_VENDOR_PAYMENT1','','', FALSE,
:P_PAYMENT_BATCH,'N' );

-> Able to compile the report without any errors.

-> Upon running the rdf getting below error messages

REP-0736: There exist uncompiled program unit(s).
REP-1247: Report contains uncompiled PL/SQL.

=> Case:1 very well worked for Host file .

--- Please help me how to submit a concurrent program( PL/SQL with 2 paramerers) in RDF ...

Thanks

Edited by: Apps Beginer on Dec 2, 2009 1:40 PM