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/

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

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

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

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.

How to know the Oracle Cloud Version (Fusion ERP Version)

Oracle SQL to validate non-english characters

We had a requirement to validate non-english characters in the data.

Well, i used standard function regexp_like(column, '[A-Z]')   considering those characters which are not replaced by this function are non-english, to my surprise it is not considering turkish characters.

select REGEXP_replace(UPPER('rn Aıklaması'), '[A-Z]','')Test from dual ;

Alternate Solution for this problem is  using : asciistr Function

If input is equal to asciistr function, then it is non-english.

select count(*) from dual where  'ĞEĞİK' <> asciistr('ĞEĞİK') ;

Oracle E-Business Suite : Purchase Order Type Lookup Code

PO_HEADERS_ALL

The following table describes column information for the PO_HEADERS_ALL table.

Column Name	Null	Type	Comments
PO_HEADER_ID	NOT NULL	NUMBER	Primary key
AGENT_ID	NOT NULL	NUMBER	Foreign key: HR_EMPLOYEES
TYPE_LOOKUP_CODE	NOT NULL	VARCHAR2(25)	Foreign Key: PO_LOOKUP_ CODES
LAST_UPDATE_DATE	NOT NULL	DATE	N/A
LAST_UPDATED_BY	NOT NULL	NUMBER	N/A
SEGMENT1	NOT NULL	VARCHAR2(20)	PO number
SUMMARY_FLAG	NOT NULL	VARCHAR2(1)	N
ENABLED_FLAG	NOT NULL	VARCHAR2(1)	Y
VENDOR_ID		NUMBER	Foreign key: PO_VENDORS
VENDOR_SITE_ID		NUMBER	Foreign key: PO_VENDOR_SITES
TERMS_ID		NUMBER	N/A
FREIGHT_TERMS_ LOOKUP_CODE		VARCHAR2(25)	Foreign key: PO_LOOKUP_ CODES
CURRENCY_CODE		VARCHAR2(15)	N/A
APPROVED_FLAG		VARCHAR2(1)	Y

select * from PO_LOOKUP_CODES where lookup_type='PO TYPE';  

Oracle E-Business Suite Supplier / Supplier Site Related API's Queries

API To Update Supplier/Supplier Site


R12: AP: New Supplier Update API's in Oracle Payables (Doc ID 1618099.1)

OAF- How to get Segment values from KFF

Following is the code snippt, which can be used to get segment values from the selected KFF.

///Below is the PFR Code on Save button

         OAKeyFlexBean kffbean= (OAKeyFlexBean)webBean.findIndexedChildRecursive("kffID");     //Get the KFF bean

         KeyFlexfield kff=(KeyFlexfield)kffbean.getAttributeValue(OAWebBeanConstants.FLEXFIELD_REFERENCE);       //Getting the Reference Value
         if(kff!=null){
             if(kff.getSegment(1).getValue()!=null)
             {
                     String value = kff.getSegment(1).getValue().toString();    //This returns Value object so we can just see a object
                     String name = kff.getSegment(1).getName();                 // This returns the Segment name attached
                     String inputValue = kff.getSegment(1).getInputValue();       // This returns the Segment value when user gives as input
                    
                     System.out.println("Value -->"+ value);
                 System.out.println("name -->"+ name);
                 System.out.println("inputValue -->"+ inputValue);
             }
         }

 

Tips in ADF - for developers from OAF background

TIP # 1. How to find the backing bean of an ADF Page ?
 (In OAF, it is very easy to get the CO name which is used in a given page/region).

In ADF -- Controller logic is handled through Taskflows.

For a given page  : check the below way to get which Controller(Taskflow) is used.

Following is the page and its managed bean information.

Following is the screen for the Page file.

 Following is the content of page file in XML Code.
In the below code : (if you compare with OAF - which is based on UIX-User interface for XML) -- This is based jspx ; xml with jsp.
Top level bean in JSPX is : JSP:Root followed by : f:view

  <f:view>
    <af:document id="d1" binding="#{backingBeanScope.backing_ADFRegionsPG.d1}">
      <af:form id="f1" binding="#{backingBeanScope.backing_ADFRegionsPG.f1}"></af:form>
    </af:document>
  </f:view>

In f:view -- other tag is : af:document  
this is attached to bean -- This is bean which is attached to this page.
CTRL+CLICK on : ADFRegionsPG.d1    -- Navigates to  ADFRegionsPG.java

Backing bean information : about : package, class details of it.

Basic Level Comparison of OAF vs ADF - MVC Layer Execution

Hello All,

In this i will try to highlight how the page execution happens and the framework differences between OAF and ADF.

Consider the below scenario :

Display Department Data in the output.

-----------------------------------------------------------------------------------------
From OAF Perspective
-----------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------
* Following files would be required to display the data.
Model
  SampleAM.xml
  SampleAMImpl.java
  DeptVO.xml
  DeptVOImpl.java

View  
   DeptDetailsPG.xml

CO 
   DeptpDetailsCO.java
-----------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------
From ADF Perspective

Model
  SampleAM.xml
  SampleAMImpl.java
  DeptVO.xml
  DeptVOImpl.java

View  
   DeptDetailsPG.xml
   DeptDetailsPG.jspx
   DeptDetailsPGPageDef.xml

CO 
   DeptpDetailsCO.java

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

OAF - How to iterate rows programatically in View Object (VO) - Using RowSet or RowSetIterator

There are different requirements which we generally come across to iterate the data from VO.

Following are different approaches - we can use to get the data from VO.

You can write the below logic in : AMImpl

//Using RowSetIterator Logic 

 public void initShowEmpData()
  {
    EmpEOVOImpl vo = getEmpEOVO1();
    EmpEOVORowImpl row = null;
   
    RowSetIterator rowIter = vo.createRowSetIterator("EmpIter");
   
    while(rowIter.hasNext())
     {
       row = (EmpEOVORowImpl)rowIter.next(); //FETCH INTO
       System.out.println("EmpNO-->"+ row.getEmpno()  + " Name-->"+ row.getEname()
         + " SelectFlag-->" + row.getselectFlag()      
        );
     
     }
     rowIter.closeRowSetIterator();
   
  }

//Using FilteredRows Logic to get the filtered rows.

    public void deleteSelectedRowsNew()
       {
         EmpEOVOImpl vo = getEmpEOVO1();
         EmpEOVORowImpl row = null;
       
         Row rows[]= vo.getFilteredRows("selectFlag","Y");
         
          int selectedRowLenth = rows.length;
         
           if(selectedRowLenth>0)
             {
             
                for(int i=0;i<selectedRowLenth;i++)
                  {
                    row = (EmpEOVORowImpl)rows[i];
                    row.remove();
                  }
               OAException infoMsg = new OAException("Deleted The Selected Rows--Count-->"+selectedRowLenth,
                              OAException.INFORMATION);
                              throw infoMsg;
               }
         
           else
            {
              OAException warningMsg = new OAException("Plese Select The Rows", OAException.WARNING);
              throw warningMsg;
            }
       
       }


//Using RowQualifier

       public void showEmpDataUsingRowQualifier()
     {
         EmpEOVOImpl vo = getEmpEOVO1();
         EmpEOVORowImpl row = null;
       
     System.out.println("Using --showEmpDataUsingRowQualifier Logic");
       
         oracle.jbo.server.RowQualifier rowQualifer = new RowQualifier(vo);
         rowQualifer.setWhereClause("Deptno= 10 and Job='SALESMAN'");
         Row rows[] = vo.getFilteredRows(rowQualifer) ;
       
         int selectedRowLenth = rows.length;
       
          if(selectedRowLenth>0)
            {
             
               for(int i=0;i<selectedRowLenth;i++)
                 {
                   row = (EmpEOVORowImpl)rows[i];
                 
                     System.out.println("EmpNO-->"+ row.getEmpno()  + " Name-->"+ row.getEname()
                       + " SelectFlag-->" + row.getselectFlag() );
                     
                 }
              }

     }

OAF -How to get the current page name

OAF - CO Extension - Find the page name at run time.

I have come across a requirement for which i have to perform CO extension.

But there are two pages involved in which both of them are using same CO.

But i have to write a different logic for the pages.

So i have used the below logic to identify the page and wrote the logic accordingly.


Hope the below code helps..


//Code to get the page Name.


    String pageURL = pageContext.getCurrentUrl ();
    int lastIndex  = pageURL.lastIndexOf( '/' );;
    String finalPageNameStr = pageURL.substring(lastIndex + 1, pageURL.indexOf("&"));
    pageContext.writeDiagnostics(this,"Final Page Name -->" + finalPageNameStr,1);



  if (finalPageNameStr!=null && "pageNameA".equals(finalPageNameStr))
    {
 pageContext.writeDiagnostics(this," Inside Page A logic ",1);

}
 else  if (finalPageNameStr!=null && "pageNameB".equals(finalPageNameStr))
   {
  pageContext.writeDiagnostics(this," Inside Page B logic ",1);  
}

OAF - Set FireAction for DropDown Dynamically

  public void processRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processRequest(pageContext, webBean);
   
      super.processRequest(pageContext, webBean);
      AMCGBizzSericesAMImpl am = (AMCGBizzSericesAMImpl)pageContext.getApplicationModule(webBean);
      am.initEmpEOVO();
     
      System.out.println("PR Method of Main page RN");
     
      OAMessageChoiceBean deptPopIDBean = (OAMessageChoiceBean)webBean.findIndexedChildRecursive("deptPopID");
      deptPopIDBean.setFireActionForSubmit("DeptPop_EVENT",null,null,true);
  }

  /**
   * Procedure to handle form submissions for form elements in
   * a region.
   * @param pageContext the current OA page context
   * @param webBean the web bean corresponding to the region
   */
  public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processFormRequest(pageContext, webBean);
   
      System.out.println("PFR Method of Main Page  RN");
     
      String eventParam = pageContext.getParameter(EVENT_PARAM);
       if(eventParam!=null && "DeptPop_EVENT".equals(eventParam))
        {
         throw new OAException("User Clicked on PopEvent");
        }
     
   
     
  }

Oracle Cloud - Invoking REST Webservice (HCM Module)

Invoking REST web service Using: Advanced REST client (in chrome)

REST WebService URL : https://rws2-fapxxx-hcm.oracledemos.com/hcmCoreApi/resources/11.1.11/emps//?q=PersonNumber=715

Invoking REST  WebService using SOAP REST Client.

OAF Page Controller Flow , When Multiple CO's  are there.


Events are handled from mainRN to child RN.

Following is the log snippet for the same.


--Process Request Method
PR Method of Main Page  RN
PR Method of Shared RN



-- Process Form Request Method
PFR Method of Main Page  RN
PFR Method of Shared RN

OAF- Query to list all personalizations

Following query can be used to list all the personalizations of OAF using MDS Repository.

**But the problem with the below one, we cant be sure personalizations which are done by the business and as well as personalizations (vanilla) which are provided by oracle

*CREATED_BY column does not have any info any significance to validate if it is provided by oracle or done by business.

*business means : customization's done by developer for custom requirements.

select
jp.created_by,
jp.path_name, jp.path_docid
, jdr_mds_internal.getdocumentname(jp.path_docid) page_path
from jdr_paths jp where 1=1
AND jp.path_type='DOCUMENT'
AND jdr_mds_internal.getdocumentname(jp.path_docid)  like '/oracle/apps/%custo%'

Oracle AP Invoice Aging Report Query
------------------------------------------------

SELECT   org_name,
              vendor_name,
              vendor_number,
              vendor_site_details,
              invoice_number,
              invoice_date,
              gl_Date,
              invoice_type,
              due_date,
              past_due_days,
              amt_due_remaining,
              CASE
                 WHEN past_due_days >= -999 AND past_due_days < 0
                 THEN
                    amt_due_remaining
                 ELSE
                    0
              END
                 CURRENT_BUCKET,
              CASE
                 WHEN past_due_days >= 0 AND past_due_days <= 30
                 THEN
                    amt_due_remaining
                 ELSE
                    0
              END
                 BUCKET_0_30,
              CASE
                 WHEN past_due_days > 30 AND past_due_days <= 60
                 THEN
                    amt_due_remaining
                 ELSE
                    0
              END
                 BUCKET_31_60,
              CASE
                 WHEN past_due_days > 60 AND past_due_days <= 90
                 THEN
                    amt_due_remaining
                 ELSE
                    0
              END
                 BUCKET_61_90,
              CASE
                 WHEN past_due_days > 90 AND past_due_days <= 120
                 THEN
                    amt_due_remaining
                 ELSE
                    0
              END
                 BUCKET_91_120,
              CASE
                 WHEN past_due_days > 120 AND past_due_days <= 999999
                 THEN
                    amt_due_remaining
                 ELSE
                    0
              END
                 GREATER_THAN_120
       FROM   (SELECT   hou.name org_name,
                        pv.vendor_name vendor_name,
                        pv.segment1 vendor_number,
                        pvs.vendor_site_code || ' ' || pvs.city || ' ' || state
                           vendor_site_details,
                        i.invoice_num invoice_number,
                        i.payment_status_flag,
                        i.invoice_type_lookup_code invoice_type,
                        i.invoice_date Invoice_Date,
                        i.gl_date Gl_Date,
                        ps.due_date Due_Date,
                        (CEIL (SYSDATE - ps.due_date)) past_due_days, -- DAYS_DUE,
                        DECODE (
                           i.invoice_currency_code,
                           'USD',
                           DECODE (
                              0,
                              0,
                              ROUND (
                                 ( (NVL (ps.amount_remaining, 0)
                                    / (NVL (i.payment_cross_rate, 1)))
                                  * NVL (i.exchange_rate, 1)),
                                 2
                              ),
                              ROUND( ( (NVL (ps.amount_remaining, 0)
                                        / (NVL (i.payment_cross_rate, 1)))
                                      * NVL (i.exchange_rate, 1))
                                    / 0)
                              * 0
                           ),
                           DECODE (
                              i.exchange_rate,
                              NULL,
                              0,
                              DECODE (
                                 0,
                                 0,
                                 ROUND (
                                    ( (NVL (ps.amount_remaining, 0)
                                       / (NVL (ps.payment_cross_rate, 1)))
                                     * NVL (i.exchange_rate, 1)),
                                    2
                                 ),
                                 ROUND( ( (NVL (ps.amount_remaining, 0)
                                           / (NVL (i.payment_cross_rate, 1)))
                                         * NVL (i.exchange_rate, 1))
                                       / 0)
                                 * 0
                              )
                           )
                        )
                           amt_due_remaining
                 FROM   ap_payment_schedules_all ps,
                        ap_invoices_all i,
                        ap_suppliers pv,
                        ap_supplier_sites_all pvs,
                        ap_lookup_codes alc1,
                        hr_operating_units hou
                WHERE       i.invoice_id = ps.invoice_id
                        AND i.vendor_id = pv.vendor_id
                        AND i.vendor_site_id = pvs.vendor_site_id
                        AND i.org_id = hou.organization_id
                        AND i.cancelled_date IS NULL
                        --AND ps.amount_remaining = 0
                        AND (NVL (ps.amount_remaining, 0)
                             * NVL (i.exchange_rate, 1)) != 0
                        AND i.payment_status_flag IN ('N', 'P')
                        AND alc1.lookup_type(+) = 'INVOICE TYPE'
                        AND alc1.lookup_code(+) = i.invoice_type_lookup_code
                        --and    i.INVOICE_NUM ='358908411'
                        AND ap_invoices_pkg.get_approval_status (
                              i.invoice_id,
                              i.invoice_amount,
                              ps.payment_status_flag,
                              invoice_type_lookup_code
                           ) in('APPROVED','NEEDS REAPPROVAL'))
--                        AND i.org_id = fnd_profile.VALUE ('ORG_ID'))
where 1=1
ANd vendor_name IN ( 'Advantage Corp' ,'Capp Consulting' )
and invoice_number IN ('18-JAN-2007','AC0904','22-JUN-2007','25-JUL-2007')
   ORDER BY   2;

Oracle ERP Cloud - Invoke HCM REST WebService Using CURL

URL For List of HCM REST WebServices : https://docs.oracle.com/cloud/latest/jcs_gs/JSRMR/Use%20cURL.html


Command to invoke REST WebService

curl -i -u "<username>:<password>" -X GET https://<host>:<port>/hcmCoreApi/resources/latest/emps/

  Example :   curl  -k -i -u "CASEY.BROWN:Password" -X GET https://rws2-<xxno>-hcm.oracledemos.com/hcmCoreApi/resources/11.1.11/emps/

curl  -k -i -u "CASEY.BROWN:Password" -X GET https://rws2-<xxno>-hcm.oracledemos.com/hcmCoreApi/resources/11.1.11/emps//?q=PersonNumber=715

Following is the output :