Wednesday, 20 November 2013

HAFileAdapter in OSB Cluster Environment

If you are using jca file adapter in OSB for business service or proxy service and while deploying into  cluster Environment instead of file Adapter change to HAFileAdapter

Go to deployment in console -> click on file adapter -> click on HAFile Adapter ->go to properties -> enter below details


Go to Datasource ->jdbc/SOADataSource select target server as OSB Server
                 ->jdbc/SOALocalTxDataSource  select target server as OSB Server




Wednesday, 25 September 2013

Complex Flat File fixed length in NXSD

Ex:
          20130210                                                            à  Header 
0001284576196106212013062820130728                  à Details unbounded
0001284578196106212013062820130728
0001284580201210242013060120130604
0001284582193205082013102420141024
0001284584192103222013091420140914
0001302574192610152013092820140928
1111111111    6                                                            à Trailer  

NXSD Structure


<?xml version="1.0" encoding="UTF-8" ?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
            xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd"
            xmlns:tns="http://xmlns.nxsd.madhu/sampleFlatFile"
            targetNamespace=" http://xmlns.nxsd.madhu/sampleFlatFile"
            elementFormDefault="qualified"
            attributeFormDefault="unqualified"
            nxsd:version="NXSD"
            nxsd:stream="chars"
            nxsd:encoding="US-ASCII">


  <xsd:element name="Root-Element">
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element name="Request" type="tns:RequestType" />
      </xsd:sequence>
    </xsd:complexType>
  </xsd:element>


  <xsd:complexType name="DetailsType">

    <xsd:sequence>
      <xsd:element name="empId" type="xsd:string" minOccurs="0" nxsd:style="fixedLength" nxsd:length="10" nxsd:padStyle="tail" nxsd:paddedBy=" " />
      <xsd:element name="DOB" type="xsd:string" minOccurs="0" nxsd:style="fixedLength" nxsd:length="8" nxsd:padStyle="tail" nxsd:paddedBy=" " />
      <xsd:element name="joinDate" type="xsd:string" minOccurs="0" nxsd:style="fixedLength" nxsd:length="8" nxsd:padStyle="tail" nxsd:paddedBy=" " />
      <xsd:element name="joinEndDate" type="xsd:string" minOccurs="0" nxsd:style="fixedLength" nxsd:length="8" nxsd:padStyle="tail" nxsd:paddedBy=" " />
      <xsd:element name="Filler" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" />
    </xsd:sequence>
  </xsd:complexType>


  <xsd:complexType name="RequestType">
    <xsd:sequence>
      <xsd:element name="Header" type="tns:HeaderType" minOccurs="0" />
      <xsd:element name="Details" type="tns:DetailsType" maxOccurs="unbounded"    nxsd:style="array" nxsd:cellSeparatedBy="" nxsd:arrayTerminatedBy="1111111111" />
      <xsd:element name="Trailer" type="tns:TrailerType" minOccurs="0" />
    </xsd:sequence>
  </xsd:complexType>


  <xsd:complexType name="HeaderType">
    <xsd:sequence>
      <xsd:element name="HeaderID" type="xsd:string" nxsd:style="fixedLength" nxsd:length="10" />
      <xsd:element name="FileDate" type="xsd:string" nxsd:style="fixedLength" nxsd:length="8"                       nxsd:padStyle="tail" nxsd:paddedBy=" " />
 <xsd:element name="HeaderFiller" type="xsd:string" nxsd:style="terminated"            nxsd:terminatedBy="${eol}" />
    </xsd:sequence>
  </xsd:complexType>


  <xsd:complexType name="TrailerType">
    <xsd:sequence>
      <xsd:element name="TrailerID" type="xsd:string" nxsd:style="fixedLength" nxsd:length="10" nxsd:padStyle="tail" nxsd:paddedBy=" " nxsd:prefixWith="1111111111" />
      <xsd:element name="TotalEmpRecords" type="xsd:string" nxsd:style="fixedLength" nxsd:length="8" nxsd:padStyle="tail" nxsd:paddedBy=" " />
      <xsd:element name="TrailerFiller" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" />
    </xsd:sequence>
  </xsd:complexType>


</xsd:schema>     

Happy coding ....!

Friday, 2 August 2013

Creating Native Schema Files with the Native Format Builder Wizard

Defining Complex Condition in choice Condition
Using Native format builder we can pick different kind of records from flat file.
Sample file:

016404460A  TCHAPRASTE VASKEN          M19480901016404460D 120A86   200305      201308             967465840040 E
016463006ABARLLESLEYAF19541129016463006P120B1161 2013012013050005245020130501049000000000{    967459010010  0001031458310485698TBIDDLE MARILYN JF19450807310485698    120C2361  307322486D  20130320130330              0001282100575470305A  PARK   YOUNG OF19470823575470305P  120D3061 201203 2013033060048    020  0001282324



Native Data Format to Be Translated:


The choiceCondition construct is used along with the conditionValue construct for records that are complex and may have fields delimited by fixed length. The other choiceCondition types available are FixedLength, Variable. The following example is for the variable choiceCondition type.
Native Schema:
<?xml version="1.0" encoding="UTF-8" ?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
            xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd"
            xmlns:tns="http://TargetNamespace.com/filewrite"
            targetNamespace="http://TargetNamespace.com/filewrite"
            elementFormDefault="qualified"
            attributeFormDefault="unqualified"

            nxsd:version="NXSD"
            nxsd:stream="chars"
            nxsd:encoding="US-ASCII"
> 


  <xsd:element name="Root-Element">
    <xsd:complexType>
      <xsd:choice minOccurs="0" maxOccurs="unbounded" nxsd:choiceCondition="${X}" nxsd:lookAhead="75" nxsd:scanLength="1" nxsd:assignTo="${X}">
        <xsd:element name="RecordA" type="tns:RecordIdentificationCodeAType" nxsd:conditionValue="A" />
        <xsd:element name="RecordB" type="tns:RecordIdentificationCodeBType" nxsd:conditionValue="B" />
                                <xsd:element name="RecordC" type="tns:RecordIdentificationCodeCType" nxsd:conditionValue="C" />
                                <xsd:element name="RecordD" type="tns:RecordIdentificationCodeDType" nxsd:conditionValue="D" />
                               
      </xsd:choice>
    </xsd:complexType>
  </xsd:element>

<xsd:complexType name="RecordIdentificationCodeAType">
    <xsd:sequence>
      --------------------
---------------------------------
</xsd: sequence>
</xsd:complexType>
<xsd:complexType name="RecordIdentificationCodeBType">
    <xsd:sequence>
      --------------------
---------------------------------
</xsd: sequence>
</xsd:complexType>
<xsd:complexType name="RecordIdentificationCodeCType">
    <xsd:sequence>
      --------------------
---------------------------------
</xsd: sequence>
</xsd:complexType>
<xsd:complexType name="RecordIdentificationCodeDType">
    <xsd:sequence>
      --------------------
---------------------------------
</xsd: sequence>
</xsd:complexType>

Translated XML Using Native Schema:

<?xml version = '1.0' encoding = 'UTF-8'?>
<Root-Element xmlns="http://TargetNamespace.com/filewrite">
   <RecordA></RecordB>
   <RecordB></RecordB>
   <RecordC></RecordC>
   <RecordD></RecordD>

</Root-Element>

Saturday, 12 January 2013

E-Business Suite Integration Components




E-Business Suite Integration Components

It is important to understand different integration components available within EBS to make informed decision about using one or more for your SOA integration project. Selecting one or more of them depends upon the requirements and the interaction pattern determined to be best fit for the service oriented architecture based integration.
Following are the integration mechanisms available within e-Business suite.

Oracle XML Gateway:

E-Business Suite utilizes the Oracle Workflow Business Event System to support event-based XML message creation and consumption. It can consume events raised by the Oracle E-Business Suite and can subscribes to inbound events for processing. It can be leveraged for Business-to-Business (B2B) and Application-to-Application (A2A) integration scenarios. Majority of messages delivered with the Oracle E-Business Suite are mapped using the Open Application Group (OAG) standard.

Business Events:

The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems. There are more than 1000 built in events with in EBS that can be leveraged for event-based integration of business processes.

Concurrent Programs:

A concurrent program is an instance of an execution file. Concurrent programs use a concurrent program executable to locate the correct execution file. Several concurrent programs may use the same execution file to perform their specific tasks, each having different parameter defaults.

Interface Tables:

Interface tables are intermediate tables into which the data is inserted first. Once the data gets inserted into the interface tables, the data is validated, and then transferred to the base tables. Base tables are real application tables that reside in the application database. The data that resides in the interface tables is transferred to the base tables using concurrent programs. Interface views provide a way to retrieve data from Oracle Applications. By using views, you can get synchronous data access to Oracle Applications.

PL/SQL APIs:

These are stored procedures that enable you to insert and update data in Oracle Applications.
Oracle e-Commerce (EDI) Gateway: Oracle e-Commerce Gateway provides a common, standards-based approach for Electronic Data Interchange (EDI) integration between Oracle Applications and third party applications. It is the EDI integration enabler for Oracle Applications.






Monday, 7 January 2013

UDDI clients and UDDI implementations

UDDI clients and UDDI implementations

Oracle Application Integration Architecture 11g Installation Guide


Introduction to AIA Foundation Pack:

         The Oracle Application Integration Architecture (AIA) Foundation Pack: Development Guide defines in detail how you can use the Oracle AIA Foundation Pack to conceptualize AIA projects and, using the AIA FP Project Lifecycle Management application, implement a solution conforming to the AIA FP in a structured fashion based on a functional design document. You can use this guide to implement additional functionalities in the form of new services extending the AIA Process Integration Packs (PIP) functionalities.
Oracle Application Integration Architecture (AIA FP) is a complete integration solution for orchestrating agile, user-centric, business processes across enterprise applications. AIA FP offers prebuilt solutions at the data, process, and user interface levels delivering a complete process solution to business end users. All of the AIA FP components are designed to work together in a mix-and-match fashion. They are built for configurability, ultimately helping to lower IT costs and the burden of building, extending, and maintaining integrations.
Powered by Oracle Fusion Middleware, AIA FP enables organizations to utilize the applications of their choice and create Composite Business Processes (CBPs) following these guiding principles that define the ground rules for development, maintenance, and usage of a service-oriented architecture (SOA):
1. Reuse, granularity, modularity, compose ability, componentization, and interoperability.
2. Standards-compliance (both common and industry-specific).
3. Service identification and categorization, provisioning and delivery, and monitoring and tracking.
With AIA FP, business processes can be engineered according to the following types of integrations:
1.       User Interface Integration
                A User Interface Integration connects disparate systems to provide a unified view to the user. It is a single view to many heterogeneous systems that are integrated at the user-interface level. It significantly increases the productivity to the end user by eliminating the need for the user to toggle back and forth between these systems. For example, in the Siebel Order Capture application, the order configuration capability of the Oracle E-Business Suite application has been embedded. Although this approach provides a unified approach to the users, there is no aggregation of data at the applications level.
2. Data Integration
             A Data Integration connects at the logical level of data, making the same data available to more than one application. This is accomplished by relying upon database technologies. This type of integration is a good candidate when there is a minimal amount of business logic to be reused across applications.
2.       Functional Integration
         A Functional Integration connects applications at the business-logic layer. This type of integration is a good candidate when there is a need for reuse of functionality, such as business logic or processing.

4. Process Integration

          A Process Integration is primarily accomplished by exposing object interfaces that can be consumed by other systems, by using message-oriented middleware (MOM) systems to send messages to the destinations, or by exposing web service interfaces that can be consumed by the clients.

1. Oracle AIA FP Installation on windows 7 64 bit:

1.1. Go to AIA FP Patch Setup file location inside we have win64bit click on setup file.


 1.2. Next enter JDK location click on enter.

 
              
 1.3. Welcome Screen click on next.

1.4. Create AIA FP Home folder in middleware.



1.5. Select AIA Home location and give AIA Instance name, select JDK location click on next.

1.6. Enter SOA Server Details click on next.

1.7. Next we need start the Node manager from web logic server.

1.8. Start the Node Manager.


1.9. Node manager running on 5556 port.


1.10. Server Validation ok click on next otherwise retry.






1.11. Next enter DB details for AIA FP Schemas.



1.12. Enter MDS details.


1.13. Click on next this screen is optional if you have OER provide details.

1.14. Click on install button.


2. Configuration progress


3. End Processes


Note: SOA Server Shut Down itself .after few minutes it will restart otherwise we need restart manual.
Any Java related Process are running close the process remove lok files and temp, cache from our servers.
Note: Don’t close javaw.exe..Because this is related to our setup file.
3.1. AIA FP Configuration success.

4.1 we can open AIA FP Console from below link.
Login details are same as em console.



4.2 AIA FP Home Page:


5. AIA FP Adapter Starts from Console:



SOA Domain Configured in development mode we need to start the AIA FP Adapters manually.
Go to Admin Console -> click on Deployments ->start AIA FP related Adapters (AIA_AQ, AIA_JMS, AIA_DB, AIA_OracleApps).

6. AIA Foundation Pack Service Constructor for JDeveloper 11.1.1.6.0:

          
       This extension creates Application Integration Architecture (AIA FP) Service Constructor to create an AIA FP based service component project. This extension is an online JDeveloper update. Start JDeveloper. From the menu choose Help > Check for Updates. In the Update Wizard, select Search Update Centers and ensure the first and second options are checked (screenshot). Then ensure that Oracle AIA Foundation Pack Service Constructor is checked.
Step1: Open Oracle JDeveloper go to help ->click on check for Updates.

Step2: Select oracle fusion updates and oracle extensions click on next.

Step3: Select AIA FP Service Constructor click on next.

Step4: Download start for AIA FP extension file.

Step5: Click on finish.

7. Oracle AIA FP reference links:


Download Oracle AIA foundation Pack patch setup from below link:
http://www.oracle.com/technetwork/middleware/foundation-pack/downloads/fpdownloads-152617.html
Download Oracle AIA foundation Pack reference guide from below link:
http://www.oracle.com/technetwork/middleware/foundation-pack/documentation/index.html#111160

Oracle Opatch utility 12c

 Hi Blog Viewers, This post will describes the how to apply single or multiple patches at a time. Prerequisites : Set the Oracle Home and Op...