Wednesday, May 16, 2012

SOA – Service Oriented Architecture Overview

To start things on SOA, First we need to understand the basic concepts like web service. Because SOA is mainly related with the web services and its orchestration.
Web services describes a standardized way of integrating Web-based applications using the XML, SOAP, WSDL and UDDI open standards over an Internet protocol.
 XML (Extensible Markup Language) is used to tag the data
SOAP (Simple Object Access Protocol) is used to transfer the data
WSDL (Web Service Description Language) is used for describing the services available and
 UDDI (Universal Description, Discovery and Integration) is used for listing what services are available.

In the developers point of view BPEL (Business Process Execution Language) is used for the development and integration of web services.

BPEL is nothing but a XML based language used to describe a web service.XML tags used in the BPEL was standardized by the OASIS (Organization for the Advancement of Structured Information Standards).

Oracle SOA-BPEL Project development Overview -
 Normally we used to create the business logic (Language specific packages like PL/SQL package or Java Package) and the workflow by using the Oracle workflow. BPEL combines both the versions so that we can develop the workflow activities and some extent of the language code, which describes the business logic.

Steps:
a. Create the business process web service by using the IDE like Jdeveloper or Eclipse. Create a project,   then for the business logic in the project IDE automatically creates WSDL, XSD and XML files. All the project files are bundled into .Jar file for the deployment into the server.
b. Deploy BPEL project (.Jar) file on BPEL Process Manager by using Ant Utility or by using the IDE (Jdeveloper) itself.
c. To test the BPEL process, login into weblogic server em console , where we can test our deployed web service.




Query to find the Primary Customer Information based on the org_id



    SELECT *
    FROM   hz_parties hp,
                   hz_cust_accounts hca,
                   hz_party_sites hps1,
                   hz_locations hl1,
                   hz_cust_acct_sites_all hcas1,
                   hz_cust_site_uses_all hcsu1
    WHERE   hp.party_id                = hca.party_id
    AND hp.party_id                      = hps1.party_id
    AND hp.party_id                      = hps1.party_id
    AND hl1.location_id                  = hps1.location_id
    AND hps1.party_site_id          = hcas1.party_site_id
    AND hcas1.cust_account_id    = hca.cust_account_id
    AND hcas1.cust_acct_site_id  = hcsu1.cust_acct_site_id
    AND hcsu1.site_use_code        IN ('BILL_TO','SHIP_TO')
    AND hcsu1.primary_flag         = 'Y'
    AND hcsu1.status                      = 'A'
    AND hca.cust_account_id        = <sold_to_org_id>;

Thursday, May 3, 2012

Script To Download and Upload LDT Files For Various Objects



Concurrent Program
*************************************************
FNDLOAD apps/ohs_xnappi 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct Concurrent_Program_Short_Name.ldt PROGRAM  CONCURRENT_PROGRAM_NAME='Concurrent_Program_Short_Name' APPLICATION_SHORT_NAME='ZZZ'
FNDLOAD apps/ohs_xnappi 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct Concurrent_Program_Short_Name.ldt

Value Set
*************************************************
FNDLOAD apps/ohs_xnappi 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct Value_Set_Name.ldt VALUE_SET FLEX_VALUE_SET_NAME='Value_Set_Name'
FNDLOAD apps/ohs_dnappi 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct Value_Set_Name.ldt

Request Set
*************************************************
FNDLOAD apps/ohs_xnappi 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct Request_Set_Name.ldt REQ_SET_LINKS APPLICATION_SHORT_NAME=ZZZ REQUEST_SET_NAME=Request_Set_Name
FNDLOAD apps/ohs_dnappi 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct Request_Set_Name.ldt

Responsiblity
*************************************************
FNDLOAD apps/simple4u 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct Responsibility_Name.ldt FND_RESPONSIBILITY RESP_KEY="Responsibility_Name"
FNDLOAD apps/simple4u 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct Responsibility_Name.ldt

Lookups
*************************************************
FNDLOAD apps/options4u 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct Lookup_Name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='AU' LOOKUP_TYPE="Lookup_Name"
FNDLOAD apps/options4u 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct Lookup_Name.ldt

Flex Fields
*************************************************
FNDLOAD apps/ohs_xnappi 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct FlexField_Name_Ldt_File.ldt DESC_FLEX P_LEVEL=’COL_ALL:REF_ALL:CTX_ONE:SEG_ALL’ APPLICATION_SHORT_NAME="ZZZ" DESCRIPTIVE_FLEXFIELD_NAME="FlexField_Name" P_CONTEXT_CODE="Global Data Elements"
FNDLOAD apps/ohs_xnappi 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct FlexField_Name_Ldt_File.ldt

Form
*************************************************
FNDLOAD apps/ohs_xnappi 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct Form_Name.ldt FORM FORM_APP_SHORT_NAME='ZZZ' FORM_NAME=Form_Name
FNDLOAD apps/ohs_xnappi 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afsload.lct Form_Name.ldt FORM FORM_APP_SHORT_NAME='ZZZ' FORM_NAME=Form_Name UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Functions
*************************************************
FNDLOAD apps/simple4u 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct Function_Name_Ldt_File.ldt FUNCTION FUNCTION_NAME=Function_Name
FNDLOAD apps/simple4u 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afsload.lct Function_Name_Ldt_File.ldt FUNCTION FUNCTION_NAME=Function_Name UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Menus
*************************************************
FNDLOAD apps/simple4u 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct Menu_Name_Ldt_File.ldt MENU MENU_NAME=Menu_Name
FNDLOAD apps/simple4u 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afsload.lct Menu_Name_Ldt_File.ldt MENU MENU_NAME=Menu_Name UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Profile Options
*************************************************
FNDLOAD apps/ohs_xnappi 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct Profile_Ldt_Name.ldt PROFILE PROFILE_NAME="profile_option_short_name" APPLICATION_SHORT_NAME="FND"
FNDLOAD apps/ohs_xnappi 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct Profile_Ldt_Name.ldt
-- to download a single profile option value set at some site/user/resp level
FNDLOAD apps/ohs_xnappi O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct Profile_Ldt_Name.ldt PROFILE PROFILE_NAME="Profile_Name" APPLICATION_SHORT_NAME="FND" LEV='RESPONSIBILITY' LEV_NAME='Responsibility_Name'
FNDLOAD apps/ohs_xnappi 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct Profile_Ldt_Name.ldt