Oracle B2B - Part4

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

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

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

 

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.

1. Host Partner
2. Trading Partner
3. Trading Partner Agreement
4. B2B Standards / B2B Document
5. 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

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.

 <property name="NumberOfThreads" value="1"/>

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.