Oracle Fusion Middleware: December 2016

Monday, 12 December 2016

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.

Thursday, 8 December 2016

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)

Wednesday, 7 December 2016

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.

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