Launching Oracle E-Business Suite Forms from OA Framework Pages

To launch an Oracle E-Business Suite form from OA Framework, you must first define a button, link or image web bean.

Declarative Implementation

Step 1: In the OA Extension Structure pane, select the region in which you want to create the web bean to launch an Oracle E-Business Suite form.
Choose New > Item from the context menu.

Step 2: Set the ID property for the item, in accordance with the OA Framework File Standards, and set the Item Style property to button, image, or link.

Step 3: Set the Destination URI property of the item with a value following this format .

Syntax:
form:responsibilityApplicationShortName:responsibilityKey:securityGroupKey:functionName

Step 4: If you wish to pass parameters to the form, set the Destination URI property with a value using the following format (Note that the parameter list is delimited by a space between each "parameter=value" pair):

Syntax with parameter:

form:responsibilityApplicationShortName:responsibilityKey:securityGroupKey:functionName:param1={@value1}

for Example:
Here I am Launching Invoice Workbench FORM. It's Query Invoice Workbench data on the basis of passed Parameter.

Item: MessageStyleText
ID:InvoiceId

Destination URI ="form:SQLAP:PAYABLES_MANAGER:STANDARD:AP_APXINWKB:INVOICE_ID={@InvoiceId}"

How to Find OAF Page Function

1)Go to Page and click on about this page

2) copy page path  /xxx/oracle/apps/per/selfservice/appraisals/objectives/webui/ObjSettingPG

3)Click on pageContext Tab

4)click on Expand all

 then search /xxx/oracle/apps/per/selfservice/appraisals/objectives/webui/ObjSettingPG

5)Then you get function name under function column and page path under html call column

Change Background Color in OAF

import oracle.cabo.style.CSSStyle;

                 CSSStyle customCss = new CSSStyle();

                 customUnCss.setProperty("background-color", "    #ee0000");//# -red

                 OAMessageStyledTextBean styledTextBean =(OAMessageStyledTextBean)webBean.findIndexedChildRecursive("POCommentsItem");

                 if(styledTextBean!=null)

                 {

                  styledTextBean.setInlineStyle(customUnCss);

                 }

Break SubTabs in Two line

Break SubTabs in Two line

Line 1 --> 2 SubTabs

Line 2 --> 2 SubTabs

1. Create LabeFiedLayout under PageLayoutRN

2. Create Two SubLayout Under LabeFiedLayoutRN.
   Property.

    1.First SubtabLayout set InitialSubTab 0.
    2.Second SubtabLayout set InitialSubTab 2.

3. Add Spacer Item in between two SubLayoutRN

4. Select First SubTabLayout add 2 Region Style

5. Select SubTabs and create StatusBar

6. Create 2 Link Item under StatusBar also set PartialFireAction of each.

7. Select second SubTabLayout add 2 Region Styles.

8. Select SubTabs and create StatusBar

9. Create 2 Link Item under StatusBar also set PartialFireAction of each.

OutPut:

Thanks,
Dilip

Hide and Show region in PFR on Event

Here is  custom working solution for  Hide and Show region in PFR .


Step1: Declare global variable.

private static int chk = 0;


Step2: Write below code in PR

//Here im hiding Advanced Table Region


OAAdvancedTableBean table2 = (OAAdvancedTableBean)webBean.findChildRecursive("Table2RN");

     table2.queryData(pageContext, true);

    if (chk==1)

           {

             table2.setRendered(Boolean.TRUE);

           }

           if(chk==0){

             table2.setRendered(Boolean.FALSE);

           }


Step3: Write below code in PFR

if (pageContext.getParameter("SaveBtn") != null) //Show Table

              {
                chk = 1;

                pageContext.setForwardURLToCurrentPage(null, // no parameters to pass

                true, // retain the AM

                OAWebBeanConstants.ADD_BREAD_CRUMB_NO,

                OAWebBeanConstants.IGNORE_MESSAGES);

              }

 Thanks,
 Dilip

java.lang.IllegalAccessError, msg=oracle/jdbc/driver/OracleCallableStatement

oracle.apps.fnd.framework.OAException: oracle.jbo.JboException: JBO-29000: Unexpected exception caught:  java.lang.IllegalAccessError, msg=oracle/jdbc/driver/OracleCallableStatement

Solution:

  Import     import oracle.jdbc.OracleCallableStatement;


Thanks,
Dilip

Converting String to the Number

When a Number is rendered as a String in the browser we can convert it to Number using getOANLSServices().stringToNumber method.

String quoteHdrNum = getQuoteContextParam(pageContext, "QotCtxtHdrNum");
java.lang.Number QuotNum= pageContext.getOANLSServices().stringToNumber(quoteHdrNum );
  {
     //do Operation
  }