2 Replies Latest reply on Jan 24, 2013 6:59 AM by 971233

    Error occurred while setting up Apps Context.

      I am trying to call a stored procedure using Oracle Apps Adapter . MY JCA settings are as following.

      <endpoint-interaction portType="AppsService_ptt" operation="AppsService">
      <interaction-spec className="oracle.tip.adapter.apps.AppsStoredProcedureInteractionSpec">
      <property name="IRepInternalName" value="PLSQL:AP_VENDOR_SITES_PKG:INSERT_ROW"/>
      <property name="SchemaName" value="APPS"/>
      <property name="PackageName" value="AP_VENDOR_SITES_PKG"/>
      <property name="ProcedureName" value="INSERT_ROW"/>
      <property name="Username" value="sysadmin"/>
      <property name="Responsibility" value="System Administrator"/>

      But when I invoke this in logs it gives following error...
      Exception occured when binding was invoked.
      Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'AppsService' failed due to: Apps Context Error.
      Error occurred while setting up Apps Context.
      Context parameters should be valid.
      Contact oracle support if error is not fixable.
      The invoked JCA adapter raised a resource exception.
      Please examine the above error message carefully to determine a resolution."