Total Pageviews

Friday, 25 December 2020

Word Meaning


  • Conundrum -> Difficult Question
  • Fleet -> Lasted for a short period of Time
  • Enduring -> Last for a long period of time
  • Apprise-> Inform or Tell(Someone)

Friday, 18 December 2020

OAF: Page Navigation (Oracle Apps)

How to navigate between pages in OAF

1) 

pageContext.setForwardURL("OA.jsp?page=/oracle/apps/fnd/framework/toolbox/tutorial/webui/SupplierPG",

null,

KEEP_MENU_CONTEXT,

null,

null,

true, // Retain AM

OAWebBeanConstants.ADD_BREAD_CRUMB_YES,

OAWebBeanConstants.IGNORE_MESSAGES);


-----------------------------------------------------------------------------------------------------------------------------

#Oracle Apps , # OAF

OAF : Exception Types ( Oracle Apps)

Exception Types in OAF ( Oracle Application Framework )



 1)    catch(Exception ex)

        {

            throw new OAException(ex.getMessage(), (byte)0);

        }


2) throw new OAException("Path not selected. Please select the path first.", (byte)0);

3) OAException message = new OAException("File uploaded successfully.", (byte)3);

            pageContext.putDialogMessage(message);

4)  OAException oaexception2 = new OAException("SQLAP", "AP_PAY_PSR_APPLY_CONFIRM", null, (byte)3, null);

     oapagecontext.putDialogMessage(oaexception2);


5) catch(NullPointerException ex)

      {   System.out.println("you are in inside catch exception");

       throw new OAException("Please Select a File to Upload", OAException.ERROR);

      }


    


OAF : How to Retrieve DFF Value in OAF

 

super.processFormRequest(pageContext,webBean);

   OADescriptiveFlexBean oaDFF = null;

 //  OADescriptiveFlexBean oadescriptiveflexbean = null;

  DescriptiveFlexfield descriptiveflexfield =null;

   OAMessageTextInputBean addr1 = null;

 oaDFF = (OADescriptiveFlexBean)webBean.findChildRecursive("DetailFlex");//Get Source by going thorugh Inspectr Element right click//

               oaDFF.processFlex(pageContext);

   addr1 = (OAMessageTextInputBean)webBean.findChildRecursive("DetailFlex3");


OAF : How to Add days in input date

 OAF : How to Add days in input date

import java.text.SimpleDateFormat;

import java.util.Calendar;

import java.text.ParseException;

public class Example{

   public static void main(String args[]){

        String oldDate = "2017-01-29"; 

               System.out.println("Date before Addition: "+oldDate);

               SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

               Calendar c = Calendar.getInstance();

               try{

                  c.setTime(sdf.parse(oldDate));

               }catch(ParseException e){

                  e.printStackTrace();

                }

               //Incrementing the date by 1 day

               c.add(Calendar.DAY_OF_MONTH, 1); 

               String newDate = sdf.format(c.getTime()); 

               System.out.println("Date Incremented by One: "+newDate);

   }

}


OAF : How to Dynamically set Render/Read only properties in OAF Table

 

1)     1) Create transient Attribute as Boolean type in your VO

2)     2)  Place this syntax in a fields properties where dynamic is needed. ${oa.ReqUpdateVO1.IMEIIssueTextReadOnly}

3)     3) Write below code in Processrequest to enable or disable

OARow singleRow = (OARow)ReqUpdateVO.first();

g_req_status = (String)singleRow.getAttribute("ReqStatus");

singleRow.setAttribute("IMEIIssueTextReadOnly",Boolean.TRUE);

FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...