Oracle Fusion Middleware

Oracle B2B - Part5

2017-03-16T03:15:00.000-07:00

Oracle B2B - Part5

Steps to Import ecs and xsd files into B2B Console

Visit Oracle B2B-Part4 to understand how to export B2B definition documents from Oracle B2B Editor.

In This post, I want to show you, how to import B2B document definitions into B2BConsole.

Step1: login into SB Console.

http://<host name>:<soa port number>/b2bconsole

Step2: click on Administration --> Document tab --> EDI_X12 --> New Version

Provide details as shown in below image. We have to provide document version number.

In my case version number is 4010 and then click save button.

Step3:

Now we need to create document type. like 850, 855 860 etc.

In my case document type is 850.

Along with document type we need to supply functional group identifier as shown in below image.

ex: 850 functional group identifier is "PO"

860 functional group identifier is "POChange"

Step4:

Now we need to upload .ecs and .xsd files into B2B console

NOTE: Repeat above steps to import multiple B2B documents.

Hope you enjoy your learning with my blog.

Oracle B2B - Part4

2016-12-12T06:29:00.001-08:00

Oracle B2B - Part4

Steps to Configure Oracle B2B Specification \ Document Definition

In this post, I want to explain steps to create Oracle B2B Specification.
Oracle B2B Specification contains two documents. They are ".ecs" and ".xsd" files.
Follow below steps to configure EDI X12 4010 850 (ORDERS) document definition.

Visit Oracle B2B - Part3 to understand how to install Oracle Document Editor.

1. Download and Install Oracle Document Editor.
2. start document editor.
Double click on below file.
"<installation folder>\Oracle\Oracle Document Editor\SpecBuilder.exe"
3. In Document editor --> Start Page --> Click on New Guideline

4. In pop up, we have to select proper B2B specification. As per our requirement, we have to select EDI specification --> X12 --> V4010 --> 850 Document Specification --> Click Finish button.

5. We have to do required changes in EDI document segments.

6. Save the B2B Definitions Documents (.ecs is the extension)

7. Now we need to generate .xsd file with the help of ".ecs" file.

open .ecs file --> File Menu --> Export (NOTE: make sure .ecs file open in Document Editor)

Now we can see .ecs and .xsd files.

We can use these two documents in B2B console to define trading partners and agreements and in Oracle SOA projects to process B2B XML format documents. Will discuss, about this in upcoming posts.

Oracle B2B - Part3

2016-12-08T06:05:00.003-08:00

Oracle B2B - Part3

Oracle Document Editor Installation

Please go to Oracle B2B - Part2 before reading Part3

1. Go to this URL to download binaries for Oracle Document Editor.
2. Login with oracle user and password and accept required license.

3. Choose operating system.

4. Expand "Recommended Install Process".

5. Now download required binaries as shown in below image.

6. Now, we can see 4 zip files in downloads folder.

NOTE: B2B Document Editor setup required binaries are packed into four parts. Each part has set of B2B document specifications. If we install all four parts then all specifications are available in Document Editor IDE. But we should act as required, no need to install all B2B Document specifications.

7. Unzip each zip file into one individual folder.

NOTE:

9. Open disk1 folder --> double click on "install" file.

10. we have two options to install document editor.

a. Install document editor with required B2B document specifications.

b. In only document editor and later we can install required B2B document specifications.

NOTE: In this post, I want to show you how to install document editor and required B2B document specifications individually.

11. Select proper folders to install B2B Editor and B2B Standards. We can select user defined folder for this installation.

12. Here we need to select what are the specifications we want to install. Select the checkbox "Perform setup operation in Silent mode".

13. Uncheck Standards option if you don't want to install all B2B specification with the document editor.

NOTE: if you don't select any specification, later you need to install required B2B document specification.

14. Run the wizard up to finish button.

15. Now we need to install required B2B Document Specifications by following below steps.

I want to install X12 documents. X12 documents available in disk4 folder. Go to disk4 folder (disk4\Standards\X12) --> run the installer file to install X12 documents.

16. Start Oracle Document Editor (C:\B2B\Oracle\Oracle Document Editor\SpecBuilder.exe)

Oracle B2B - Part2

2016-12-07T23:19:00.000-08:00

Oracle B2B

Part2

Please go to Oracle B2B - Part1 before reading Part2

In this post, I want to introduce few sample B2B documents from different standards.
As we discussed in B2B Part1, there are different standards are in use for different B2B transactions.

Ex: Purchase Order will be called and identified as 850 in EDI X12 standard, ORDERS in EDIFACT standard and 3A4 in RosettaNet standard.

Few more examples in below table.

Reference:
Go through below reference list to find more B2B standards / documents.
EDI X12 complete list of transactions
EDIFACT complete list of transactions
RosettaNet complete list of transactions

Few Important points to be noted.

B2B system will validate and convert B2B standard document into XML format and XML format to B2B standard documents.
B2B standards supports NonXml and XML format.

Ex: EDI X12 and EDIFACT B2B document will be in NonXML format and RosettaNet B2B documents are in XML format. Here i am providing three examples how purchase order looks in three differentt standards.

NOTE: all the values in below documents are just dummy fields.

Sample EDI X12, 004010 version 850(Purchase Document) Standard:

ISA*00* *00* *08*9251750000 *08*1234567890 *030627*1304*U*00401*000001403*0*P*>~
GS*PO*8019721193*1234567890*20030627*1304*1403*X*004010~
ST*850*01403001~
BEG*00*SA*548177**20030627~                           
REF*AN*547794~
PER*BD*JOHN JONES*TE*5552225555~
FOB*PB~
DTM*002*20030705~
DTM*118*20030704~
PKG******01~
TD5****H*OUR CR/T~
N9*AH*548177~
MSG*THIS PURCHASE ORDER IS SUBJECT TO THE SAME TERMS AND~
MSG*CONDITIONS AS SAFEWAY PURCHASE ORDER FORM 1030~
MSG*PICKUP NO. E450562~
N1*ST*SAFEWAY INC*9*0091372092527~
N2*Tracy Produce~
N3*16900 West Schulte Road~
N4*Tracy*CA*95376~
N1*BT*SAFEWAY INC*9*0091372091700~
N2*NATIONAL SERVICES CENTER~
N3*P.O. BOX 29093~
N4*PHOENIX*AZ*85038~
N1*VN*BEST SUPPLIER INC.*9*1234567890000~
N3*P.O. BOX 11111~
N4*LOS ALAMITOS*CA*90001~
PO1**10*CA*12.5**UA*042040304101*IN*20403041*VN*22222~ 
CTP*RS*FCP*12.5~
PID*F*08***ITEM DESCRIPTION 1/10 LB~
SAC*A*B280***20.00***2.00****02~
CTT*1**120*LB~
SE*30*01403001~
GE*1*1403~
IEA*1*000001403~

Sample EDIFACT, 97A version ORDERS (Purchase Document) Standard:

UNA:+.? '
UNB+UNOA:1+IRONWARE:ZZ+098533326:ZZ+011107:1500+186'
UNH+72+ORDERS:D:97A:UN'
BGM+220+123350+9'
DTM+4:20011107:102'
RFF+CT:97.8400.1734V'
NAD+DP+T01626003+++Hardware BV:Coal Lane+Bradford+Yorkshire+BD9 1SJ'
CTA+PD+:Karen Smith'
COM+030-567891:TE'
CUX+2:USD:9'
PAT+1++5:1:CD:45'
LIN+1++STU62001LW-K:BP'
IMD++3+:::SEAGATE VIPER EXT LVD 200G ULTRIUM'
QTY+21:3:EA'
DTM+2:20011108:102'
PRI+INF:3999'
TDT+20++++EXEL GLOBAL LOGIS:172:92'
SCC+1'
QTY+113:3:EA'
DTM+2:20011108:102'
LIN+2++STU42001LW-K:BP'
IMD++3+:::SEAGATE VIPER INT LVD 200G ULTRIUM?+'
QTY+21:2:EA'
DTM+2:20011108:102'
PRI+INF:3799'
TDT+20++++EXEL GLOBAL LOGIS:172:92'
SCC+1'
QTY+113:2:EA'
DTM+2:20011108:102'
LIN+3++STUL620001LW-K:BP'
IMD++3+:::SEAGATE VIPER EXT LVD ULTRIUM1 11CA'
QTY+21:1:EA'
DTM+2:20011108:102'
PRI+INF:7099'
TDT+20++++EXEL GLOBAL LOGIS:172:92'
SCC+1'
QTY+113:1:EA'
DTM+2:20011108:102'
LIN+4++STUQ:BP'
IMD++3+:::SEA AUTOLOADER RACKMOUNT KIT 5U'
QTY+21:1:EA'
DTM+2:20011108:102'
PRI+INF:379'
TDT+20++++EXEL GLOBAL LOGIS:172:92'
SCC+1'
QTY+113:1:EA'
DTM+2:20011108:102'
UNS+S'
UNT+41+72'
UNZ+1+186'

Sample RosettaNet, V0200 version 3A4 (Purchase Document) Standard:

<pip3a4purchaseorderrequest>
  <fromrole>
    <partnerroledescription>
      <contactinformation>
        <physicaladdress>
          <addressline1>
            <freeformtext>26650 Park Way</FreeFormText>
          </addressLine1>
          <addressline3>
            <freeformtext>.</FreeFormText>
          </addressLine3>
          <cityname>
            <freeformtext>abc</FreeFormText>
          </cityName>
          <globalcountrycode>US</GlobalCountryCode>
          <nationalpostalcode>92656</NationalPostalCode>
          <regionname>
            <freeformtext>CA</FreeFormText>
          </regionName>
        </PhysicalAddress>
      </ContactInformation>
      <globalpartnerroleclassificationcode>Buyer</GlobalPartnerRoleClassificationCode>
      <partnerdescription>
        <businessdescription>
          <globalbusinessidentifier>800000123</GlobalBusinessIdentifier>
          <globalsupplychaincode>Electronic Components</GlobalSupplyChainCode>
        </BusinessDescription>
        <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
      </PartnerDescription>
    </PartnerRoleDescription>
  </fromRole>
  <globaldocumentfunctioncode>Request</GlobalDocumentFunctionCode>
  <purchaseorder>
    <accountdescription>
      <accountname>
        <freeformtext>abc Corporation</FreeFormText>
      </accountName>
      <billto>
        <partnerroledescription>
          <contactinformation>
            <telephonenumber>
              <communicationsnumber>3000001111</CommunicationsNumber>
            </telephoneNumber>
            <physicaladdress>
              <addressline1>
                <freeformtext>MNO LTD.</FreeFormText>
              </addressLine1>
              <addressline2>
                <freeformtext>Unit 274,Blanchardstown Corp Park 2</FreeFormText>
              </addressLine2>
              <addressline3>
                <freeformtext>.</FreeFormText>
              </addressLine3>
              <cityname>
                <freeformtext>Ballycoolin</FreeFormText>
              </cityName>
              <globalcountrycode>IE</GlobalCountryCode>
              <nationalpostalcode>00015</NationalPostalCode>
            </PhysicalAddress>
          </ContactInformation>
          <globalpartnerroleclassificationcode>Buyer</GlobalPartnerRoleClassificationCode>
          <partnerdescription>
            <businessdescription>
              <globalbusinessidentifier>808556617</GlobalBusinessIdentifier>
              <businessname>
                <freeformtext>IRE</FreeFormText>
              </businessName>
            </BusinessDescription>
            <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
          </PartnerDescription>
        </PartnerRoleDescription>
      </billTo>
    </AccountDescription>
    <comments>
      <freeformtext>1701</FreeFormText>
    </comments>
    <documentreference>
      <datetimestamp>20150629T120000</DateTimeStamp>
      <globaldocumentreferencetypecode>Purchase Order</GlobalDocumentReferenceTypeCode>
      <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
    </DocumentReference>
    <globalpurchaseordertypecode>Standard</GlobalPurchaseOrderTypeCode>
    <isdropship>
      <affirmationindicator>No</AffirmationIndicator>
    </isDropShip>
    <ordershippinginformation>
      <carrierinformation>
        <globalcarriercode>0000</GlobalCarrierCode>
      </CarrierInformation>
    </OrderShippingInformation>
    <productlineitem>
      <comments>
        <freeformtext>T/A, QLE2562-HP-SP</FreeFormText>
      </comments>
      <documentlinereference>
        <globaldocumentreferencetypecode>Purchase Order</GlobalDocumentReferenceTypeCode>
        <linenumber>5239192</LineNumber>
        <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <documentlinereference>
        <globaldocumentreferencetypecode>LOB</GlobalDocumentReferenceTypeCode>
        <proprietarydocumentidentifier>CSG</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
      <isdropship>
        <affirmationindicator>No</AffirmationIndicator>
      </isDropShip>
      <linenumber>1</LineNumber>
      <orderquantity>
        <requestedquantity>
          <productquantity>140</ProductQuantity>
        </requestedQuantity>
      </OrderQuantity>
      <productidentification>
        <partnerproductidentification>
          <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
          <proprietaryproductidentifier>PX2811103-20</ProprietaryProductIdentifier>
        </PartnerProductIdentification>
      </ProductIdentification>
      <productsublineitem>
        <comments>
          <freeformtext>5020379</FreeFormText>
        </comments>
        <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
        <isdropship>
          <affirmationindicator>No</AffirmationIndicator>
        </isDropShip>
        <orderquantity>
          <requestedquantity>
            <productquantity>140</ProductQuantity>
          </requestedQuantity>
        </OrderQuantity>
        <requestedevent>
          <transportationevent>
            <datestamp>20150925Z</DateStamp>
            <globaltransporteventcode>Ship</GlobalTransportEventCode>
          </TransportationEvent>
        </requestedEvent>
        <shipto>
          <partnerdescription>
            <businessdescription>
              <businessname>
                <freeformtext>50792-61</FreeFormText>
              </businessName>
            </BusinessDescription>
          </PartnerDescription>
        </shipTo>
        <sublineitem>
          <linenumber>1</LineNumber>
        </subLineItem>
      </ProductSubLineItem>
      <requestedevent>
        <transportationevent>
          <datestamp>20150925Z</DateStamp>
          <globaltransporteventcode>Ship</GlobalTransportEventCode>
        </TransportationEvent>
      </requestedEvent>
      <requestedshipfrom>
        <physicaladdress>
          <globallocationidentifier>595101577HB61</GlobalLocationIdentifier>
        </PhysicalAddress>
      </requestedShipFrom>
      <requestedunitprice>
        <financialamount>
          <globalcurrencycode>USD</GlobalCurrencyCode>
          <monetaryamount>39.55</MonetaryAmount>
        </FinancialAmount>
      </requestedUnitPrice>
    </ProductLineItem>
    <productlineitem>
      <comments>
        <freeformtext>T/A, QLE2560-HP-SP</FreeFormText>
      </comments>
      <documentlinereference>
        <globaldocumentreferencetypecode>Purchase Order</GlobalDocumentReferenceTypeCode>
        <linenumber>5239193</LineNumber>
        <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <documentlinereference>
        <globaldocumentreferencetypecode>LOB</GlobalDocumentReferenceTypeCode>
        <proprietarydocumentidentifier>CSG</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
      <isdropship>
        <affirmationindicator>No</AffirmationIndicator>
      </isDropShip>
      <linenumber>2</LineNumber>
      <orderquantity>
        <requestedquantity>
          <productquantity>100</ProductQuantity>
        </requestedQuantity>
      </OrderQuantity>
      <productidentification>
        <partnerproductidentification>
          <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
          <proprietaryproductidentifier>PX2811103-21</ProprietaryProductIdentifier>
        </PartnerProductIdentification>
      </ProductIdentification>
      <productsublineitem>
        <comments>
          <freeformtext>5020380</FreeFormText>
        </comments>
        <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
        <isdropship>
          <affirmationindicator>No</AffirmationIndicator>
        </isDropShip>
        <orderquantity>
          <requestedquantity>
            <productquantity>100</ProductQuantity>
          </requestedQuantity>
        </OrderQuantity>
        <requestedevent>
          <transportationevent>
            <datestamp>20150925Z</DateStamp>
            <globaltransporteventcode>Ship</GlobalTransportEventCode>
          </TransportationEvent>
        </requestedEvent>
        <shipto>
          <partnerdescription>
            <businessdescription>
              <businessname>
                <freeformtext>50792-61</FreeFormText>
              </businessName>
            </BusinessDescription>
          </PartnerDescription>
        </shipTo>
        <sublineitem>
          <linenumber>1</LineNumber>
        </subLineItem>
      </ProductSubLineItem>
      <requestedevent>
        <transportationevent>
          <datestamp>20150925Z</DateStamp>
          <globaltransporteventcode>Ship</GlobalTransportEventCode>
        </TransportationEvent>
      </requestedEvent>
      <requestedshipfrom>
        <physicaladdress>
          <globallocationidentifier>595101577HB61</GlobalLocationIdentifier>
        </PhysicalAddress>
      </requestedShipFrom>
      <requestedunitprice>
        <financialamount>
          <globalcurrencycode>USD</GlobalCurrencyCode>
          <monetaryamount>37.75</MonetaryAmount>
        </FinancialAmount>
      </requestedUnitPrice>
    </ProductLineItem>
    <productlineitem>
      <comments>
        <freeformtext>T/A, QLE2560-HP-BK</FreeFormText>
      </comments>
      <documentlinereference>
        <globaldocumentreferencetypecode>Purchase Order</GlobalDocumentReferenceTypeCode>
        <linenumber>5239194</LineNumber>
        <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <documentlinereference>
        <globaldocumentreferencetypecode>LOB</GlobalDocumentReferenceTypeCode>
        <proprietarydocumentidentifier>CSG</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
      <isdropship>
        <affirmationindicator>No</AffirmationIndicator>
      </isDropShip>
      <linenumber>3</LineNumber>
      <orderquantity>
        <requestedquantity>
          <productquantity>300</ProductQuantity>
        </requestedQuantity>
      </OrderQuantity>
      <productidentification>
        <partnerproductidentification>
          <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
          <proprietaryproductidentifier>PX2810303-21</ProprietaryProductIdentifier>
        </PartnerProductIdentification>
      </ProductIdentification>
      <productsublineitem>
        <comments>
          <freeformtext>5020381</FreeFormText>
        </comments>
        <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
        <isdropship>
          <affirmationindicator>No</AffirmationIndicator>
        </isDropShip>
        <orderquantity>
          <requestedquantity>
            <productquantity>300</ProductQuantity>
          </requestedQuantity>
        </OrderQuantity>
        <requestedevent>
          <transportationevent>
            <datestamp>20150925Z</DateStamp>
            <globaltransporteventcode>Ship</GlobalTransportEventCode>
          </TransportationEvent>
        </requestedEvent>
        <shipto>
          <partnerdescription>
            <businessdescription>
              <businessname>
                <freeformtext>50792-61</FreeFormText>
              </businessName>
            </BusinessDescription>
          </PartnerDescription>
        </shipTo>
        <sublineitem>
          <linenumber>1</LineNumber>
        </subLineItem>
      </ProductSubLineItem>
      <requestedevent>
        <transportationevent>
          <datestamp>20150925Z</DateStamp>
          <globaltransporteventcode>Ship</GlobalTransportEventCode>
        </TransportationEvent>
      </requestedEvent>
      <requestedshipfrom>
        <physicaladdress>
          <globallocationidentifier>595101577HB61</GlobalLocationIdentifier>
        </PhysicalAddress>
      </requestedShipFrom>
      <requestedunitprice>
        <financialamount>
          <globalcurrencycode>USD</GlobalCurrencyCode>
          <monetaryamount>36.66</MonetaryAmount>
        </FinancialAmount>
      </requestedUnitPrice>
    </ProductLineItem>
    <productlineitem>
      <comments>
        <freeformtext>T/A, QLE2562-HP-SP</FreeFormText>
      </comments>
      <documentlinereference>
        <globaldocumentreferencetypecode>Purchase Order</GlobalDocumentReferenceTypeCode>
        <linenumber>5239195</LineNumber>
        <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <documentlinereference>
        <globaldocumentreferencetypecode>LOB</GlobalDocumentReferenceTypeCode>
        <proprietarydocumentidentifier>CSG</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
      <isdropship>
        <affirmationindicator>No</AffirmationIndicator>
      </isDropShip>
      <linenumber>4</LineNumber>
      <orderquantity>
        <requestedquantity>
          <productquantity>400</ProductQuantity>
        </requestedQuantity>
      </OrderQuantity>
      <productidentification>
        <partnerproductidentification>
          <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
          <proprietaryproductidentifier>PX2811103-20</ProprietaryProductIdentifier>
        </PartnerProductIdentification>
      </ProductIdentification>
      <productsublineitem>
        <comments>
          <freeformtext>5020382</FreeFormText>
        </comments>
        <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
        <isdropship>
          <affirmationindicator>No</AffirmationIndicator>
        </isDropShip>
        <orderquantity>
          <requestedquantity>
            <productquantity>400</ProductQuantity>
          </requestedQuantity>
        </OrderQuantity>
        <requestedevent>
          <transportationevent>
            <datestamp>20150925Z</DateStamp>
            <globaltransporteventcode>Ship</GlobalTransportEventCode>
          </TransportationEvent>
        </requestedEvent>
        <shipto>
          <partnerdescription>
            <businessdescription>
              <businessname>
                <freeformtext>50792-61</FreeFormText>
              </businessName>
            </BusinessDescription>
          </PartnerDescription>
        </shipTo>
        <sublineitem>
          <linenumber>1</LineNumber>
        </subLineItem>
      </ProductSubLineItem>
      <requestedevent>
        <transportationevent>
          <datestamp>20150925Z</DateStamp>
          <globaltransporteventcode>Ship</GlobalTransportEventCode>
        </TransportationEvent>
      </requestedEvent>
      <requestedshipfrom>
        <physicaladdress>
          <globallocationidentifier>595101577HB61</GlobalLocationIdentifier>
        </PhysicalAddress>
      </requestedShipFrom>
      <requestedunitprice>
        <financialamount>
          <globalcurrencycode>USD</GlobalCurrencyCode>
          <monetaryamount>39.55</MonetaryAmount>
        </FinancialAmount>
      </requestedUnitPrice>
    </ProductLineItem>
    <productlineitem>
      <comments>
        <freeformtext>T/A, QLE2560-HP-SP</FreeFormText>
      </comments>
      <documentlinereference>
        <globaldocumentreferencetypecode>Purchase Order</GlobalDocumentReferenceTypeCode>
        <linenumber>5239196</LineNumber>
        <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <documentlinereference>
        <globaldocumentreferencetypecode>LOB</GlobalDocumentReferenceTypeCode>
        <proprietarydocumentidentifier>CSG</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
      <isdropship>
        <affirmationindicator>No</AffirmationIndicator>
      </isDropShip>
      <linenumber>5</LineNumber>
      <orderquantity>
        <requestedquantity>
          <productquantity>80</ProductQuantity>
        </requestedQuantity>
      </OrderQuantity>
      <productidentification>
        <partnerproductidentification>
          <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
          <proprietaryproductidentifier>PX2811103-21</ProprietaryProductIdentifier>
        </PartnerProductIdentification>
      </ProductIdentification>
      <productsublineitem>
        <comments>
          <freeformtext>5020383</FreeFormText>
        </comments>
        <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
        <isdropship>
          <affirmationindicator>No</AffirmationIndicator>
        </isDropShip>
        <orderquantity>
          <requestedquantity>
            <productquantity>80</ProductQuantity>
          </requestedQuantity>
        </OrderQuantity>
        <requestedevent>
          <transportationevent>
            <datestamp>20150925Z</DateStamp>
            <globaltransporteventcode>Ship</GlobalTransportEventCode>
          </TransportationEvent>
        </requestedEvent>
        <shipto>
          <partnerdescription>
            <businessdescription>
              <businessname>
                <freeformtext>50792-61</FreeFormText>
              </businessName>
            </BusinessDescription>
          </PartnerDescription>
        </shipTo>
        <sublineitem>
          <linenumber>1</LineNumber>
        </subLineItem>
      </ProductSubLineItem>
      <requestedevent>
        <transportationevent>
          <datestamp>20150925Z</DateStamp>
          <globaltransporteventcode>Ship</GlobalTransportEventCode>
        </TransportationEvent>
      </requestedEvent>
      <requestedshipfrom>
        <physicaladdress>
          <globallocationidentifier>595101577HB61</GlobalLocationIdentifier>
        </PhysicalAddress>
      </requestedShipFrom>
      <requestedunitprice>
        <financialamount>
          <globalcurrencycode>USD</GlobalCurrencyCode>
          <monetaryamount>37.75</MonetaryAmount>
        </FinancialAmount>
      </requestedUnitPrice>
    </ProductLineItem>
    <productlineitem>
      <comments>
        <freeformtext>T/A, QMH2562-HP-SP</FreeFormText>
      </comments>
      <documentlinereference>
        <globaldocumentreferencetypecode>Purchase Order</GlobalDocumentReferenceTypeCode>
        <linenumber>5239197</LineNumber>
        <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <documentlinereference>
        <globaldocumentreferencetypecode>LOB</GlobalDocumentReferenceTypeCode>
        <proprietarydocumentidentifier>CSG</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
      <isdropship>
        <affirmationindicator>No</AffirmationIndicator>
      </isDropShip>
      <linenumber>6</LineNumber>
      <orderquantity>
        <requestedquantity>
          <productquantity>100</ProductQuantity>
        </requestedQuantity>
      </OrderQuantity>
      <productidentification>
        <partnerproductidentification>
          <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
          <proprietaryproductidentifier>CU0411109-10</ProprietaryProductIdentifier>
        </PartnerProductIdentification>
      </ProductIdentification>
      <productsublineitem>
        <comments>
          <freeformtext>5020384</FreeFormText>
        </comments>
        <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
        <isdropship>
          <affirmationindicator>No</AffirmationIndicator>
        </isDropShip>
        <orderquantity>
          <requestedquantity>
            <productquantity>100</ProductQuantity>
          </requestedQuantity>
        </OrderQuantity>
        <requestedevent>
          <transportationevent>
            <datestamp>20150925Z</DateStamp>
            <globaltransporteventcode>Ship</GlobalTransportEventCode>
          </TransportationEvent>
        </requestedEvent>
        <shipto>
          <partnerdescription>
            <businessdescription>
              <businessname>
                <freeformtext>50792-61</FreeFormText>
              </businessName>
            </BusinessDescription>
          </PartnerDescription>
        </shipTo>
        <sublineitem>
          <linenumber>1</LineNumber>
        </subLineItem>
      </ProductSubLineItem>
      <requestedevent>
        <transportationevent>
          <datestamp>20150925Z</DateStamp>
          <globaltransporteventcode>Ship</GlobalTransportEventCode>
        </TransportationEvent>
      </requestedEvent>
      <requestedshipfrom>
        <physicaladdress>
          <globallocationidentifier>595101577HB61</GlobalLocationIdentifier>
        </PhysicalAddress>
      </requestedShipFrom>
      <requestedunitprice>
        <financialamount>
          <globalcurrencycode>USD</GlobalCurrencyCode>
          <monetaryamount>46.91</MonetaryAmount>
        </FinancialAmount>
      </requestedUnitPrice>
    </ProductLineItem>
    <productlineitem>
      <comments>
        <freeformtext>T/A, QLE2562-HP-BK</FreeFormText>
      </comments>
      <documentlinereference>
        <globaldocumentreferencetypecode>Purchase Order</GlobalDocumentReferenceTypeCode>
        <linenumber>5239198</LineNumber>
        <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <documentlinereference>
        <globaldocumentreferencetypecode>LOB</GlobalDocumentReferenceTypeCode>
        <proprietarydocumentidentifier>CSG</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
      <isdropship>
        <affirmationindicator>No</AffirmationIndicator>
      </isDropShip>
      <linenumber>7</LineNumber>
      <orderquantity>
        <requestedquantity>
          <productquantity>920</ProductQuantity>
        </requestedQuantity>
      </OrderQuantity>
      <productidentification>
        <partnerproductidentification>
          <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
          <proprietaryproductidentifier>PX2810303-20</ProprietaryProductIdentifier>
        </PartnerProductIdentification>
      </ProductIdentification>
      <productsublineitem>
        <comments>
          <freeformtext>5020385</FreeFormText>
        </comments>
        <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
        <isdropship>
          <affirmationindicator>No</AffirmationIndicator>
        </isDropShip>
        <orderquantity>
          <requestedquantity>
            <productquantity>920</ProductQuantity>
          </requestedQuantity>
        </OrderQuantity>
        <requestedevent>
          <transportationevent>
            <datestamp>20150925Z</DateStamp>
            <globaltransporteventcode>Ship</GlobalTransportEventCode>
          </TransportationEvent>
        </requestedEvent>
        <shipto>
          <partnerdescription>
            <businessdescription>
              <businessname>
                <freeformtext>50792-61</FreeFormText>
              </businessName>
            </BusinessDescription>
          </PartnerDescription>
        </shipTo>
        <sublineitem>
          <linenumber>1</LineNumber>
        </subLineItem>
      </ProductSubLineItem>
      <requestedevent>
        <transportationevent>
          <datestamp>20150925Z</DateStamp>
          <globaltransporteventcode>Ship</GlobalTransportEventCode>
        </TransportationEvent>
      </requestedEvent>
      <requestedshipfrom>
        <physicaladdress>
          <globallocationidentifier>595101577HB61</GlobalLocationIdentifier>
        </PhysicalAddress>
      </requestedShipFrom>
      <requestedunitprice>
        <financialamount>
          <globalcurrencycode>USD</GlobalCurrencyCode>
          <monetaryamount>38.46</MonetaryAmount>
        </FinancialAmount>
      </requestedUnitPrice>
    </ProductLineItem>
    <productlineitem>
      <comments>
        <freeformtext>QLE2662-HP-BK</FreeFormText>
      </comments>
      <documentlinereference>
        <globaldocumentreferencetypecode>Purchase Order</GlobalDocumentReferenceTypeCode>
        <linenumber>5239280</LineNumber>
        <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <documentlinereference>
        <globaldocumentreferencetypecode>LOB</GlobalDocumentReferenceTypeCode>
        <proprietarydocumentidentifier>CSG</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
      <isdropship>
        <affirmationindicator>No</AffirmationIndicator>
      </isDropShip>
      <linenumber>8</LineNumber>
      <orderquantity>
        <requestedquantity>
          <productquantity>400</ProductQuantity>
        </requestedQuantity>
      </OrderQuantity>
      <productidentification>
        <partnerproductidentification>
          <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
          <proprietaryproductidentifier>HD8310305-18</ProprietaryProductIdentifier>
        </PartnerProductIdentification>
      </ProductIdentification>
      <productsublineitem>
        <comments>
          <freeformtext>5020467</FreeFormText>
        </comments>
        <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
        <isdropship>
          <affirmationindicator>No</AffirmationIndicator>
        </isDropShip>
        <orderquantity>
          <requestedquantity>
            <productquantity>400</ProductQuantity>
          </requestedQuantity>
        </OrderQuantity>
        <requestedevent>
          <transportationevent>
            <datestamp>20150925Z</DateStamp>
            <globaltransporteventcode>Ship</GlobalTransportEventCode>
          </TransportationEvent>
        </requestedEvent>
        <shipto>
          <partnerdescription>
            <businessdescription>
              <businessname>
                <freeformtext>50792-61</FreeFormText>
              </businessName>
            </BusinessDescription>
          </PartnerDescription>
        </shipTo>
        <sublineitem>
          <linenumber>2</LineNumber>
        </subLineItem>
      </ProductSubLineItem>
      <requestedevent>
        <transportationevent>
          <datestamp>20150925Z</DateStamp>
          <globaltransporteventcode>Ship</GlobalTransportEventCode>
        </TransportationEvent>
      </requestedEvent>
      <requestedshipfrom>
        <physicaladdress>
          <globallocationidentifier>595101577HB61</GlobalLocationIdentifier>
        </PhysicalAddress>
      </requestedShipFrom>
      <requestedunitprice>
        <financialamount>
          <globalcurrencycode>USD</GlobalCurrencyCode>
          <monetaryamount>77.07</MonetaryAmount>
        </FinancialAmount>
      </requestedUnitPrice>
    </ProductLineItem>
    <productlineitem>
      <comments>
        <freeformtext>T/A, QLE2560-HP-SP</FreeFormText>
      </comments>
      <documentlinereference>
        <globaldocumentreferencetypecode>Purchase Order</GlobalDocumentReferenceTypeCode>
        <linenumber>5239281</LineNumber>
        <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <documentlinereference>
        <globaldocumentreferencetypecode>LOB</GlobalDocumentReferenceTypeCode>
        <proprietarydocumentidentifier>CSG</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
      <isdropship>
        <affirmationindicator>No</AffirmationIndicator>
      </isDropShip>
      <linenumber>9</LineNumber>
      <orderquantity>
        <requestedquantity>
          <productquantity>400</ProductQuantity>
        </requestedQuantity>
      </OrderQuantity>
      <productidentification>
        <partnerproductidentification>
          <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
          <proprietaryproductidentifier>PX2811103-21</ProprietaryProductIdentifier>
        </PartnerProductIdentification>
      </ProductIdentification>
      <productsublineitem>
        <comments>
          <freeformtext>5020468</FreeFormText>
        </comments>
        <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
        <isdropship>
          <affirmationindicator>No</AffirmationIndicator>
        </isDropShip>
        <orderquantity>
          <requestedquantity>
            <productquantity>400</ProductQuantity>
          </requestedQuantity>
        </OrderQuantity>
        <requestedevent>
          <transportationevent>
            <datestamp>20150925Z</DateStamp>
            <globaltransporteventcode>Ship</GlobalTransportEventCode>
          </TransportationEvent>
        </requestedEvent>
        <shipto>
          <partnerdescription>
            <businessdescription>
              <businessname>
                <freeformtext>50792-61</FreeFormText>
              </businessName>
            </BusinessDescription>
          </PartnerDescription>
        </shipTo>
        <sublineitem>
          <linenumber>2</LineNumber>
        </subLineItem>
      </ProductSubLineItem>
      <requestedevent>
        <transportationevent>
          <datestamp>20150925Z</DateStamp>
          <globaltransporteventcode>Ship</GlobalTransportEventCode>
        </TransportationEvent>
      </requestedEvent>
      <requestedshipfrom>
        <physicaladdress>
          <globallocationidentifier>595101577HB61</GlobalLocationIdentifier>
        </PhysicalAddress>
      </requestedShipFrom>
      <requestedunitprice>
        <financialamount>
          <globalcurrencycode>USD</GlobalCurrencyCode>
          <monetaryamount>37.75</MonetaryAmount>
        </FinancialAmount>
      </requestedUnitPrice>
    </ProductLineItem>
    <productlineitem>
      <comments>
        <freeformtext>T/A, QLE2562-HP-BK</FreeFormText>
      </comments>
      <documentlinereference>
        <globaldocumentreferencetypecode>Purchase Order</GlobalDocumentReferenceTypeCode>
        <linenumber>5239282</LineNumber>
        <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <documentlinereference>
        <globaldocumentreferencetypecode>LOB</GlobalDocumentReferenceTypeCode>
        <proprietarydocumentidentifier>CSG</ProprietaryDocumentIdentifier>
      </DocumentLineReference>
      <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
      <isdropship>
        <affirmationindicator>No</AffirmationIndicator>
      </isDropShip>
      <linenumber>10</LineNumber>
      <orderquantity>
        <requestedquantity>
          <productquantity>400</ProductQuantity>
        </requestedQuantity>
      </OrderQuantity>
      <productidentification>
        <partnerproductidentification>
          <globalpartnerclassificationcode>Manufacturer</GlobalPartnerClassificationCode>
          <proprietaryproductidentifier>PX2810303-20</ProprietaryProductIdentifier>
        </PartnerProductIdentification>
      </ProductIdentification>
      <productsublineitem>
        <comments>
          <freeformtext>5020469</FreeFormText>
        </comments>
        <globalproductunitofmeasurecode>Each</GlobalProductUnitOfMeasureCode>
        <isdropship>
          <affirmationindicator>No</AffirmationIndicator>
        </isDropShip>
        <orderquantity>
          <requestedquantity>
            <productquantity>400</ProductQuantity>
          </requestedQuantity>
        </OrderQuantity>
        <requestedevent>
          <transportationevent>
            <datestamp>20150925Z</DateStamp>
            <globaltransporteventcode>Ship</GlobalTransportEventCode>
          </TransportationEvent>
        </requestedEvent>
        <shipto>
          <partnerdescription>
            <businessdescription>
              <businessname>
                <freeformtext>50792-61</FreeFormText>
              </businessName>
            </BusinessDescription>
          </PartnerDescription>
        </shipTo>
        <sublineitem>
          <linenumber>2</LineNumber>
        </subLineItem>
      </ProductSubLineItem>
      <requestedevent>
        <transportationevent>
          <datestamp>20150925Z</DateStamp>
          <globaltransporteventcode>Ship</GlobalTransportEventCode>
        </TransportationEvent>
      </requestedEvent>
      <requestedshipfrom>
        <physicaladdress>
          <globallocationidentifier>595101577HB61</GlobalLocationIdentifier>
        </PhysicalAddress>
      </requestedShipFrom>
      <requestedunitprice>
        <financialamount>
          <globalcurrencycode>USD</GlobalCurrencyCode>
          <monetaryamount>38.46</MonetaryAmount>
        </FinancialAmount>
      </requestedUnitPrice>
    </ProductLineItem>
    <requestedshipfrom>
      <physicaladdress>
        <globallocationidentifier>5951015771701</GlobalLocationIdentifier>
      </PhysicalAddress>
    </requestedShipFrom>
    <totalamount>
      <financialamount>
        <globalcurrencycode>USD</GlobalCurrencyCode>
        <monetaryamount>140536.2</MonetaryAmount>
      </FinancialAmount>
    </totalAmount>
  </PurchaseOrder>
  <thisdocumentgenerationdatetime>
    <datetimestamp>20150629T074253.310Z</DateTimeStamp>
  </thisDocumentGenerationDateTime>
  <thisdocumentidentifier>
    <proprietarydocumentidentifier>HSGIHQ000397</ProprietaryDocumentIdentifier>
  </thisDocumentIdentifier>
  <torole>
    <partnerroledescription>
      <contactinformation>
        <physicaladdress>
          <addressline1>
            <freeformtext>5006 Ang Mo Kio Avenue 5,</FreeFormText>
          </addressLine1>
          <addressline2>
            <freeformtext>#05-01/12. TECHplace II,</FreeFormText>
          </addressLine2>
          <addressline3>
            <freeformtext>.</FreeFormText>
          </addressLine3>
          <cityname>
            <freeformtext>Singapore</FreeFormText>
          </cityName>
          <globalcountrycode>SG</GlobalCountryCode>
          <nationalpostalcode>569873</NationalPostalCode>
          <regionname>
            <freeformtext>Singapore</FreeFormText>
          </regionName>
        </PhysicalAddress>
      </ContactInformation>
      <globalpartnerroleclassificationcode>Seller</GlobalPartnerRoleClassificationCode>
      <partnerdescription>
        <businessdescription>
          <globalbusinessidentifier>595101577</GlobalBusinessIdentifier>
          <globalsupplychaincode>Electronic Components</GlobalSupplyChainCode>
        </BusinessDescription>
        <globalpartnerclassificationcode>Contract Manufacturer</GlobalPartnerClassificationCode>
      </PartnerDescription>
    </PartnerRoleDescription>
  </toRole>
</Pip3A4PurchaseOrderRequest>

Oracle B2B - Part1

2016-12-07T01:43:00.002-08:00

Oracle B2B

Part1

In this post, I want to share knowledge required for Oracle B2B learners. I will try to make it as simple as possible with very neutral terminology.

The B2B system helps an Organization who wants to conduct e-business with other organizations like their suppliers and customers. In other words, I can say B2B helps an organization to process O2C and P2P transactions in a standard way. B2B system will use B2B standard documents for inbound or outbound transactions. Here few example B2B documents are EDI X12, EDIFACT, RosettaNet etc.

I will use below scenario to make you understand B2B.

"Dell Inc" is an organization wants to conduct e-business with "Intel Corporation" and "Oracle Corporation".

In Dell point of view, Intel Corporation is a supplier and Oracle Corporation is a customer. So we should have P2P flow between Dell and Intel Corporation and O2C flow between Dell and Oracle Corporation.

Example: Oracle will send a purchase order to Dell Inc to buy 1000 laptops(This is a sale order for Dell). To assemble 1000 laptops, Dell needs 1000 processors. Assume, In Dell warehouse only 500 processors are available. Now Dell will send a PO to Intel for 500 I7-Processors.

Here I want to list few basic keywords which we use regularly in Oracle B2B.

Host Partner
Trading Partner
Trading Partner Agreement
B2B Standards / B2B Document
Listening Channel

Host Partner:

Organization who is conducting e-business is called as Host Partner. In our scenario, Dell Inc will be treated as Host Partner because Dell Inc wants to conduct e-Business with Intel and Oracle.

Trading Partner:

A trading partner is an organization that conducts e-business with other organizations. Intel and Oracle are the Trading Partners in our scenario.

Trading Partner Agreement:

A Trading Partner Agreement (TPA) is defined as a definitive and binding agreement between Host Partner and trading partners and vice-versa. In other words, we can consider TPA is a contract between two business profiles to use a specific message encoding protocol or a specific transport protocol while exchanging B2B message with each other. In agreement, we have to configure the direction of transaction and trading partner identifiers. Without configuring agreements, we can't do any inbound or outbound transaction through B2B system.

As per our scenario, I need to configure two agreements. One with Oracle and other with Intel. Agreement with Oracle which allows Dell to accepts PO's will be treated as INBOUND agreement and agreement with Intel which allows Dell to sends PO's will be treated as OUTBOUND agreement. As per agreement configuration in our B2B, it never sends PO's to Oracle and it never accepts PO's from Intel. So as per agreement configuration transactions will be decided.

B2B Standards / B2B Document:

In e-Business, organizations have to interchange different transactions(purchase order request, purchase order change request, shipment notification, invoice etc). So the data and data format in a transaction should be understandable for both the organizations. ISO, UN/CEFACT, OASIS, OAGi are the recognized standard bodies to write and approve B2B Standards like EDI X12, EDIFACT, RosettaNet etc. Some standards like EDI X12 and EDIFACT are NonXml standards and RosettaNet is an XML standard. Of course, we can define our own standards as per our organization and partners business requirement. There are multiple consortiums formed to make customized B2B standards. RosettaNet is the one example, written by one consortium.

Listening Channel:

Channel is the way to communicate with B2B system. Here we have two types of channels.

External channel : A channel which helps to communicate between trading partner and B2B system.
Internal Channel : A channel which communicates between B2B System and backend systems like any integration systems or ERP systems.

We use channels for inbound and outbound communications.
Channel Ex : File Channel, FTP Channel, JMS, EMail, AQ etc

JCA Adapters Tips & Tricks

2016-11-29T01:33:00.001-08:00

Oracle Fusion Middleware

JCA Adapters Tips & Tricks

In This post, I want to list important JCA adapter properties, which are really helpful in real-time projects.

Assumption: In this post, when I use a word called "CLUSTER", it contains one Admin server and two SOA Managed servers. Two Managed servers which are running, in two physical machines.

File Adapter:

Tip1:

If we are using File polling Adapter in clustered SOA domain then we have to use HA File adapter JNDI (eis/HAFileAdapter).

We should edit one property in HA File adapter JNDI. That is "controlDir" property in HAFile adapter JNDI as shown in below image.

image1(HA File Adapter Properties):

image2(HA File Adapter Properties):

If we don't configure controlDir property, then two SOA managed server will poll one file two times. To avoid duplicate file processing we have to configure controlDir property.

We can expect same behavior and configuration for HA FTP Polling adapter.

NOTE: controlDir property value (path) should be mounted between two physical machines as shared folder.

image3(HA FTP Adapter Properties):

Tip2:

By default File Adapter will read multiple files from inbound folder in one polling.

Actually there is no limit that how many files should be processed in one polling.

If you want to control total number of files to be processed in one polling then we have to set below two properties in JCA file (Open file polling adapter .jca file and manually we have provide these properties).

<property name="SingleThreadModel" value="true"/>

<property name="ThreadCount" value="4"/>

As per the above example, 4 threads will be created and only 4 files will be processed in one polling

`FTP Adapter:`

Tip1:

By default FTP polling adapter will create archive file in local folder of SOA server physical machine. If we want to archive FTP file in FTP location then we have to set below FTP adapter jca property.

NOTE: But we cant set this property in design time(jca file in JDeveloper). It is possible to set only at run time in enterprise manager(jca service adapter properties in EM).

Navigation: develop SOA project by using FTP adapter -->deploy SOA project --> login into EM --> single click on our SOA project --> scroll down dashboard tab --> click on FTP polling adapter --> properties tab -->

a. click add button --> add new property --> "UseRemoteArchive" as "true"

b. fileArchivePath --> path should be available in FTP location.

Database Adapter:

Tip1:

In SOA Clustered environment, if we configure DB polling adapter then we have to enable singletone property in .jca file as below.If we don't configure this property then DB polling adapter(2 SOA managed servers) will try to read duplicate records from source table.

Tip2:

Few important jca properties in DB polling adapter.

Database Rows Per XML Document: <property name="MaxRaiseSize" value="6"/>

Database Rows Per Transaction: <property name="MaxTransactionSize" value="15"/>

DB adapter will not process all records as one unit. DB adapter will debatch table into sub parts with the help of above properties.

"TABLE" will be divided into sub parts, each sub part is called as "TRANSACTIONS"

"TRANSACTION" will be divided into sub parts, each sub part is called as "XML Documents"

Each "XML Document" will be processed as one SOA instance.

If we configure above two properties in a DB polling adapter then we can expect below behaviour.

Ex: Assume, DB Table has 50 records, MaxTransactionSize set as 15 and MaxRaiseSize set as 6.

Now the way of execution is as below.

Table with 50 records will be divided into 4 transactions.

transaction1 has 15 records

transaction2 has 15 records

transaction3 has 15 records

transaction4 has 5 records (observe only 5 records in last transaction)

Now TRANSACTIONS should be divided into XML Documents.

Transaction1 devided into 3 XML Documents.

XML Document1 has 6 records

XML Document2 has 6 records

XML Document3 has 3 records (Observer only 3 records in last XML Document.)

Transaction2 devided into 3 XML Documents.

XML Document1 has 6 records

XML Document2 has 6 records

XML Document3 has 3 records (Observer only 3 records in last XML Document.)

Transaction3 devided into 3 XML Documents.
XML Document1 has 6 records
XML Document2 has 6 records
XML Document3 has 3 records (Observer only 3 records in last XML Document.)

Transaction4 devided into 1 XML Documents.

XML Document1 has 5 records (Observer only 1 XML Document with 5 records.)

Finally, above table will be divided into total 10 sub parts and we are calling these sub parts as XML Documents. As i mentioned above 10 XML Documents will be processed as 10 SOA instances.

NOTE: Here very important point we need to observer. All these 10 SOA instances will be processed parallel in one polling.

If you don't want to process all XML Documents in one polling then we can control processing behavior by setting below property in .jca file.

If Value is 1, it means only one XML Document will be processed in one polling. 10 XML Documents will be processed in 10 sequential polling's.

NOTE: If you like this post or if you have any unresolved jca properties, feel free to comments here.

Testing RightNowCX (Oracle Service Cloud) Using SOAP UI

2016-11-06T10:56:00.001-08:00

Testing RightNowCX (Oracle Service Cloud) Using SOAP UI

Understand "elementFormDefault" and "attributeFormDefault"

2016-11-06T09:22:00.003-08:00

Understand "elementFormDefault" and "attributeFormDefault"

elementFormDefault="qualified"

Here, i am providing an example to create an xsd with elementFormDefault="qualified"

NOTE: observe qualifiers in xml (blue color text).

<?xml version="1.0" encoding="UTF-8"?>
<schema xmlns="http://www.w3.org/2001/XMLSchema"
               targetNamespace="http://example.org/calcSchemaDoc"
               xmlns:tns="http://aimtech.org/calcSchemaDoc"
           elementFormDefault="qualified">
      <element name="response">
            <complexType>
            <sequence>
                  <element name="fieldOne" type="integer"/>
                  <element name="fieldTwo" type="integer"/>
                  <element name="result" type="integer"/>
                  <element name="typeOfOperation" type="string"/>
            </sequence>
            </complexType>
      </element>
</schema>

By Following above XSD if we create a valid XML, then it looks as below
valid XML:
<ns:response xmlns:ns="http://example.org/calcSchemaDoc">
    <ns:fieldOne>100</ns:fieldOne>
    <ns:fieldTwo>200</ns:fieldTwo>
    <ns:result>300</ns:result>
    <ns:typeOfOperation>add</ns:typeOfOperation>
</ns:response>

XPath Requirement:
a) create Xpath to get the value of "fieldTwo" element.
XPath: /ns:response/ns:result/text()
result: 300
*****************************************************************************************************
elementFormDefault="unqualified"

Here, i am providing an example to create an xsd with elementFormDefault="unqualified"

<?xml version="1.0" encoding="UTF-8"?>
<schema xmlns="http://www.w3.org/2001/XMLSchema"
                targetNamespace="http://aimtech.org/calcSchemaDoc"
            xmlns:tns="http://example.org/calcSchemaDoc"
            elementFormDefault="unqualified">
      <element name="response">

            <complexType>
            <sequence>
                  <element name="fieldOne" type="integer"/>
                  <element name="fieldTwo" type="integer"/>
                  <element name="result" type="integer"/>
                  <element name="typeOfOperation" type="string"/>
             </sequence>
            </complexType>      </element>
</schema>

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

<ns:response xmlns:ns="http://example.org/calcSchemaDoc">
    <fieldOne>100</fieldOne>
    <fieldTwo>200</fieldTwo>
    <result>300</result>
    <typeOfOperation>add</typeOfOperation>
</ns:response>
NOTE: No need to use qualifiers in xml sub elements, because as per XSD we set elementFormDefault="unqualified"

XPath Requirement:

a) create Xpath to get the value of "fieldTwo" element.
XPath: /ns:response/result/text()
result: 300

JSON(JavaScript Object Notation)

2016-10-31T07:23:00.001-07:00

JSON(JavaScript Object Notation)

JSON is a syntax for storing and exchanging data.
JSON is an easier-to-use alternative to XML.

JSON Syntax Rules:
    Data is in name/value pairs
    Data is separated by commas
    Curly braces hold objects(note: one xml record can be treated as one json object)
    Square brackets hold arrays

observer below examples to understand how to create JSON documents.
ex1(one object with one data field):
xml:
<firstName>john</firstName>
json:
{ "firstName": "john" }

ex2(one object with two data field):
xml:
<firstName>john</firstName>
<lastName>Doe</lastName>
json:
{"firstName":"John", "lastName":"Doe"}

ex3(one object with three data field):
xml:
<firstName>john</firstName>
<lastName>Doe</lastName>
<middleName>xyz</middleName>
json:
{"firstName":"John", "lastName":"Doe", "middleName":"xyz"}

ex4:
xml:
<employee>
    <firstName>john</firstName>
    <lastName>Doe</lastName>
</employee>
json:
{"employee": {"firstName": "john","lastName": "Doe"}}

ex5(One json object with nested array json objects):
xml:
<employees>
    <emp>
        <firstName>john</firstName>
        <lastName>Doe</lastName>
    </emp>
    <emp>
        <firstName>Anna</firstName>
        <lastName>Smith</lastName>
    </emp>
    <emp>
        <firstName>Peter</firstName>
        <lastName>Jones</lastName>
    </emp>
</employees>
json:
{
"employees": {
                "emp":
                    [
                    {"firstName": "john","lastName": "Doe"},
                    {"firstName": "Anna","lastName": "Smith"},
                    {"firstName": "Peter","lastName": "Jones"}
                    ]
                }
}

ex6(One json object with nested multiple(same and different types) json objects):
xml:
<school>
    <student>
        <sno>101</sno>
        <sName>sai</sName>
    </student>
    <student>
        <sno>101</sno>
        <sName>sai</sName>
    </student>
    <class>
        <std>6</std>
        <section>A</section>
    </class>
</school>
json:
{
"school": {
            "student": [
                            {"sno": "101","sName": "sai"},
                            {"sno": "101","sName": "sai"}
                        ],
            "class": {"std": "6","section": "A"}
            }
}

online tool:
http://www.utilities-online.info/xmltojson/#.VrxfNFJgm0U
use this tool to validate and understand how json is working.

XML vs JSON:
NOTE: XML and JSON both are the data interchange formats accessed over WEB. Both of these formats have their own pros/cons. No one is replacement of other. Use the right tool for the right job.
1. JSON format is lightweight over XML.
2. JSON can contain integers, strings, lists, arrays. XML is just elements and nodes that need to be parsed into integers and so on before it can be consumed.
3. The most important disadvantage of JSON is that the format is very hard to read for humans, and that, of course,    every single comma, quote, and bracket should be in exactly the correct place. While this is also true of XML, JSON’s welter of complicated-looking syntax, like the }}]} at the end of the data snippet, may frighten the newbies and make for complicated debugging.
4. Serialization format for your data, JSON is smaller, lighterweight and generally faster than XML.
5. JSON is best for consumption of data in web applications from webservices for its size and ease of use, especially due to the built-in support in JavaScript.
6. For configurations file XML is better choice to make because it more human readable.
7. XML is document-oriented. JSON is data-oriented. JSON can be mapped more easily to object-oriented systems.
8. XML and JSON both use Unicode.That help in support for internationalization.
9. JSON does not have afeature, so it is not well suited to act as a carrier of sounds or images or other large binary payloads. JSON is optimized for data.
10. XML documents can contain any imaginable data type – from classical data like text and numbers, or multimedia objects such as sounds, to active formats like Java applets or ActiveX components.
11.JSON is a better data exchange format. XML is a better document exchange format. Use the right tool for the right job.
12. For Data delivery between servers and browsers, JSON is better choice.For storing Information in configuration files on the server side, XML is better choice.
13. Querying data: Using XPath, it’s possible to get direct access to a part of multiple parts of an XML data structure; no such interface exists for JSON. To get data from a JSON structure, you must know exactly where it is or else iterate over everything until you find it.
14. To extract data from database; XML is the only choice.
Imagine the computation overhead for parsing an xml fragment compared to the instant lookup in JSON.

NOTE: post your comments and subscribe to my blog.

Create 12c SOA Application and SOA Project by using Maven

2014-12-27T01:41:00.000-08:00

Create SOA Application and SOA Project by using Maven

Prerequisite: Maven setup in Jdeveloper 12c

To use maven to create SOA application and SOA project we should setup maven in developer machine.

Step1: In cmd prompt, setup below env variables
set JAVA_HOME=C:\Program Files\Java\jdk1.7.0_25
set PATH=%JAVA_HOME%\bin;%PATH%
set ORACLE_HOME=D:\Fusion12C\Oracle\Middleware\Oracle_Home
set M2_HOME=<ORACLE_HOME>\oracle_common\modules\org.apache.maven_3.0.5
set PATH=%M2_HOME%\bin;%PATH%

Step2: Run below mvn cmd to create soa application and soa project.
mvn archetype:generate -DarchetypeGroupId=com.oracle.soa.archetype -DarchetypeArtifactId=oracle-soa-application -DarchetypeVersion=12.1.3-0-0 -DarchetypeRepository=local

Fill below details in CMD prompt:
[INFO] Generating project in Interactive mode
[INFO] Archetype defined by properties
Define value for property 'groupId': : com.test
Define value for property 'artifactId': : SOA12cApplicationWithMVN
Define value for property 'version': 1.0-SNAPSHOT: :
Define value for property 'version': 1.0-SNAPSHOT: :
Define value for property 'package': com.test: :
[INFO] Using property: adf = .adf
[INFO] Using property: data = .data
Define value for property 'projectName': : SOA12cProjectWithMVN
Confirm properties configuration:
groupId: com.test
artifactId: SOA12cApplicationWithMVN
version: 1.0-SNAPSHOT
package: com.test
adf: .adf
data: .data
projectName: SOA12cProjectWithMVN
Y: :Y

NOTE: If first time you are running "generate" maven goal then you may get error says that "maven goal or respective POM file is not available in maven repositery". If you see this kind of error then execute below maven goal. Below mvn cmd will download all required mvn jar files and pom files.
--> mvn archetype:generate

Step3: If we observe physical folders where we created SOA application and SOA Project , we dont have .jws and .jpr files.

Step4: Now open SOA application in JDeveloper 12c by following below steps.

Now we can see SOA application and SOA project in Jdeveloper12c.

We can see .jws and .jpr files in physical file system.

Step5: Now we can implement required business logic in composite.

Step6: Once we create required business logic we can deploy soa project in to SOA server.
For deployment we can use traditional deployment process by using jdeveloper.
In this post i want to show you steps to deploy soa project with maven goal.

--> mvn pre-integration-test

NOTE: If you are using this mvn cmd first time then it will download all required prerequisite jars and pom files.

If you get this kind of error, then you have to modify project level pom file with required server properties as shown below.

Modify the server details in your project level pom file, in which server you want to deploy the program. I am using integrated SOA server in JDeveloper so i provided local host details, you should provide as per your server environment.

NOTE:
Project level pom file available in "<mywork>\<application name>\<project name>\pom.xml"

Now run the mvn cmd to deploy SOA project.
--> mvn pre-integration-test

Step7: We can see deployed soa project in enterprise manager.

Maven Set up in JDeveloper 12C

2014-12-27T01:19:00.002-08:00

Maven Set up in JDeveloper 12C

Prerequisites : First we should install JDK 1.7 and JDeveloper 12.1.3.0.0

Step1: open cmd prompt

Step2: set environment variables in cmd prompt

set JAVA_HOME=C:\Program Files\Java\jdk1.7.0_25
set PATH=%JAVA_HOME%\bin;%PATH%
set ORACLE_HOME=D:\Fusion12C\Oracle\Middleware\Oracle_Home
set M2_HOME=<ORACLE_HOME>\oracle_common\modules\org.apache.maven_3.0.5
set PATH=%M2_HOME%\bin;%PATH%
NOTE: set the variables as per your machine.

Step3: Now we need a way to get the necessary artifacts into developers machines local Maven repository. Oracle provides the Maven Synchronization plug-in for this. So now we need install the plugin to local maven repository by using below MVN cmd.

mvn install:install-file -DpomFile=oracle-maven-sync.12.1.3.pom -Dfile=oracle-maven-sync.12.1.3.jar

NOTE:

"oracle-maven-sync-12.1.3.jar" and "oracle-maven-sync-12.1.3.pom" are available in below location.
These two files comes with JDev12c installation at below location.
%ORACLE_HOME%/oracle_common/plugins/maven/com/oracle/maven/oracle-maven-sync/12.1.3/

Step4: Next step is to execute the plugin in order to import the Oracle Maven artifacts, including the Parent POM necessary for deploying our SOA composite.

mvn com.oracle.maven:oracle-maven-sync:push -Doracle-maven-sync.oracleHome=D:/Fusion12C/Oracle/Middleware/Oracle_Home

NOTE: After completing execution of above command now we can see Parent POM in below location.
C:\Users\Fusion\.m2\repository\com\oracle\soa\orabpel\12.1.3-0-0
Parent POM file Name : orabpel-12.1.3-0-0.pom
we can use this file as parent for all pom.xml files which created along with SOA 12c projects.
In this file we can store global parameters like deployment server, user and password. Of-course we can discuss this in my next post.

Thats it, now maven is ready in your machine to execute MVN cmd's.

Maven Life cycle:
--> mvn validate
Ensure that the project is correct and all necessary information is available.
--> mvn compile
Compile the source of the project
--> mvn test
Test the compiled source code using a suitable unit testing framework; tests should not require the code to be packaged or deployed.
--> mvn package
Take the compiled code and package it in its distributable format, such as a JAR, WAR, EAR, SAR, or GAR files.
--> mvn integration-test
Process and deploy the package, if necessary, into an environment where integration tests can be run.
--> mvn verify
Run checks to verify whether the package is valid and meets quality criteria.
--> mvn install
Install the package into the local repository for use as a dependency in other projects locally.
--> mvn deploy
For the final release, copy the final package to a remote repository for sharing with other developers and projects.

By using mvn we can execute maven archetypes like below.
--> mvn archetype:generate
To create a SOA application and SOA Project with required SOA package structures and ID's.
--> mvn pre-integration-test
To deploy all soa projects in SOA application.

Few more maven goals and archetypes are available, we can discuss them in my next post.

Rightnow adapter setup in oracle soa 12c Jdeveloper

2014-12-14T10:31:00.003-08:00

Rightnow adapter setup in oracle soa 12c Jdeveloper
S
As we know about new release of SOA 12c suite, i want to introduce few concepts of integration between SOA 12c and oracle rightnow system.
One of the important feature in soa 12c suite is cloud adapters. Oracle is providing salI x z s bneforce adapter and rightnow adapter as part of cloud integration.
When we install Jdeveloper12.1.3 version by default we can see salesforce adapter but we dont have rightnow adapter along with default jdeveloper setup.
To get rightnow adapter in Jdeveloper we have to install a path with Opath utility.

In this post i want to provide steps to setup rightnow adapter in jdevloper.

Step1: download RightNowAdapter_121300_Patch.zip from Oracle Technology Network.

url : http://www.oracle.com/technetwork/middleware/adapters/downloads/index.html

Step2: unzip RightNowAdapter_121300_Patch.zip.
After unzip we can see below folders and files.

Setp3: In "Prereq_patches" folder we have 5 more zip files. These files are prerequisite patch files for p19479397_121300_Generic.zip

Step4: unzip below zip files in "PATCH_TOP" folder. (PATCH_TOP folder is a user defined folder)

Prerequisite patch files :
a. p18706071_121300_Generic.zip (after unzip folder name is 18706071)
b. p18858892_121300_Generic.zip (after unzip folder name is 18858892)
c. p19248641_121300_Generic.zip (after unzip folder name is 19248641)
d. p19423468_121300_Generic.zip (after unzip folder name is 19423468)
e. p19769394_121300_Generic.zip (after unzip folder name is 19769394)

Actual patch file :

a. p19479397_121300_Generic.zip (after unzip folder name is 19479397)

Step5: open cmd prompt with run as administrator.

Step6: we can find Opatch util in "<ORACLE_HOME>\OPatch" location.
ex: C:\JDeveloper12.1.1.3\Oracle\Middleware\Oracle_Home\OPatch

Step7: In cmd prompt enter into OPatch folder and run below cmd.
opatch version
this cmd will show us the proper version of OPatch in our machine.

Step8: Validate the OUI inventory with the following commands:
opatch lsinventory -jre C:\Progra~1\Java\jdk1.7.0_60\jre

Step9: In cmd prompt enter into patch folder location.
ex : cd C:\PATCH_TOP\Prereq_patches\18706071

Step10: now run below cmd in cmd prompt.
<path to reach opatch file>\opatch apply

Step11: repeat step9 and 10 for all patch files as provided in above order.

Step12: restart Jdeveloper with clean parameter.
Jdeveloper.exe -clean

Step13: now we can see rightnow adapter in Jdeveloper.

In my next post i will show you how to use rightnow adapter to integrate SOA12c with rightnow system.

File Adapter MOVE operation in Oracle SOA 11g

2014-10-25T09:42:00.001-07:00

File Adapter MOVE operation in Oracle SOA Suite 11g

The Oracle File and FTP Adapters let you copy or move a file from one location to another, or delete a file from the target directory. Additionally, the Oracle FTP Adapter lets you move or copy files from a local file system to a remote file system and from a remote file system to a local file system. This feature is implemented as a interaction specification for outbound services. So, this feature can be accessed either by using a BPEL invoke activity or a Mediator routing rule.

Step 1 :

Drag drop file adapter in reference pane of composite.xml

Setp 2:

In file adapter wizard perform below steps.

In wizard step4 we have to select Synchronous Read File

NOTE : You have selected Synchronous Read File as the operation because the WSDL file that is generated because this operation is similar to the one required for the file I/O operation.

provide your own name as per naming convention which you follow.

In my case i provided "FileMove" as move operation name.

Enter a dummy physical path for the directory for incoming files, and then click Next. The File name page is displayed.

Note: The dummy directory is not used. You must manually change the directory in a later step.

Enter a dummy file name, and then click Next. The Messages page is displayed.

Note: The dummy file name you enter is not used. You must manually change the file name in a later step.

Select Native format translation is not required (Schema is opaque), and then click Next. The Finish page is displayed.

Note: we are planning to perform move operation so we no need to process the payload. For this reason no need to create an XSD.

Step 3:

now open file adapter .jca file which looks as below.

=====================================================================

<adapter-config name="FileAdptMoveTest" adapter="File Adapter" wsdlLocation="FileAdptMoveTest.wsdl" xmlns="http://platform.integration.oracle/blocks/adapter/fw/metadata">

<connection-factory location="eis/FileAdapter"/>
<endpoint-interaction portType="FileMove_ptt" operation="FileMove">
    <interaction-spec className="oracle.tip.adapter.file.outbound.FileReadInteractionSpec">
      <property name="DeleteFile" value="true"/>
      <property name="PhysicalDirectory" value="C:/Dummy path"/>
      <property name="FileName" value="dummyFileName.txt"/>
    </interaction-spec>
</endpoint-interaction>
</adapter-config> =====================================================================

Step 4:

Now replace <endpoint-interaction>-----</endpoint-interaction> with below code.

<interaction-spec className="oracle.tip.adapter.file.outbound.FileIoInteractionSpec">
      <property name="SourcePhysicalDirectory" value="foo1"/>
      <property name="SourceFileName" value="bar1"/>
      <property name="TargetPhysicalDirectory" value="foo2"/>
      <property name="TargetFileName" value="bar2"/>
      <property name="Type" value="MOVE"/>

</interaction-spec>

After the change in .jca file, it should looks as below.

=================================================================

<adapter-config name="FileAdptMoveTest" adapter="File Adapter"
                wsdlLocation="FileAdptMoveTest.wsdl"
                xmlns="http://platform.integration.oracle/blocks/adapter/fw/metadata">
    <connection-factory location="eis/FileAdapter"/>
    <endpoint-interaction portType="FileMove_ptt" operation="FileMove">
        <interaction-spec className="oracle.tip.adapter.file.outbound.FileIoInteractionSpec">
            <property name="SourcePhysicalDirectory" value="C:\Users\Fusion\Desktop\source"/>
            <property name="SourceFileName" value="student.txt"/>
            <property name="TargetPhysicalDirectory" value="C:\Users\Fusion\Desktop\target"/>
            <property name="TargetFileName" value="studentNew.txt"/>
            <property name="Type" value="MOVE"/>
        </interaction-spec>
    </endpoint-interaction>
</adapter-config>
=================================================================
Note : Note: You have modified the className attribute, and added SourcePhysicalDirectory, SourceFileName,TargetPhysicalDirectory, TargetFileName and Type. The Type attributes decides the type of operation. Apart from MOVE, the other acceptable values for the Type attribute are COPY and DELETE.

Note : SourceFileName and TargetFileName no need to be same. we can provide different file names.

Note : Currently, the values for the source and target details are dummy. You must populate them at run-time with .The source and target details are hardcoded in the preceding example. You can also provide these details as run-time parameters.

(a) create 4 string variables in BPEL.

Note: Make sure about namespace in .bpel file. Just cross check below namespace is available in .bpel or not.

xmlns:xsd="http://www.w3.org/2001/XMLSchema"

(b) get the source and target folder path , source and target file name from any source. Like recieve activity input variable or from a DVM or from a table. Some how get the required date and by using Assign activity copy the data from proper source to newly created variables.

Step 5:

Now open .bpel source view.

Add custom properties in invoke activity.

Existing code:

Modified Code:

sourceDirectory, sourceFileName, targetDirectory and targetFileName are string variables which we created in Step4.

NOTE : above properties syntax is related to bpel 1.1 version.

Part 1 : Oracle service cloud(Rightnow) & Oracle SOA integration

2014-10-24T03:44:00.000-07:00

Oracle SOA suite 11g integration with Oracle service cloud (Rightnow CX)

Part-1

Generate Key Store :

Step 1 :
open cmd prompt in admin mode (right click and run as administrator.)

Step 2 :
in my machine "keytool" is available in
"C:\Program Files\Java\jdk1.7.0_60\bin"

Step 3:
In CMD prompt enter into above path as shown in below image.

Step 4 (optional if you want to use default key store : DemoTrust.jks):

generate new keystore with below cmd.

keytool -genkeypair -keyalg RSA -alias orakey -keypass welcome1 -keystore <wl_home>\server\lib\SOAKeystore.jks -storepass welcome1 -validity 3600

Answer the questions as per your environment.

What is your first and last name?
[Unknown]: kumar korada
What is the name of your organizational unit?
[Unknown]: it
What is the name of your organization?
[Unknown]: it
What is the name of your City or Locality?
[Unknown]: abcd
What is the name of your State or Province?
[Unknown]: ab
What is the two-letter country code for this unit?
[Unknown]: in
Is CN=kumar korada, OU=it, O=it, L=abcd, ST=ab, C=in correct?
[no]: yes

NOTE:

1) Observe "SOAKeystore.jk" created in "<wl_home>\server\lib\" folder.

2) "-keypass welcome1" will be used as keystore password.

3) .jks file name and password are user defined.

4) when ever we want to import any certificate into .jks file we should supply .jks file password. So it is mandatory to remember password. (not down some where :) )

NOTE:
As i mentioned earlier creation of keystore (.jks file) is optional. We can use default .jks file which comes with WL server installation.

Default jks file name : DemoTrust.jks
Default jks password : DemoTrustKeyStorePassPharse

NOTE: DemoTrust.jks and DemoTrustKeyStorePassPharse are case sensitive.

Step 5 :
Get Oracle Service Cloud (RNCX) certificate with the help of RNCX wsdl.

WSDL syntax :

https://<host_name>/cgi-bin/<interface>.cfg/services/soap?wsdl

start internet explorer as admin

paste the wsdl in address bar. Now we can see gold colored lock icon.

Click on lock icon and click View Certificate.

In the popup --> select Details tab --> Public Key --> copy to file (save the certificate in a file)

Step 6 :
import rightnow certificate into keystore.

copy .cer file into <WL_HOME>/server/lib

Run below script in cmd prompt, to import Rightnow public key certificate into weblogic key store (.jks file)

keytool -importcert -alias rightnowcx -file <WL_HOME>\server\lib\rightnowcx.cer -keystore <WL_HOME>\server\lib\SOAKeystore.jks -storepass welcome1

cretificate imported into key store.

Step 7 :
Log in into "EM"
http://<host name>:<weblogic port>/em

expand Weblogic Domain --> right click on domain name --> Security --> Security Provider Configuration

click on Configure button.

password : provide keystore password (as per above script password is "welcome1").
key Alias & Crypt Alias : rightnow (as per above script ).

RIghtnow CX Desktop Agent Installation

2014-10-24T01:37:00.002-07:00

Oracle Service Cloud - Desktop Agent Installation

consider as similar words --> Rightnow CX, RNCX and Oracle service cloud

step 1 :

we should have one oracle service cloud instance and RNCX Desktop Agent Installation URL to install.

URL syntax :

https://<host_name>/cgi-bin/<interface>.cfg/php/admin/launch.php

URL is unique for each service cloud instance.

This is the install link for local client (small java for enhanced agent performance – nothing is stored locally)

step 2 :

paste the above URL in internet explorer.

step 3 :

click install button as shown in below pic.

step 4 :

will take few minits to load

ake

step 5 :
pop up will display on screen with client interface name.

step 6 :
provide proper user and password of RNCX.
Select "Remember Me" check box.

step 7 :

Now we can see Rightnow CX desktop agent.