invoking an API-set session mode of FND_PROGRAM causes error.
472983May 13 2006 — edited May 15 2006hi,
while invoking an api i m getting the following error, can anyone help in resolving this problem?
<bindingFault>
<part name="code" >
<code>6501</code>
</part>
<part name="summary" >
<summary>file:/D:/OraBPELPM_1/integration/orabpel/domains/default/tmp/.bpel_item_locators_1.0.jar/proc_service1.wsdl [ proc_service1_ptt::proc_service1(InputParameters) ] - WSIF JCA Execute of operation 'proc_service1' failed due to: Error while trying to prepare and execute an API. An error occurred while preparing and executing the APPS.FND_PROGRAM.SET_SESSION_MODE API. Cause: java.sql.SQLException: ORA-06501: PL/SQL: program error ORA-06512: at "APPS.FND_PROGRAM", line 94 ORA-06512: at line 1 ; nested exception is: ORABPEL-11811 Error while trying to prepare and execute an API. An error occurred while preparing and executing the APPS.FND_PROGRAM.SET_SESSION_MODE API. Cause: java.sql.SQLException: ORA-06501: PL/SQL: program error ORA-06512: at "APPS.FND_PROGRAM", line 94 ORA-06512: at line 1 Check to ensure that the API is defined in the database and that the parameters match the signature of the API. Contact oracle support if error is not fixable. </summary>
</part>
<part name="detail" >
<detail>ORA-06501: PL/SQL: program error ORA-06512: at "APPS.FND_PROGRAM", line 94 ORA-06512: at line 1 </detail>
</part>
</bindingFault>
thanks,
sneha