Tuesday 23 April 2013

Running Concurrent Program from OAF Page


package oracle.apps.ap.oie.policy.upload.server;

import com.sun.java.util.collections.ArrayList;
import oracle.apps.fnd.common.VersionInfo;
import oracle.apps.fnd.cp.request.ConcurrentRequest;
import oracle.apps.fnd.cp.request.RequestSubmissionException;


public class UploadAMImpl extends OAApplicationModuleImpl
{
  public void handleStartUpload()
  {
    OADBTransactionImpl localOADBTransactionImpl = (OADBTransactionImpl)getOADBTransaction();
    Connection localConnection = localOADBTransactionImpl.getJdbcConnection();
    ConcurrentRequest localConcurrentRequest = new ConcurrentRequest(localConnection);
    Vector localVector = getArgList();
    try
    {
      int i = localConcurrentRequest.submitRequest("SQLAP", "APWUPDM", null, null, false, localVector);
      localConnection.commit();
      ((UploadParamsVORowImpl)getUploadParamsVO().first()).setRequestId(new Number(i));
    }
    catch (SQLException localSQLException)
    {
      throw new OAException("SQLAP", "FND_XXX1");
    }
    catch (RequestSubmissionException localRequestSubmissionException)
    {
      throw new OAException("SQLAP", "FND_XXX2");
    }
  }

/*
Vector vparam = new Vector(); //Added
int requestId = cr.submitRequest(applnName, cpName, cpDesc, null, false, vparam);
tx.commit();
return requestId;
}
catch (RequestSubmissionException e)
{
throw new OAException(e.toString(),OAException.ERROR);
}
}*/
 
}

1 comment:

  1. Hi Abhishek,

    Allow me to show my gratitude bloggers. You guys are like unicorns. Never seen but always spreading magic. Your content is yummy. So, satisfied.

    Our development team is trying to install the 'Shared Features' from SQL 2008 R2 via the original MSDN .ISO file. But when they attempt to install any of the following components
    • Integration Services
    • Management Tools - Basic
    • Management Tools - Complete
    • Microsoft Sync Framework
    They receive the following error
    TITLE: SQL Server Setup failure.
    ------------------------------
    SQL Server Setup has encountered the following error:
    Unknown property.
    .
    ------------------------------
    BUTTONS:
    OK
    ------------------------------
    This same error is also seen when we first perform an upgrade of the existing SQL installation then circle back to add those features.
    To manage the database level transactions such as modifications of the data dictionary table that record information about the free space usage.
    I need a little guidance locating some log files that might help me understand why these components are failing. For what it’s worth, during the install process, all the configuration checks pass.

    Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.

    Thanks,
    Kevin

    ReplyDelete