I tried 2 different ways of uploading PO into Oracle
SOA Suuite 11.1.1.3.0
JDev : 11.1.1.3.0
Oracle EBS 11.5.10.2
1. Calling the Stored procedure which has fnd_request.submit_request
2. Using Oracle Applications Adapter and calling the standard concurrent program
When I do step 1 I was able to create PO in every alternate session. it gives the following error for every other instance. But this error comes only every alternate time.
Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'RF_POImport' failed due to: Stored procedure invocation error. Error while trying to prepare and execute the APPS.RFCUST_PKG_PO_IMPORT.RFCUST_PO_IMPORT_PROC API. An error occurred while preparing and executing the APPS.RFCUST_PKG_PO_IMPORT.RFCUST_PO_IMPORT_PROC API. Cause: java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001: Oracle error -2074: ORA-02074: cannot SET NLS in a distributed transaction has been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','AMERICAN'). has been detected in fnd_global.set_nls. ORA-06512: at "APPS.APP_EXCEPTION", line 72 ORA-06512: at "APPS.FND_GLOBAL", line 245 ORA-06512: at "APPS.FND_GLOBAL", line 1426 ORA-06512: at "APPS.FND_GLOBAL", line 1684 ORA-06512: at "APPS.FND_GLOBAL", line 2309 ORA-06512: at "APPS.FND_GLOBAL", line 2447 ORA-06512: at "APPS.FND_GLOBAL", line 2385 ORA-06512: at "APPS.RFCUST_PKG_PO_IMPORT", line 1096 ORA-06512: at line 1 ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution. </summary>
</part>
<part name="detail">
<detail>ORA-20001: Oracle error -20001: ORA-20001: Oracle error -2074: ORA-02074: cannot SET NLS in a distributed transaction has been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','AMERICAN'). has been detected in fnd_global.set_nls. ORA-06512: at "APPS.APP_EXCEPTION", line 72 ORA-06512: at "APPS.FND_GLOBAL", line 245 ORA-06512: at "APPS.FND_GLOBAL", line 1426 ORA-06512: at "APPS.FND_GLOBAL", line 1684 ORA-06512: at "APPS.FND_GLOBAL", line 2309 ORA-06512: at "APPS.FND_GLOBAL", line 2447 ORA-06512: at "APPS.FND_GLOBAL", line 2385 ORA-06512: at "APPS.RFCUST_PKG_PO_IMPORT", line 1096 ORA-06512: at line 1 </detail>
I tried the Oracle Applications adapter...I'm getting the following error. But If i set the org,user and application in FND_GLOBAL for the first time and call the apps adapter its working fine for some time. I guess some caching issue with DB and apps adapter was not able to set the org,resp and user
Encountered an error while getting the ORACLE user account for your concurrent request. Contact your system administrator
Please Advice.
Thanks In Advance,
Satish