Oracle 1.0 B2B Purchase Order Cancel Out
The data mapping and sample payload for the Oracle-1-0-B2B-Purchase-Order-Cancel-Out are outlined in this section.
Data Mapping
Refer to Figure 1 in cXML 1.2.007 Order Requests for the structure of the payload received from the application.
This figure shows the structure of the payload that is sent to the supplier.
|
Source (PRC Source Field) getCmkInputPayloadResponse/result/PdfDraftPurchaseOrderHeaderVORow |
Mapping B2BPurchaseOrderMessage/B2BPurchaseOrder |
|---|---|
| isShipToLocationMultiple | |
| B2BPurchaseOrder/ChangeCode Note: For a new
PO, ChangeCode is set to New. For a Change PO, ChangeCode is set
to Changed. For a Cancel PO, ChangeCode is set to
Canceled. |
|
| Segment1 | B2BPurchaseOrder/OrderNumber |
| ChangeOrderNum | B2BPurchaseOrder/ChangeNumber ChangeNumber is mapped when the value of ChangeOrderNum is non-zero. |
| RevisionNum | B2BPurchaseOrder/RevisionNumber |
| OrderDate | B2BPurchaseOrder/OrderDate |
| ChangeOrderDate | B2BPurchaseOrder/ChangeOrderDate |
| CurrencyCode | B2BPurchaseOrder/CurrencyCode The predefined DVM CURRENCY_CODE is in use. |
| Ordered | B2BPurchaseOrder/OrderAmount |
| TotalTaxDisplay | B2BPurchaseOrder/TaxAmount |
| AcceptanceRequiredFlag | B2BPurchaseOrder/AcknowledgmentTypeCode If AcceptanceRequiredFlag is Y, then AcknowledgmentTypeCode is set to Schedule. If AcceptanceRequiredFlag is D, then AcknowledgmentTypeCode is set to Document. If AcceptanceRequiredFlag is N, then AcknowledgmentTypeCode is set to None. |
| ConfirmingOrderFlag | B2BPurchaseOrder/NotificationOnlyIndicator |
| TermsAndConditions | B2BPurchaseOrder/TermsAndConditions |
| Comments | B2BPurchaseOrder/Comments |
| HeaderNoteToVendor | B2BPurchaseOrder/NoteToSupplier |
| SoldToLeName | B2BPurchaseOrder/Customer/Name |
| SoldToLeAddressLine1 | B2BPurchaseOrder/Customer/AddressLine1 |
| SoldToLeAddressLine2 | B2BPurchaseOrder/Customer/AddressLine2 |
| SoldToLeAddressLine3 | B2BPurchaseOrder/Customer/AddressLine3 |
| SoldToLeAddressLine4 | B2BPurchaseOrder/Customer/AddressLine4 |
| SoldToLeTownOrCity | B2BPurchaseOrder/Customer/City |
| SoldToLeCounty | B2BPurchaseOrder/Customer/County |
| SoldToLeStateProvn | B2BPurchaseOrder/Customer/StateOrProvince The predefined DVM STATE is in use. |
| SoldToLePostalCode | B2BPurchaseOrder/Customer/PostalCode |
| SoldToLeCountry | B2BPurchaseOrder/Customer/CountryCode The predefined DVM, COUNTRY_CODE is in use. |
| PersonName | B2BPurchaseOrder/Customer/BuyerContactName |
| PersonEmailAddress | B2BPurchaseOrder/Customer/BuyerContactEmail |
| PersonWorkPhone | B2BPurchaseOrder/Customer/BuyerContactPhone |
| PersonFax | B2BPurchaseOrder/Customer/BuyerContactFax |
| SupplierPartyName | B2BPurchaseOrder/Supplier/Name |
| SupplierNumber | B2BPurchaseOrder/Supplier/SupplierNumber |
| TaxRegistrationNumber | B2BPurchaseOrder/Supplier/TaxRegistrationNumber |
| ProcurementBuName | B2BPurchaseOrder/Supplier/BusinessUnit |
| VendorSiteCode | B2BPurchaseOrder/Supplier/SiteName |
| SupplierSitePhoneCountryCode, SupplierSitePhoneAreaCode, SupplierSitePhoneNumber | B2BPurchaseOrder/Supplier/Phone SupplierSitePhoneCountryCode, SupplierSitePhoneAreaCode, SupplierSitePhoneNumber are concatenated. |
| SupplierSiteFaxCountryCode, SupplierSiteFaxAreaCode, SupplierSiteFaxPhoneNumber | B2BPurchaseOrder/Supplier/Fax SupplierSiteFaxCountryCode, SupplierSiteFaxAreaCode, SupplierSiteFaxPhoneNumber are concatenated. |
| EmailAddress | B2BPurchaseOrder/Supplier/Email |
| SupplierSiteAddress1 | B2BPurchaseOrder/Supplier/AddressLine1 |
| SupplierSiteAddress2 | B2BPurchaseOrder/Supplier/AddressLine2 |
| SupplierSiteAddress3 | B2BPurchaseOrder/Supplier/AddressLine3 |
| SupplierSiteCity | B2BPurchaseOrder/Supplier/City |
| SupplierSiteCounty | B2BPurchaseOrder/Supplier/County |
| SupplierSiteState | B2BPurchaseOrder/Supplier/StateOrProvince The predefined STATE is in use. |
| SupplierSitePostalCode | B2BPurchaseOrder/Supplier/PostalCode |
| SupplierSiteCountry | B2BPurchaseOrder/Supplier/CountryCode The predefined COUNTRY_CODE is in use. |
| SupplierContactPartyName | B2BPurchaseOrder/Supplier/ContactName |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShiptoCustomerName
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/CustomerName If the isShipToLocationMultiple flag is set to N, all the ship-to fields from the schedule line are mapped to the header. |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/LineLocShipToLocationName
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/LocationName |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShipToInternalLocationCode
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/LocationCode
The DVM, EDI_LOCATION_CODE is in use. |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShipToLocAddressLine1
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/AddressLine1 |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShipToLocAddressLine2
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/AddressLine2 |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShipToLocAddressLine3
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/AddressLine3 |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShipToLocTownOrCity
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/City |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShipToLocCounty
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/County |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShipToLocStateProvn
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/StateOrProvince
The predefined DVM, STATE is in use. |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShipToLocPostalCode
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/PostalCode |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShipToLocCountry
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/CountryCode The predefined DVM, COUNTRY_CODE is in use. |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShiptoCustContactName
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/ContactName |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShiptoCustContactPhoneNumber
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/Phone |
| PdfDraftPurchaseOrderLineVORow/PdfDraftPurchaseOrderLineLocationVORow/ShiptoCustContactEmailAddress
Mapped if the isShipToLocationMultiple flag is set to N. |
B2BPurchaseOrder/ShipTo/Email |
| BillToBuName | B2BPurchaseOrder/BillTo/CustomerName |
| BillToLocationCode | B2BPurchaseOrder/BillTo/LocationCode The predefined DVM, EDI_LOCATION is in use. If BillToLocationCode is provided in the payload, it is used to derive the Bill To address otherwise it is mapped as below. |
| BillToLocAddressLine1 | B2BPurchaseOrder/BillTo/AddressLine1 |
| BillToLocAddressLine2 | B2BPurchaseOrder/BillTo/AddressLine2 |
| BillToLocAddressLine3 | B2BPurchaseOrder/BillTo/AddressLine3 |
| BillToLocTownOrCity | B2BPurchaseOrder/BillTo/City |
| BillToLocCounty | B2BPurchaseOrder/BillTo/County |
| BillToLocStateProvn | B2BPurchaseOrder/BillTo/StateOrProvince The predefined DVM, STATE is in use. |
| BillToLocPostalCode | B2BPurchaseOrder/BillTo/PostalCode |
| BillToLocCountry | B2BPurchaseOrder/BillTo/CountryCode The predefined DVM, COUNTRY_CODE is in use. |
| BillToLocTelephoneNumber1 | B2BPurchaseOrder/BillTo/Phone |
| PaymentTermsName | B2BPurchaseOrder/PaymentTermsName The predefined DVM, PAYMENT_TERMS is in use. |
| PaymentTermsDescription | B2BPurchaseOrder/PaymentTermsDescription |
| Fob | B2BPurchaseOrder/FOBCode The predefined DVM, FOB_CODE is in use. |
| FreightTerms | B2BPurchaseOrder/FreightTermsCode |
| ServiceLevelName | B2BPurchaseOrder/ServiceLevel |
| ShippingMethod | B2BPurchaseOrder/ShippingMethod |
| ModeOfTransportName | B2BPurchaseOrder/ModeOfTransport |
| CarrierPartyName | B2BPurchaseOrder/CarrierName |
| BuyerManagedTransportFlag | B2BPurchaseOrder/BuyerManagedTransportIndicator |
| PdfDraftPurchaseOrderHeaderVOToAttachmentsVOAccessor/AttachmentsVORow | B2BPurchaseOrder/AttachmentReferences |
| DmDocumentId | B2BPurchaseOrder/AttachmentReferences/Id |
| PdfDraftPurchaseOrderHeaderVOToAttachmentsVOAccessor/AttachmentsVORow | B2BPurchaseOrder/URIs |
| URI | B2BPurchaseOrder/URIs/URI |
Sample Payload
Here's a sample payload:
<sendCollaborationDocument xmlns="http://xmlns.oracle.com/apps/scm/cmk">
<CollaborationEvent testFlag="true" testResult="Success" retrieveObjectFlag="false">
<CollaborationEventName>PurchaseOrderCanceled</CollaborationEventName>
<RecipientKey1>300100181682739</RecipientKey1>
<RecipientKey2>300100181682756</RecipientKey2>
<RecipientKeyType>Supplier Site</RecipientKeyType>
<ObjectKey1>300100090871752</ObjectKey1> <!-- Primary Key -->
<ObjectKey2>1003919</ObjectKey2> <!-- PO Number -->
<ObjectKey3>Vision Operations</ObjectKey3> <!-- Sold to Legal Entity -->
<ObjectKey4>123123</ObjectKey4> <!-- Approval Composite Instance ID - Make it unique each time so that the message doesn't skip-->
<ObjectKey5>0</ObjectKey5> <!-- Revision Number -->
<ObjectKey6>0</ObjectKey6> <!-- Change Order Number -->
<ObjectData name="ChangedLineCount">0</ObjectData>
<ObjectData name="LineCount">1</ObjectData>
</CollaborationEvent>
<Document>
<tns:getCmkInputPayloadResponse xmlns:tns="http://xmlns.oracle.com/apps/prc/po/manageDocument/publicModel/viewPdf/types/">
<tns:result xmlns:ns2="http://xmlns.oracle.com/apps/prc/po/manageDocument/publicModel/viewPdf/v2/">
<ns2:PdfDraftPurchaseOrderHeaderVORow>
<ns2:Segment1>1004846</ns2:Segment1>
<ns2:CurrencyCode>USD</ns2:CurrencyCode> <!-- CURRENCY_CODE -->
<ns2:HeaderNoteToVendor>Note to Supplier</ns2:HeaderNoteToVendor>
<ns2:ConfirmingOrderFlag>N</ns2:ConfirmingOrderFlag>
<ns2:Comments>PO description</ns2:Comments>
<ns2:AcceptanceRequiredFlag>N</ns2:AcceptanceRequiredFlag>
<ns2:EmailAddress>my@email.com</ns2:EmailAddress>
<ns2:FreightTerms>Prepaid freight</ns2:FreightTerms>
<ns2:Fob>Origin</ns2:Fob><!-- FOB_CODE -->
<ns2:RevisionNum>0</ns2:RevisionNum>
<ns2:TermsAndConditions>TermsAndConditions</ns2:TermsAndConditions>
<ns2:SupplierPartyName>CMK_PO_18</ns2:SupplierPartyName>
<ns2:SupplierContactPartyName>CMK_PO18_ST CMK_PO18_ST</ns2:SupplierContactPartyName>
<ns2:CarrierPartyName>Airborne</ns2:CarrierPartyName>
<ns2:PersonName>Clare Furey</ns2:PersonName>
<ns2:PersonWorkPhone>123-456-7890</ns2:PersonWorkPhone>
<ns2:PersonFax>123-456-7890</ns2:PersonFax>
<ns2:PersonEmailAddress>my@email.com</ns2:PersonEmailAddress>
<ns2:PaymentTermsName>30 Net</ns2:PaymentTermsName> <!-- PAYMENT_TERMS -->
<ns2:isShipToLocationMultiple>N</ns2:isShipToLocationMultiple> <!-- Not mapped but used by the xsl to ID where to map the ShipTo. If N, mapped at header. If not N, not mapped at header -->
<ns2:Ordered>1000.00</ns2:Ordered>
<ns2:SupplierNumber>1488256471</ns2:SupplierNumber>
<ns2:ChangeOrderDate>2020-08-02T20:26:40.0Z</ns2:ChangeOrderDate>
<ns2:OrderDate>2020-08-01T20:26:40.0Z</ns2:OrderDate>
<ns2:TotalTaxDisplay>0.00</ns2:TotalTaxDisplay>
<ns2:VendorSiteCode>CMK_PO18_ST</ns2:VendorSiteCode>
<ns2:SupplierSiteCity>Any City</ns2:SupplierSiteCity>
<ns2:SupplierSiteCounty>Any County</ns2:SupplierSiteCounty>
<ns2:SupplierSiteState>Any State</ns2:SupplierSiteState> <!-- STATE -->
<ns2:SupplierSiteCountry>Any Country</ns2:SupplierSiteCountry> <!-- COUNTRY_CODE -->
<ns2:SupplierSitePostalCode>123456</ns2:SupplierSitePostalCode>
<ns2:SupplierSiteAddress1>Address1</ns2:SupplierSiteAddress1>
<ns2:SupplierSiteAddress2>Address2</ns2:SupplierSiteAddress2>
<ns2:SupplierSiteAddress3>Address3</ns2:SupplierSiteAddress3>
<ns2:SupplierSiteFaxCountryCode>1</ns2:SupplierSiteFaxCountryCode>
<ns2:SupplierSiteFaxAreaCode>123</ns2:SupplierSiteFaxAreaCode>
<ns2:SupplierSiteFaxPhoneNumber>456-7890</ns2:SupplierSiteFaxPhoneNumber>
<ns2:SupplierSitePhoneAreaCode>123</ns2:SupplierSitePhoneAreaCode>
<ns2:SupplierSitePhoneCountryCode>1</ns2:SupplierSitePhoneCountryCode>
<ns2:SupplierSitePhoneNumber>456-7890</ns2:SupplierSitePhoneNumber>
<ns2:BillToLocTownOrCity>Any City</ns2:BillToLocTownOrCity>
<ns2:BillToLocCountry>US</ns2:BillToLocCountry> <!-- COUNTRY_CODE -->
<ns2:BillToLocPostalCode>10022-3422</ns2:BillToLocPostalCode>
<ns2:BillToLocAddressLine1>90 Fifth Avenue</ns2:BillToLocAddressLine1>
<ns2:BillToLocAddressLine2>AddressLine2</ns2:BillToLocAddressLine2>
<ns2:BillToLocAddressLine3>AddressLine3</ns2:BillToLocAddressLine3>
<ns2:BillToLocStateProvn>NY</ns2:BillToLocStateProvn> <!-- STATE -->
<ns2:BillToLocCounty>New York</ns2:BillToLocCounty>
<ns2:BillToLocTelephoneNumber1>123-4567</ns2:BillToLocTelephoneNumber1>
<ns2:PaymentTermsDescription>PaymentTermsDescription</ns2:PaymentTermsDescription>
<ns2:BillToBuName>Vision Operations</ns2:BillToBuName>
<ns2:SoldToLeName>Vision Operations</ns2:SoldToLeName>
<ns2:TaxRegistrationNumber>SYS12125</ns2:TaxRegistrationNumber>
<ns2:ProcurementBuName>Vision Operations</ns2:ProcurementBuName>
<ns2:BillToLocationCode>V1- New York City</ns2:BillToLocationCode> <!-- EDI_LOCATION -->
<ns2:ModeOfTransportName>Parcel</ns2:ModeOfTransportName>
<ns2:ServiceLevelName>2nd day air</ns2:ServiceLevelName>
<ns2:ShippingMethod>Airborne-Parcel-2nd day air</ns2:ShippingMethod>
<ns2:SoldToLeTownOrCity>New York</ns2:SoldToLeTownOrCity>
<ns2:SoldToLeCountry>US</ns2:SoldToLeCountry> <!-- COUNTRY_CODE -->
<ns2:SoldToLePostalCode>10022</ns2:SoldToLePostalCode>
<ns2:SoldToLeAddressLine1>475 Park Avenue</ns2:SoldToLeAddressLine1>
<ns2:SoldToLeAddressLine2>AddressLine2</ns2:SoldToLeAddressLine2>
<ns2:SoldToLeAddressLine3>AddressLine3</ns2:SoldToLeAddressLine3>
<ns2:SoldToLeAddressLine4>AddressLine4</ns2:SoldToLeAddressLine4>
<ns2:SoldToLeStateProvn>NY</ns2:SoldToLeStateProvn> <!-- STATE -->
<ns2:SoldToLeCounty>New York</ns2:SoldToLeCounty>
<ns2:BuyerManagedTransportFlag>N</ns2:BuyerManagedTransportFlag>
<ns2:PdfDraftPurchaseOrderHeaderVOToAttachmentsVOAccessor>
<ns2:AttachmentsVORow>
<ns2:DatatypeCode>FILE</ns2:DatatypeCode>
<ns2:FileName>notes.txt</ns2:FileName>
<ns2:DmDocumentId>UCMFA00074696</ns2:DmDocumentId>
<ns2:Url>Url</ns2:Url>
</ns2:AttachmentsVORow>
</ns2:PdfDraftPurchaseOrderHeaderVOToAttachmentsVOAccessor>
</ns2:PdfDraftPurchaseOrderHeaderVORow>
</tns:result>
</tns:getCmkInputPayloadResponse>
</Document>
</sendCollaborationDocument>