Sunday 13 September 2015

Submitting and Monitoring Concurrent Programs from Oracle Apps Self-Service Pages

We normally submit and monitor Concurrent Programs from standard request submission form (SRSFrom). There is another way to submit concurrent programs i.e. Submitting and Monitoring through Self-Service Pages. which is very useful in many scenarios. 

Method:
Define Function:
Navigation: System Administrator -> Application -> Function
PropertiesSSWA jsp function

Web HTML Call:

To submit any concurrent program:

OA.jsp?akRegionApplicationId=0&akRegionCode=FNDCPPROGRAMPAGE&scheduleRegion=Hide&notifyRegion=Hide&printRegion=Hide

To Submit Particular Concurrent Program

OA.jsp?akRegionApplicationId=0&akRegionCode=FNDCPPROGRAMPAGE&programApplName=XXCUS&programName=XXSCM_LMS_RPT&programRegion=Hide&scheduleRegion=Hide&notifyRegion=Hide&printRegion=Hide

Where XXSCM_LMS_RPT is Concurrent Program Short Name

To View requests related to specific concurrent program

OA.jsp?akRegionCode=FNDCPREQUESTVIEWPAGE&akRegionApplicationId=0&progApplShortName=XXCUS&progShortName=XXSCM_LMS_RPT

Where XXSCM_LMS_RPT is Concurrent program Name


REF: http://shilpaviswanath.blogspot.ae/2012/03/submitting-and-monitoring-concurrent.html

Wednesday 9 September 2015

Deploy Custom Jar library and OAF pages in EBS R 12.2.3

    1)Move the class files to $JAVA_TOP

    2) Run XML Import script   follow below steps to  Generate Jar file.



    1. Create a temporary custom.zip file which contains all the custom application's directories/files at the non-standard location. The commands are:
      1. cd $JAVA_TOP
      2. zip -r customprod.zip <directory list> where the <directory list> is the list of all the directory paths, relative to $JAVA_TOP, for custom application's java files at the non-standard location.
    2. Generate and sign the customprod.jar file. Command: adjava oracle.apps.ad.jri.adjmx -areas $JAVA_TOP/customprod.zip -outputFile $JAVA_TOP/customprod.jar -jar $CONTEXT_NAME 1 CUST jarsigner
    3. Any update in the java class files   
                   Re-create the jar file:
    1.  Cd  $AD_TOP/bin
      1. Runadcgnjar
                                  Give apps username and password.
    1. Follow the steps below to make the custom jar file available for WebLogic Server:
      1. Back up the existing <FND_TOP>/admin/template/ebsProductManifest_xml.tmp
      2. Modify <FND_TOP>/admin/template/ebsProductManifest_xml.tmp to add the entry below for customprod.jar (after customall.jar):
        <library>customprod.jar</library>
      3. Run AutoConfig.
      4. Bounce the middle-tier services.
      5. NOTE: These changes will be lost if ebsProductManifest_xml.tmp is patched in future; changes will need to be done again.
    2. In order to to synchronize the changes (during the next prepare phase) between both the file systems fs1 and fs2, follow the steps below. Note that the custom synchronization driver file, located at <APPL_TOP_NE>/ad/custom/adop_sync.drv, should be used in these steps. This file has the required documentation on how to put an entry in for a file that needs to be synchronized between the two file systems.
      1. If there are custom java class files under <JAVA_TOP>/oracle/<cust_prod>/* directory and if the files under this directory needs to be synchronized between fs1 and fs2 , then put the following entry in the custom synchronization driver file as below:
        cp -r %s_current_base%/EBSapps/comn/java/classes/oracle/<cust_prod> %s_other_base%/EBSapps/comn/java/classes/oracle
      2. To copy the custom jar file, add the following entry:
        cp %s_current_base%/EBSapps/comn/java/classes/customprod.jar %s_other_base%/EBSapps/comn/java/classes
      3. To synchronize the custom changes done to the template, add the entry below:
        cp %s_current_base%/EBSapps/appl/fnd/12.0.0/admin/template/ebsProductManifest_xml.tmp %s_other_base%/EBSapps/appl/fnd/12.0.0/admin/template
      4. After changes are synchonized, ensure Autoconfig is run for the latest template changes to take effect.

    Note:Refer DOC ID:1577661.1 from meta link for more Info

Saturday 5 September 2015

Delete Multiple rows from Table Region in OAF

1. Add one transient attribute "MultySelectFlag" of type string to your VO
2. create multiple selection based on this attribute
3. In table actions add one button called "Delete"

To handle delete functionality write following code:

    public void deleteLineRow() {
        XxscmPoLinesStgVOImpl vo =
            (XxscmPoLinesStgVOImpl)getXxscmPoLinesStgVO1();
        Row row[] = vo.getAllRowsInRange();
        for (int i = 0; i < row.length; i++) {
            XxscmPoLinesStgVORowImpl rowi = (XxscmPoLinesStgVORowImpl)row[i];
            if (rowi.getMultySelectFlag() != null &&
                rowi.getMultySelectFlag().equals("Y")) {
                rowi.remove();
            }
        }
    }