Oracle Applications Framework

List Responsibilities and Responsibility Keys that are assigned to a user

2012-01-19T00:57:00.000-08:00

SELECT r.responsibility_key,a.application_name, fa.APPLICATION_SHORT_NAME
    FROM fnd_user u,
         fnd_user_resp_groups ur,
         fnd_responsibility r,
         fnd_application_tl a,
         fnd_application fa
   WHERE ur.responsibility_id = r.responsibility_id
         AND u.user_id = ur.user_id
         AND fa.APPLICATION_ID = a.APPLICATION_ID
         AND r.application_id = a.application_id
         AND upper(u.user_name) = UPPER ('ORACLE')
         AND a.language = 'US'
ORDER BY 1

User Profile Options

2011-12-19T05:15:00.001-08:00

With the following query, you can list all the profile options assigned to a particular user:

select vl.profile_option_name,tl.user_profile_option_name,val.profile_option_value
from fnd_profile_options vl,fnd_profile_option_values val,fnd_profile_options_tl tl
where vl.PROFILE_OPTION_ID = val.profile_option_id
and tl.language = 'US'
and tl.profile_option_name = vl.profile_option_name
and val.level_value = (select user_id from fnd_user where user_name = 'ORACLE')
order by vl.profile_option_name;

Add Processing Page Access to Launching Page

2011-07-13T02:48:00.000-07:00

In the page that initiates the long-running process, add code to instantiate and navigate to the processing page
as shown in the example below. (Taken from Oracle Developers Guide)

import oracle.apps.fnd.framework.webui.OAProcessingPage;

public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
{
   super.processFormRequest(pageContext, webBean);

   // This example assumes a submit button named "StartProcess" initiates the long-running process.
   if (pageContext.getParameter("StartProcess")!= null)
   {
     // Create the processing page and pass it the fully qualified name of the controller that
     // you created to launch the process.
     OAProcessingPage page = new
OAProcessingPage("oracle.apps.fnd.toolbox.samplelib.webui.processCO");

     // The concise message is displayed in bold and should briefly describe the process.
     // NOTE: never hard-code text display values as shown here. Always use message dictionary.
     page.setConciseMessage("This is the concise processing page message.");

     // The detailed message displays below the concise message in plain text. It provides
     // additional information about what's happening.
     page.setDetailedMessage("This is the detailed message which should explain what's happening.");

     // This is displayed in the processing page title.
     page.setProcessName("<Process Name>");

     // Forward to the processing page. Note that the OA Framework assumes you
   // are retaining the root application module. Since we haven't specified a different root AM on
     // the processing page, the OA Framework assumes it uses the same root AM as the launching page.
     pageContext.forwardToProcessingPage(page);
   }
}

Call Procedure in OAF (1 input, 1 output parameter)

2011-07-08T05:31:00.000-07:00

            String sql = "BEGIN xx_custom_pkg.custom_prc (:1,:2); END;";
            try {
                OracleCallableStatement cs =
                    (OracleCallableStatement)oam.getOADBTransaction().createCallableStatement(sql,
                                                                                              2);
                ((OracleCallableStatement)cs.registerOutParameter(2,
                                                                  Types.VARCHAR,
                                                                  0, 2000));
                cs.setString(1, xxAttribute1Value);
                cs.execute();
                String outParamValue = cs.getString(1);
                pageContext.writeDiagnostics(this,
                                             "Result is:" + outParamValue,
                                             OAFwkConstants.PROCEDURE);
                cs.close();
            } catch (Exception ex) {
                pageContext.writeDiagnostics(this, "Error:" + ex.toString(),
                                             OAFwkConstants.PROCEDURE);
            }

Call Procedure in OAF (2 input parameters)

2011-07-06T08:34:00.000-07:00

Call a custom procedure. Two input parameters of type Varchar:
OAApplicationModule oam = pageContext.getApplicationModule(webBean);

String sql = "BEGIN xx_custom_pkg.custom_prc (:1,:2); END;";
                    try {
                        OracleCallableStatement cs =
                            (OracleCallableStatement)oam.getOADBTransaction().createCallableStatement(sql,
                                                                                                      2);
                        cs.setString(1, xxAttribute1Value);
                        cs.setString(2, xxAttribute2Value);
                        cs.execute();
                        cs.close();
                      }
                 catch (Exception ex) {
                        pageContext.writeDiagnostics(this,
                                                     "Error:" + ex.toString(),
                                                     OAFwkConstants.PROCEDURE);
                    }

Call Function in OAF

2011-07-06T08:23:00.000-07:00

The segment below calls a custom function with 1 input parameter of type Varchar and returns a Varchar :

   OAApplicationModule oam = pageContext.getApplicationModule(webBean);

   String sql =   "BEGIN :1 := xx_custom_pkg.call_custom_function (:2); END;";

OracleCallableStatement cs =
                            (OracleCallableStatement)oam.getOADBTransaction().createCallableStatement(sql,2);

                        try {
   //Register your function output...
                            cs.registerOutParameter(1, Types.VARCHAR, 0, 2000);
                            //Your input parameter below...
                            cs.setString(2, LinesRow.getAttribute("ReportLineId").toString());
                            cs.execute();
                            String p_res = cs.getString(1);
                            cs.close();
                            }
                        catch (Exception ex) {
                                        pageContext.writeDiagnostics(this,
                                                                     "Error:" + ex.toString(),
                                                                     OAFwkConstants.PROCEDURE);
                           }

Create Tip Messages

2011-07-06T01:17:00.000-07:00

Personalize the page:

The output will look like:

Second type of Tip Message:

And the output:

Returns a date string in the users date format

2011-07-05T00:46:00.001-07:00

/*
     * Returns a date string in the users date format
     *
     * @param nlsServ instance of OANLSServices
     * @param dateStr string in 'dd-mm-yyyy' format
     */
    public static String stringToDateString(OANLSServices nlsServ, String dateStr) {

      if (dateStr != null && !dateStr.equals(""))
      {
        Date date = null;
        if (databaseDateFormat != null) {
          try {
            date = databaseDateFormat.parse(dateStr);
          } catch (ParseException e) {
          }
        }

        if (date != null)
          return nlsServ.dateToString(date);
      }

      return null;
    }

Find a specific VO in AM.txt

2011-06-14T07:21:00.000-07:00

            OAApplicationModule rootAM = pageContext.getRootApplicationModule();

            OAApplicationModule CompAM =
                 (OAApplicationModule)rootAM.findApplicationModule("BiddersListsAM");

            OAViewObject BidVO =
                (OAViewObject)CompAM.findViewObject("BiddersListsVO");

            if (BidVO!= null) {

                Row BidRow = BidVO.getCurrentRow();

                   if (BidRow!=null) {

                   }

            }

Show Error Message (using fnd messages)

2011-06-02T05:05:00.000-07:00

This line requires you to create a custom message using Application Developer responsibility.
In this way your error message will be language specific.

throw new OAException("XXX", "XXX_READ_CUSTOM_MSG", null, OAException.ERROR, null);

Oracle Applications Framework Profiles

2011-06-01T07:19:00.000-07:00

• Profile Name :Personalize Self-Service Defn
– Yes enables personalization link on all pages..This should be no in Production environment. For development team also it is better to set it yes at the user level

• Profile Name: FND: Personalization Region Link Enabled
– Yes displays all regional links
– Minimal displays key regional links
It is better to set the personalize link at the region level

• Profile Name :Disable Self-Service Personal
– Turn off all personalization

• Profile Name: FND: Personalization Document Root Path
– Used for importing/exporting personalization

• Profile Name: FND: Diagnostics
– Enables diagnostics on top right corner of the page

Populate Current Date and Time in OAF

2011-06-01T07:12:00.000-07:00

OAApplicationModule am = pageContext.getApplicationModule(webBean);
SimpleDateFormat f = new SimpleDateFormat("yyyy-mm-dd hh:mm:ss");
String dateString = am.getOADBTransaction().getCurrentDBDate().toString();

java.sql.Date sqlDate= new Date(f.parse(dateString).getTime());

OAMessageDateFieldBean dateField =(OAMessageDateFieldBean)webBean.findIndexedChildRecursive("currentDate");

dateField.setValue(pageContext,sqlDate);

How To Generate A SQL Trace In OAF

2011-06-01T07:09:00.001-07:00

You can refer to Metalink note ID 357597.1

1. Set profile 'FND: Diagnostics' to Yes at user level.
2. Login to Personal Home Page as that user and select the 'Diagnostics' icon at the top of the page.
3. Select `Set Trace Level? and click Go
4. Select the desired trace level and click Save
5. Write down the trace id number(s).
6. Perform the activity that you want to trace
7. Return to the 'Diagnostics' page.
8. Select `Set Trace Level' and click Go
9. Select 'Disable Trace' and click Go.
10. Write down the trace id number(s) if different.
11. Go to user_dump_dest for your database and collect the raw trace file(s)
suffixes by the trace id number(s) you have recorded.
12. Exit Applications.

Note: you can identify the user_dump_dest directory in your environment by running the following SQL:
SQL> select name, value from v$parameter where name like 'user%';

Find the correct version of JDeveloper

2011-06-01T07:04:00.000-07:00

In order to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x,

you should refer to metalink note with ID 416708.1

For example, for Release 12.1 :

ATG Release 12.1 Version	JDeveloper 10g Patch
12.1 (Controlled Release - only included for completeness)	Patch 7315332 10G Jdev with OA Extension ARU for R12.1 (Controlled Release)
12.1.1 (rapidInstall or patch 7303030)	Patch 8431482 10G Jdeveloper with OA Extension ARU for R12.1.1
12.1.2 (patch 7303033 or patch 7651091)	Patch 9172975 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.2
12.1.3 (patch 9239090 or patch 8919491)	Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3
12.1.3.1 (patch 11894708)	Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3

Hide a Button

2011-06-01T06:54:00.003-07:00

OASubmitButtonBean saveT = (OASubmitButtonBean)webBean.findChildRecursive("Save1");
saveT.setRendered(true);

Disable a Button

2011-06-01T06:54:00.001-07:00

OASubmitButtonBean saveT = (OASubmitButtonBean)webBean.findChildRecursive("Save1");
saveT.setDisabled(true);

Show Confirmation Message

2011-06-01T06:52:00.001-07:00

OAException confirmMessage = new OAException("New Custom Message", OAException.CONFIRMATION);

pageContext.putDialogMessage(confirmMessage);

Launch a Workflow from OAF

2011-06-01T06:51:00.001-07:00

public void launchWorkFlowFromOAF(OAPageContext pageContext)

{

String wfItemType = "XXSR";

String wfProcess = "SR_MAIN_PROCESS";

OADBTransaction transaction = getOADBTransaction();

String Sr_No ;

String wfItemKey = " ";

Sr_No = pageContext.getParameter("sr_no");

wfItemKey = Sr_No+ transaction.getSequenceValue("xxsr_key_s.NEXTVAL").toString();

OANavigation wfClass = new OANavigation();

// Create Workflow Process

wfClass.createProcess(pageContext, wfItemType, wfProcess, wfItemKey);

// Set Number Attribute: SR_NO

wfClass.setItemAttrNumber(pageContext,
                          wfItemType,
                          wfItemKey,
                          "SR_NO",
                          Sr_No);

// Start Workflow Process

wfClass.startProcess(pageContext, wfItemType, wfProcess, wfItemKey);

}

Loop Through Fetched Records in VO

2011-06-01T06:50:00.000-07:00

This particular example was written for Oracle Sourcing.
It is very useful because you are able to get all records fetched from OAF, identify the ones you want
and do some work on them, by writing e.g. a pl/sql block.

       OAApplicationModule rootAM = pageContext.getRootApplicationModule();
       OAViewObject ReqVO   =      (OAViewObject)rootAM.findViewObject("BidHeaderSectionsVO");

            if (null!=ReqVO) {
                Row ReqRow = ReqVO.first();
                if (null != ReqRow) {

                int idx = ReqVO.getRowCount();

                for (int xx = 0; xx < idx; xx++) {
                    if (null != ReqRow) {
                       // Do some work....
                       ReqRow = ReqVO.next();
                    }
                    else {}
                }
              }
            }

Forward to a New Page

2011-06-01T06:48:00.000-07:00

This code requires you to setup a new function with name XXX_CUSTOM_PAGE, specify the complete path and assign this function to your responsibility.

String AuctionHeaderId = ReqRow.getAttribute("AuctionHeaderId").toString();
String BidNumber = ReqRow.getAttribute("BidNumber").toString();

HashMap hm = new HashMap(2);
hm.put("AuctionHeaderIdParam", AuctionHeaderId.toString());
hm.put("BidNumberParam", BidNumber.toString());

pageContext.setForwardURL("XXX_CUSTOM_PAGE", KEEP_MENU_CONTEXT, null,
hm, false, ADD_BREAD_CRUMB_YES, IGNORE_MESSAGES);

Get the value of a check box field in a page

2011-06-01T06:42:00.001-07:00

OAMessageCheckBoxBean InventoryCheckBoxBean = (OAMessageCheckBoxBean)webBean.findChildRecursive("InventoryCheckBox");

Object InventoryCheckBoxObj = InventoryCheckBoxBean.getValue(pageContext);
String InventoryCheckBoxValue = InventoryCheckBoxObj.toString();

Get Current Language

2011-06-01T06:40:00.001-07:00

This code gets the system current language:

if (pageContext.getCurrentLanguage().equals("US"))
{
}

Create new button programatically

2011-06-01T06:39:00.000-07:00

The following code requires you to setup a new custom message in Applications (Application Developer Responsibility) with name XXX_CUSTOM_MSG_BUTTON.

OASubmitButtonBean oasb =
(OASubmitButtonBean)pageContext.getWebBeanFactory().createWebBean(pageContext,
"BUTTON_SUBMIT");
oasb.setID("xxCustomButton");
oasb.setUINodeName("xxCustomButton");
oasb.setEvent("xxCustomButton");

String printTextMsg = pageContext.getMessage("XXX","XXX_CUSTOM_MSG_BUTTON",null);
oasb.setText(printTextMsg);
oawebbean.addIndexedChild(oasb);

Compare Dates

2011-06-01T06:37:00.000-07:00

The following code will help you compare 2 dates in OAF.You should write this in your extended controller:

                 Date out_date = null;

                 rootAM = pageContext.getRootApplicationModule();

                 ReqHVO = (OAViewObject)rootAM.findViewObject("AuctionHeadersAllVO");

                 ReqRow = ReqHVO.first();

                 out_date = (Date)ReqRow.getAttribute("CloseBiddingDate");

                 OAApplicationModule am = pageContext.getApplicationModule(webBean);
                 SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
                 Date current_date = am.getOADBTransaction().getCurrentDBDate();

                if (out_date.getValue().getTime() > current_date.getValue().getTime()) {
}