Saturday 1 November 2014

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

Saturday 28 June 2014

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}"