Another Example of Importing Flexfield Data Through Web Services
Assume you add an extensible flexfield that you use to store a status on the order line, and you plan to import it through a web service.
-
Add the SourceLineInfo context and Status segment to the Fulfillment Line Information extensible flexfield.
For details, see Set Up Extensible Flexfields in Order Management.
-
On the Manage Order Extensible Flexfields page, search for the value.
Attribute
Value
Name
Fulfillment Line Information
-
In the search results, click the row that contains Fulfillment Line Information in the Name column, then click Actions > Download Flexfield Archive.
-
In the Confirmation dialog, click Download, then save the .zip file to any folder.
The file manager for your operating system opens. For example, if you're using Microsoft Windows, then
Windows Explorer opens.
-
In your file manager, double-click 10008_DOO_FULFILL_LINES_ADD_INFO.zip, then expand it to the view folder.
For example:
C:\downloads\10008_DOO_FULFILL_LINES_ADD_INFO.zip\oracle\apps\scm\doo\processOrder\flex\fulfillLineContextsB\view
The FulfillLineEffBSourceLineInfoprivateVO.xml file contains the extensible flexfield segment that you must reference.
-
Use an xml editor to open FulfillLineEffBSourceLineInfoprivateVO.xml.
-
Identify the values that you will need in your web service payload.
-
Search for the attribute name.
<ViewAttribute Name="status" EntityUsage="FulfillLineEffEO" EntityAttrName="status" AliasName="status">
-
Search for the context code.
<Property Name="FND_ACFF_EFF_CONTEXT_CODE" Value="SourceLineInfo"/>
-
-
Create your web service payload.
<mod:AdditionalFulfillmentLineInformationCategories xsi:type="ns12:j_FulfillLineEffDooFulfillLinesAddInfoprivate" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns12="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/fulfillLineCategories/" xmlns:ns22="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/fulfillLineContextsB/" xmlns:ns8="http://xmlns.oracle.com/apps/scm/doo/processOrder/model/"> <ns8:Category>DOO_FULFILL_LINES_ADD_INFO</ns8:Category> <ns8:SourceTransactionLineIdentifier>1</ns8:SourceTransactionLineIdentifier> <ns8:SourceTransactionScheduleIdentifier>1</ns8:SourceTransactionScheduleIdentifier> <ns8:SourceTransactionLineNumber>1</ns8:SourceTransactionLineNumber> <ns8:SourceTransactionScheduleNumber>1</ns8:SourceTransactionScheduleNumber> <ns12:FulfillLineEffBSourceLineInfoprivateVO> <ns8:ContextCode>SourceLineInfo</ns8:ContextCode> <ns22:status>Working</ns22:status> </ns12:FulfillLineEffBSourceLineInfoprivateVO> </mod:AdditionalFulfillmentLineInformationCategories>
where
-
ContextCode
contains the value you found for the context code in FulfillLineEffBSourceLineInfoprivateVO.xml. -
status
contains the value you found for the attribute in FulfillLineEffBSourceLineInfoprivateVO.xml
-
Here's your WSDL.
https://
server:port/soa-infra/services/default/DooDecompReceiveOrderExternalComposite/ReceiveOrderRequestService
We recommend that you use Order Import Service instead of Receive Order Request Service. For details, see Web Services That You Can Use to Integrate Order Management.
Use the ProcessOrderRequest operation. You can also use the ProcessOrderRequestSync operation to get a response in SOAP UI for testing purposes.
As an alternative to examining the .zip file, you can get the attribute name and context code in the output file when you run the Publish Extensible Flexfield Attributes scheduled process. For details, see Set Up Extensible Flexfields in Order Management.
Import a Flexfield on the Order Header
The procedure that you use to Import a flexfield that's on the order header is similar, with a few differences.
Assume you need a flexfield that your users can use to store a value that identifies the bill-to customer.
-
Edit the Header Information extensible flexfield instead of Fulfillment Line Information.
-
Add a context named PMC Header and segment named customerBillToId to the Header Information extensible flexfield.
-
Download and open 10008_DOO_HEADERS_ADD_INFO.zip.
-
Navigate to
oracle/apps/scm/doo/processOrder/flex/headerContextsB/view
in the .zip file. -
Open the HeaderEffBPMC__HeaderprivateVO.xml file.
-
Identify the context code. Search for the value.
<Property Name="FND_ACFF_EFF_CONTEXT_CODE" Value="PMC Header"/>
For example:
<mod:AdditionalHeaderInformationCategories xsi:type="ns12:j_HeaderEffDooHeadersAddInfoprivate" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns3="http://xmlns.oracle.com/apps/scm/doo/processOrder/service/" xmlns:ns12="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/headerCategories/" xmlns:ns22="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/headerContextsB/" xmlns:ns8="http://xmlns.oracle.com/apps/scm/doo/processOrder/model/"> <ns8:Category>DOO_HEADERS_ADD_INFO</ns8:Category> <ns12:HeaderEffBPMC__HeaderprivateVO> <ns8:ContextCode>PMC Header</ns8:ContextCode> <ns22:specialHandlingInstructions>West Coast Packers</ns22:specialHandlingInstructions> </ns12:HeaderEffBPMC__HeaderprivateVO> </mod:AdditionalHeaderInformationCategories>
Here's the entire payload.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dood="http://xmlns.oracle.com/apps/scm/doo/decomposition/receiveTransform/receiveSalesOrder/DooDecompReceiveOrderExternalComposite" xmlns:mod="http://xmlns.oracle.com/apps/scm/doo/decomposition/receiveTransform/receiveSalesOrder/model/" xmlns:mod1="http://xmlns.oracle.com/apps/scm/doo/processOrder/model/" xmlns:xsi="xsi"> <soapenv:Header/> <soapenv:Body> <dood:process> <dood:OrchestrationOrderRequest> <mod:SourceTransactionNumber>PMC-160902-016</mod:SourceTransactionNumber> <mod:SourceTransactionSystem>OPS</mod:SourceTransactionSystem> <mod:SourceTransactionIdentifier>PMC-160902-016</mod:SourceTransactionIdentifier> <mod:FreezePriceFlag>false</mod:FreezePriceFlag> <mod:FreezeShippingChargeFlag>false</mod:FreezeShippingChargeFlag> <mod:FreezeTaxFlag>false</mod:FreezeTaxFlag> <mod:BuyingPartyId>300000074725229</mod:BuyingPartyId> <mod:BuyingPartyContactName/> <mod:ShipToPartyType>ORGANIZATION</mod:ShipToPartyType> <mod:ShipToPartyIdentifier>300000074725229</mod:ShipToPartyIdentifier> <mod:ShipToPartySiteIdentifier>300000074725231</mod:ShipToPartySiteIdentifier> <mod:BillToPartyType>ORGANIZATION</mod:BillToPartyType> <mod:BillToCustomerIdentifier>300000075240955</mod:BillToCustomerIdentifier> <mod:BillToAccountSiteUseIdentifier>300000075240957</mod:BillToAccountSiteUseIdentifier> <mod:TransactionalCurrencyCode>USD</mod:TransactionalCurrencyCode> <mod:TransactionOn>2020-04-07T10:10:10</mod:TransactionOn> <mod:RequestingBusinessUnitIdentifier>300000001616323</mod:RequestingBusinessUnitIdentifier> <mod:OrigSystemDocumentReference/> <mod:AdditionalHeaderInformationCategories xsi:type="ns12:j_HeaderEffDooHeadersAddInfoprivate" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns3="http://xmlns.oracle.com/apps/scm/doo/processOrder/service/" xmlns:ns12="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/headerCategories/" xmlns:ns22="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/headerContextsB/" xmlns:ns8="http://xmlns.oracle.com/apps/scm/doo/processOrder/model/"> <ns8:Category>DOO_HEADERS_ADD_INFO</ns8:Category> <ns12:HeaderEffBPMC__HeaderprivateVO> <ns8:ContextCode>PMC Header</ns8:ContextCode> <ns22:specialHandlingInstructions>West Coast Packers</ns22:specialHandlingInstructions> </ns12:HeaderEffBPMC__HeaderprivateVO> </mod:AdditionalHeaderInformationCategories> <mod:OrchestrationOrderRequestLine> <mod:SourceTransactionLineIdentifier>1</mod:SourceTransactionLineIdentifier> <mod:SourceTransactionScheduleIdentifier>1</mod:SourceTransactionScheduleIdentifier> <mod:SourceTransactionLineNumber>1</mod:SourceTransactionLineNumber> <mod:SourceTransactionScheduleNumber>1</mod:SourceTransactionScheduleNumber> <mod:ProductNumber>PMC - Std Item</mod:ProductNumber> <mod:OrderedQuantity>10</mod:OrderedQuantity> <mod:OrderedUOM>Each</mod:OrderedUOM> <mod:PaymentTerms>NG_IMMEDIATE</mod:PaymentTerms> <mod:InventoryOrganizationIdentifier>300000001621747</mod:InventoryOrganizationIdentifier> <mod:ShipToPartyIdentifier>300000074725229</mod:ShipToPartyIdentifier> <mod:ShipToPartySiteIdentifier>300000074725231</mod:ShipToPartySiteIdentifier> <mod:BillToPartyType>ORGANIZATION</mod:BillToPartyType> <mod:BillToCustomerIdentifier>300000075240955</mod:BillToCustomerIdentifier> <mod:BillToAccountSiteUseIdentifier>300000075240957</mod:BillToAccountSiteUseIdentifier> <mod:ShippingInstructions>Handle with care</mod:ShippingInstructions> <mod:PackingInstructions>Pack with shockproof material</mod:PackingInstructions> <mod:RequestedShipDate>2020-04-07T10:10:10</mod:RequestedShipDate> <mod:PaymentTerms>NG_IMMEDIATE</mod:PaymentTerms> <mod:TransactionCategoryCode>ORDER</mod:TransactionCategoryCode> <mod:PartialShipAllowedFlag>false</mod:PartialShipAllowedFlag> <mod:OrigSysDocumentReference>ORIGSYS</mod:OrigSysDocumentReference> <mod:OrigSysDocumentLineReference>ORIGSYSLINE</mod:OrigSysDocumentLineReference> <mod:AdditionalFulfillmentLineInformationCategories xsi:type="ns12:j_FulfillLineEffDooFulfillLinesAddInfoprivate" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns12="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/fulfillLineCategories/" xmlns:ns22="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/fulfillLineContextsB/" xmlns:ns8="http://xmlns.oracle.com/apps/scm/doo/processOrder/model/"> <ns8:Category>DOO_FULFILL_LINES_ADD_INFO</ns8:Category> <ns8:SourceTransactionLineIdentifier>1</ns8:SourceTransactionLineIdentifier> <ns8:SourceTransactionScheduleIdentifier>1</ns8:SourceTransactionScheduleIdentifier> <ns8:SourceTransactionLineNumber>1</ns8:SourceTransactionLineNumber> <ns8:SourceTransactionScheduleNumber>1</ns8:SourceTransactionScheduleNumber> <ns12:FulfillLineEffBSourceLineInfoprivateVO> <ns8:ContextCode>SourceLineInfo</ns8:ContextCode> <ns22:status>Working</ns22:status> </ns12:FulfillLineEffBSourceLineInfoprivateVO> </mod:AdditionalFulfillmentLineInformationCategories> </mod:OrchestrationOrderRequestLine> <mod:OrderProcessingPreferences> <mod:CreateCustomerInformationFlag>true</mod:CreateCustomerInformationFlag> <mod:SubmitFlag>true</mod:SubmitFlag> </mod:OrderProcessingPreferences> </dood:OrchestrationOrderRequest> </dood:process> </soapenv:Body> </soapenv:Envelope>