Author: admin

Call Procedure in OAF (1 input, 1 output parameter):            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();               …

Here is how to configure an input LOV. First we must create a region, which provides the values, (if we don't use an existing one e.g. ponSupplierItemLovRN):Item:ID:                          xxTestLOVExternal…

- 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…

Use the following commands;$INST_TOP/admin/scripts/adoacorectl.sh stop$INST_TOP/admin/scripts/adoacorectl.sh start

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…

To hide a buttonOASubmitButtonBean saveT = (OASubmitButtonBean)webBean.findChildRecursive("Save1");saveT.setRendered(true);To disable a buttonOASubmitButtonBean saveT = (OASubmitButtonBean)webBean.findChildRecursive("Save1");saveT.setDisabled(true);

(from Oracle Application Framework Developer's Guide 12.1.3)Some CSS Styles:OraDataText, OraFieldText, OraTipTextCommon Control Types:OAMessageCheckBoxBeanOAMessageChoiceBeanOAMessageDateFieldBeanOAMessageStyledTextBeanOAMessageTextInputBeanOAMessageLovInputBeanOther Control Types:OAInlineMessageBean, OAMessageAttachmentLinkBean, OAMessageBoxBean, OAMessageColorFieldBean, OAMessageDownloadBean, OAMessageFileUploadBean, OAMessageInlineAttachmentBean, OAMessageLayoutBean, OAMessageListBean, OAMessageLovChoiceBean, OAMessageLovTextInputBean, OAMessagePromptBean, OAMessageRadioButtonBean, OAMessageRadioGroupBean, OAMessageRichTextEditorBean, OARichTextEditorBean

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);

You can use the following snippets, for storing and getting values from the session:set session value:pageContext.putSessionValue("session_xxCode", xxCode_parameterString); get session value:pageContext.getSessionValue("session_xxCode")remove session value:pageContext.removeSessionValue("session_xxCode");Also through pageContext.getApplicationModule(webBean).getOADBTransaction() you can get a lot of session information.For example:pageContext.writeDiagnostics(this,…