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 , AMImpl.java
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];

             // oracle.apps.ar.hz.components.account.customer.server.HzPuiCustActAMImpl hzCustAccountAM = null;
             oracle.apps.ar.hz.components.account.contact.server.HzPuiActContRoleAMImpl  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 : https://karl.tech/learning-solidity-part-1-deploy-a-contract/

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

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

BlockChain Notes


Quora BlockChain Advisors

https://www.quora.com/profile/Arnav-Vohra-3


Top BlockChain Companies

  1. Applied Blockchain (http://appliedblockchain.com)
  2. Parity Technologies (https://ethcore.io/)
  3. ConsenSys (http://consensys.net)
  4. AlphaPoint (http://www.alphapoint.com/)
  5. ChainThat (http://chainthat.com/)
  6. Chainsmiths (http://chainsmiths.com)
  7. Ledger Labs (Ledger Labs - Expert Blockchain Consulting)
  8. Brainbot Technologies (brainbot technologies)

Experts:
  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



  • https://remix.ethereum.org/
  • https://remix.readthedocs.io/en/latest/
  • https://metamask.io/

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:


http://www.oracle.com/us/products/applications/ebs-ga-2017-09-08-3876665.pdf

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
    generate_lot_number
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.


FND PLSQL " DECLARE

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

   l_value   DATE :=  TO_DATE(l_char,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'), 'NLS_DATE_LANGUAGE = AMERICAN') ;
 
  BEGIN
  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

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

END;"

Thursday, July 20, 2017

Oracle ERP- Supplier Audit - Important Points



After Supplier Is Updated, Alert On AP_SUPPLIERS Table Is Triggered Twice (Doc ID 1969553.1)

As part of enabling Oracle Alert functionality, the following trigger is created on the AP_SUPPLIERS table:

create trigger TEST_SUPP_UPD_ALERT_AU AFTER UPDATE on AP.AP_SUPPLIERS for each row
begin
insert into XXTEST_SUPP_ALERT_UPD values (:new.VENDOR_ID, :new.LAST_UPDATE_DATE);
end;

When supplier data is updated through the Supplier Master pages, multiple rows are inserted into the table XXTEST_SUPP_ALERT_UPD. The expectation is that only one row would be inserted.

Please explain / provide fix.