Date Format Conversion

Sample Code:
  
 oracle.jbo.domain.Date date1 = am.getOADBTransaction().getCurrentDBDate();
java.text.SimpleDateFormat displayDateFormat = new java.text.SimpleDateFormat ("dd-MM-yyyy hh:mm s");
         String OracleDateForm = displayDateFormat.format(date1.dateValue());

Extended VO is Read Only

Error:
Each row in the Query Result Columns must be mapped to a unique Query Attribute in the Mapped Entity columns.

Try with below options.

1.Each row in the query result columns must be maped to a unique query attribute in the mapped entity columns(Check any attribute is Transiet).

2.Check Your Jdeveloper Version is correct?

3. Try to Create Fresh VO Extension in new WorkSpace.

Thanks,
Dilip

Right alignment of field (with data type varchar2) in OAF

//In Controller

public void processRequest(OAPageContext pageContext, OAWebBean webBean)
 {
        super.processRequest(pageContext, webBean);
          CSSStyle csNum = new CSSStyle();
           csNum.setProperty("display", "block");
           csNum.setProperty("width", "75px");
           csNum.setProperty("text-align", "right");
         OAMessageStyledTextBean omstb1 =
            (OAMessageStyledTextBean)webBean.findChildRecursive("Segment1");
           omstb1.setInlineStyle(csNum);
}

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