Thursday, February 15, 2018

ADF - Code Snippets

Extract the value from the text input component

Write the below method in the managed bean.

    public Object cb1_action() {
        // Add event code here...
        FacesContext facesContext = FacesContext.getCurrentInstance();
            UIViewRoot root = facesContext.getViewRoot();
            RichInputText inputText = (RichInputText)root.findComponent("it1");
            String val = (String)inputText.getValue();
            System.out.println("Entered Value -->"+ val);
        return null;


Thursday, December 14, 2017

Comparison of Files Created For HelloWorld Application in OAF and ADF

In this post, i would like to provide very basic level of files comparison between OAF and ADF

HelloWorld - OAF Application Requires the following :

Below are the bare minimum files, which are required to create HelloWorld Page in OAF.

Workspace - .jws file
Project  - .jpr file
Application Module : AM.xml ,
UI Page - HelloWorldPG.xml

Below are the files, which are required to create HelloWorld Page in ADF
Workspace - .jws file
Project- ViewController.jpr , Model.jpr
UI Page - HelloWorldPG.jspx
Config Files : adf-config.xml, weblogic-application.xml, adfc-config.xml, faces-config.xml, trinidad-config.xml, web.xml

Few Observations in this HelloWorld ADF Sample :

  • AM is not required to run HelloWorld PG in ADF
  • 2 Projects are created by Default in ADF
  • ADF runs on Embedded Weblogic Server(While Running from Desktop)
  • No DB connection is required

OAF - Code Snippet to get list of AM's Loaded in the page

             OAApplicationModule parentAM = pageContext.getRootApplicationModule() ;
             String[] nestedAMNames = parentAM.getApplicationModuleNames();
             // If you want to retrieve all currently loaded nested Application Modules
             ApplicationModule[] nestedAMs = new ApplicationModule[nestedAMNames.length];

             // hzCustAccountAM = null;
     HzPuiActContRoleAM  = null;
             for (int i = 0; i < nestedAMNames.length && temp==0; i++)
             nestedAMs[i] = parentAM.findApplicationModule(nestedAMNames[i]);
                 pageContext.writeDiagnostics(this,"nestedAMs["+i+"]" + nestedAMs[i],OAFwkConstants.STATEMENT);
              if(nestedAMs[i] instanceof HzPuiActContRoleAMImpl)
                   temp = 1;
                   HzPuiActContRoleAM = (HzPuiActContRoleAMImpl)nestedAMs[i];
                   pageContext.writeDiagnostics(this,"Matching AM Found ; nestedAMs["+i+"]" + nestedAMs[i],OAFwkConstants.STATEMENT);

Wednesday, December 06, 2017

Oracle SCM - Lookups

mtl_txn_request_lines  -Line Status Lookup

select lookup_code, meaning
from mfg_lookups 
where lookup_type = 'MTL_TXN_REQUEST_STATUS' 

order by lookup_code 

Tuesday, October 31, 2017

Solidity - Smart Contract - FirstOne - HelloWorld

From Website :

contract HelloWorld { 
    event log_string(bytes32 log); // Event

    function () { // Fallback Function
        log_string("Hello World!");

BlockChain Notes

Quora BlockChain Advisors

Top BlockChain Companies

  1. Applied Blockchain (
  2. Parity Technologies (
  3. ConsenSys (
  4. AlphaPoint (
  5. ChainThat (
  6. Chainsmiths (
  7. Ledger Labs (Ledger Labs - Expert Blockchain Consulting)
  8. Brainbot Technologies (brainbot technologies)

  1. Vitalik Buterin - Co-Founder of Ethereum, Co-founder of Bitcoin Magazine.
  2. Nick Szabo
  3. Andreas M. Antonopoulos - Author of Mastering Bitcoin, first comprehensive book about how it all works.
  4. Broke Pierce - Managing Partner at Blockchain Capital & Chairman of Bitcoin Foundation.

The next disruptive technology.

The below list of URL's to help out to learn about Ehterium BlockChain


Monday, September 11, 2017

Oracle E-Business Suite 12.2.7 - Released

E-Business Suite Development is pleased to announce the availability of Oracle E-Business Suite 12.2.7. This latest release, which continues a pattern of ongoing functional and technical innovation, is organized around these key investment drivers:

Thursday, August 31, 2017

Custom Lot Number Generation - Oracle E-Business Inventory

To do this:
1. Select the lot number generation option as "‘User-Defined"
2. Write the code to generate the lot number as per the business need in the procedure
3. This procedure is found in the file "‘INVUDLGS.pls"

4. Package Name : user_pkg_lot , method name : generate_lot_number

Friday, August 25, 2017

Value Sets - Special Value Sets -

One of the frequent issues faced mostly in SQL/PLSQL is based on Date Formats.

Following is one of the code snippet to validate From Date/ To Date  with users using Different Date Formats.


l_char  varchar2(25) := :!value ;
l_count NUMBER := 0;

  SELECT trunc(l_value - to_date(':$FLEX$.XX_FROM_DATE','YYYY/MM/DD HH24:MI:SS'))
  INTO l_count
  FROM dual;

  IF l_count  >  365

fnd_message.set_name( 'FND', 'FND_GENERIC_MESSAGE') ;
fnd_message.set_token( 'MESSAGE', 'Date Difference Should Not Be Greater Than 365 Days' );
fnd_message.raise_error ;
   ELSIF  l_count <1    THEN
     fnd_message.set_name( 'FND', 'FND_GENERIC_MESSAGE') ;
     fnd_message.set_token( 'MESSAGE', 'To Date Should Be Greater Than From Date');
     fnd_message.raise_error ;
   END IF;