Integration

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!

Concurrent Job Invoke from SOA Fails ORACLE error 6550 in FDPSTP

Rakesh JSJul 23 2012 — edited Jul 23 2012

Hi

I am invoking a custom concurrent progrm from BPEL, but though the request id is generated, the program completes with the following error:-

"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 'MAIN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
.

The SQL statement being executed"

However when i run the program from the R12 forms page it gets executed properly. there are no parameters for this concurrent program. I passing the following pramaters when i invoke this concurrent program from my BPEL invoke opr using FND_REQUEST.SUBMIT_REQUEST:-

application => 'XXHCC'
program => 'run_loader_Service'
sub_request => 0

Please suggest why i am facing this issue only in BPEL and how this could be resolved.

thanks
Rakesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2012

Added on Jul 23 2012

#adapter, #bpel, #concurrent, #error, #r12, #soa, #soa-process-management, #soa-suite-discusssions

3 comments

599 views