kiran g
Well Known Member
hi,
I am trying to insert data into JDE OneWorld 8.10 using XML interoperability.For this purpose I have written a xml request for inbound transaction for Inbound Purchase Order.
Request is as follows:
---------------------------------------------------------------------------------------------------------------
String xmlString = "<?xml version='1.0' ?>"+
"<jdeRequest type='trans' user='PSFT' pwd='PSFT' environment='DV810' session='' sessionidle='300'>"+
"<!-- This an Inbound Purchase Order, Should Pass. -->"+
"<transaction action='inbound' type='JDEPOIN'>"+
"<key>"+
"<column name='EdiUserId'>TEST</column>"+
"<column name='EdiBatchNumber'>110042</column>"+
"<column name='EdiTransactNumber'>1600006</column>"+
"<column name='EdiLineNumber'>1.000</column>"+
"</key>"+
"<!-- table name attribute value is optional, cross reference is used -->"+
"<table name='F4301Z1' type='header'>"+
"<column name='EdiDocumentType'> </column>"+
"<column name='TypeTransaction'>JDEPOIN</column>"+
"<column name='EdiTranslationFormat'> </column>"+
"<column name='EdiTransmissionDate'> </column>"+
"<column name='DirectionIndicator'>1</column>"+
"<column name='EdiDetailLinesProcess'>0</column>"+
"<column name='EdiSuccessfullyProcess'>N</column>"+
"<column name='TradingPartnerId'> </column>"+
"<column name='TransactionAction'>A</column>"+
"<column name='DocumentOrderInvoiceE'>204</column>"+
"<column name='CompanyKeyOrderNo'>00200</column>"+
"<column name='OrderType'>OP</column>"+
"<column name='OrderSuffix'>000</column>"+
"<column name='CostCenter'> 27</column>"+
"<column name='CompanyKeyOriginal'> </column>"+
"<column name='OriginalPoSoNumber'> </column>"+
"<column name='OriginalOrderType'> </column>"+
"<column name='CompanyKeyRelated'> </column>"+
"<column name='RelatedPoSoNumber'> </column>"+
"<column name='RelatedOrderType'> </column>"+
"<column name='AddressNumber'>1620</column>"+
"<column name='AddressNumberShipTo'>27</column>"+
"<column name='DateRequestedJulian'>08/10/2003</column>"+
"<column name='DateTransactionJulian'>08/10/2003</column>"+
"<column name='SchedulePickDate'>08/10/2003</column>"+
"<column name='DateOriginalPromisde'>08/10/2003</column>"+
"<column name='ActualShipDate'> </column>"+
"<column name='CancelDate'> </column>"+
"<column name='DatePriceEffectiveDate'> </column>"+
"<column name='DatePromisedShipJu'> </column>"+
"<column name='DatePromisedShipJu'> </column>"+
"<column name='Reference1'> </column>"+
"<column name='Reference2Vendor'> </column>"+
"<column name='DeliveryInstructLine1'> </column>"+
"<column name='DeliveryInstructLine2'> </column>"+
"<column name='NameRemark'> </column>"+
"<column name='Description'> </column>"+
"<column name='PrintMessage1'> </column>"+
"<column name='PriceAdjustmentScheduleN'> </column>"+
"<column name='PricingGroup'> </column>"+
"<column name='PaymentTermsCode01'> </column>"+
"<column name='TaxExplanationCode1'> </column>"+
"<column name='TaxArea1'> </column>"+
"<column name='CertificateTaxExempt'> </column>"+
"<column name='HoldOrdersCode'> </column>"+
"<column name='AssociatedText'> </column>"+
"<column name='InvoiceCopies'>0</column>"+
"<column name='NatureOfTransaction'> </column>"+
"<column name='ContainerID'> </column>"+
"<column name='FreightHandlingCode'> </column>"+
"<column name='ZoneNumber'> </column>"+
"<column name='BuyerNumber'>0</column>"+
"<column name='CarrierNumber'>0</column>"+
"<column name='ModeOfTransport'> </column>"+
"<column name='ConditionsOfTransport'> </column>"+
"<column name='ReasonCode'> </column>"+
"<column name='FreightCalculatedYN'> </column>"+
"<column name='ApplyFreight'>Y</column>"+
"<column name='PostQuantities'>1</column>"+
"<column name='AmountOrderGross'>32.10</column>"+
"<column name='PercentRetainage1'>0</column>"+
"<column name='RetainageRule'> </column>"+
"<column name='UnitOfMeasureWhtDisp'> </column>"+
"<column name='UnitOfMeasureVolDisp'> </column>"+
"<column name='PurgeCode1'> </column>"+
"<column name='LogicControl'> </column>"+
"<column name='ProcessingMode'> </column>"+
"<column name='TypeMatch'> </column>"+
"<column name='StatusPurchaseOrder'> </column>"+
"<column name='CodeAutomaticVoucher'>N</column>"+
"<column name='PrepaymentYN'> </column>"+
"<column name='CorrespondenceMethod'> </column>"+
"<column name='PurchasingReportCode5'> </column>"+
"<column name='RoutingApproval'>DEMO</column>"+
"<column name='NumberChangeOrder'>0</column>"+
"<column name='CurrencyMode'>D</column>"+
"<column name='CurrencyCodeFrom'>USD</column>"+
"<column name='CurrencyConverRateOv'>0</column>"+
"<column name='LanguagePreference'> </column>"+
"<column name='AmountForeignOpen'>0</column>"+
"<column name='OrderedBy'>LH5813131</column>"+
"<column name='OrderTakenBy'> </column>"+
"<column name='UserReservedCode'> </column>"+
"<column name='UserReservedDate'> </column>"+
"<column name='UserReservedAmount'>0</column>"+
"<column name='UserReservedNumber'>0</column>"+
"<column name='UserReservedReference'> </column>"+
"<column name='UserId'>LH5813131</column>"+
"<column name='ProgramId'>EP4310</column>"+
"<column name='WorkStationId'>HUANGL1</column>"+
"<column name='DateUpdated'>11/10/99</column>"+
"<column name='TimeOfDay'>100707</column>"+
"</table>"+
"<table name='F4311Z1' type='detail'>"+
"<column name='EdiDocumentType'> </column>"+
"<column name='TypeTransaction'>JDEPOIN</column>"+
"<column name='EdiTranslationFormat'> </column>"+
"<column name='EdiTransmissionDate'> </column>"+
"<column name='DirectionIndicator'>1</column>"+
"<column name='EdiDetailLinesProcess'>0</column>"+
"<column name='EdiSuccessfullyProcess'>N</column>"+
"<column name='TradingPartnerId'> </column>"+
"<column name='TransactionAction'>A</column>"+
"<column name='DocumentOrderInvoiceE'>203</column>"+
"<column name='CompanyKeyOrderNo'>00200</column>"+
"<column name='OrderType'>OP</column>"+
"<column name='OrderSuffix'>000</column>"+
"<!-- default line number is 1 -->"+
"<!-- have to specify line number if multiple records exist -->"+
"<column name='LineNumber'>1.000</column>"+
"<column name='CostCenter'>30</column>"+
"<column name='Company'>00001</column>"+
"<column name='CompanyKeyOriginal'> </column>"+
"<column name='OriginalPoSoNumber'> </column>"+
"<column name='OriginalOrderType'> </column>"+
"<column name='OriginalLineNumber'>0</column>"+
"<column name='CompanyKeyRelated'> </column>"+
"<column name='RelatedPoSoNumber'> </column>"+
"<column name='RelatedOrderType'> </column>"+
"<column name='RelatedPoSoLineNo'>0</column>"+
"<column name='ContractNumberDistributi'> </column>"+
"<column name='ContractSupplementDistri'>0</column>"+
"<column name='ContractBalancesUpdatedY'> </column>"+
"<column name='AddressNumber'>1620</column>"+
"<column name='AddressNumberShipTo'>1620</column>"+
"<column name='DateRequestedJulian'>11/10/99</column>"+
"<column name='DateTransactionJulian'>11/10/99</column>"+
"<column name='SchedulePickDate'>11/10/99</column>"+
"<column name='DateOriginalPromisde'>11/10/99</column>"+
"<column name='ActualShipDate'>11/10/99</column>"+
"<column name='CancelDate'> </column>"+
"<column name='DatePriceEffectiveDate'> </column>"+
"<column name='DatePromisedShipJu'> </column>"+
"<column name='DatePromisedShipJu'> </column>"+
"<column name='DateServiceCurrency'> </column>"+
"<column name='DtForGLAndVouch1'>11/10/99</column>"+
"<column name='PeriodNoGeneralLedge'>0</column>"+
"<column name='Reference1'> </column>"+
"<column name='Reference2Vendor'> </column>"+
"<column name='IdentifierShortItem'>60003</column>"+
"<column name='Identifier2ndItem'>1001</column>"+
"<column name='Identifier3rdItem'>1001</column>"+
"<column name='Location'> </column>"+
"<column name='Lot'> </column>"+
"<column name='FromGrade'> </column>"+
"<column name='ThruGrade'> </column>"+
"<column name='FromPotency'>0</column>"+
"<column name='ThruPotency'>0</column>"+
"<column name='DescriptionLine1'>Bike Rack - Trunk Mount</column>"+
"<column name='DescriptionLine2'> </column>"+
"<column name='LineType'>S</column>"+
"<column name='StatusCodeNext'>280</column>"+
"<column name='StatusCodeLast'>230</column>"+
"<column name='ItemNumberRelatedKit'> </column>"+
"<column name='ReportingCode1Sales'> </column>"+
"<column name='ReportingCode2Sales'> </column>"+
"<column name='ReportingCode3Sales'> </column>"+
"<column name='ReportingCode4Sales'>444</column>"+
"<column name='ReportingCode5Sales'>158</column>"+
"<column name='ReportCode1Purchasing'> </column>"+
"<column name='ReportCode2Purchasing'> </column>"+
"<column name='ReportCode3Purchasing'> </column>"+
"<column name='ReportCode4Purchasing'>240</column>"+
"<column name='ReportCode5Purchasing'> </column>"+
"<column name='UnitOfMeasureAsInput'>EA</column>"+
"<column name='UnitsTransactionQty'>1</column>"+
"<column name='UnitsChangeOrderQty'>0</column>"+
"<column name='UnitsOpenQuantity'>1</column>"+
"<column name='UnitsLineItemQtyRe'>0</column>"+
"<column name='CumulativeReceived'>0</column>"+
"<column name='UnitsRelieved'>0</column>"+
"<column name='OtherQuantity12'> </column>"+
"<column name='PurchasingUnitPrice'>32.1000</column>"+
"<column name='AmountExtendedPrice'>32.10</column>"+
"<column name='AmountChange'>0</column>"+
"<column name='AmountOpen1'>32.10</column>"+
"<column name='AmountReceived'>0</column>"+
"<column name='AmountRelieved'>0</column>"+
"<column name='TaxCommitment'>0</column>"+
"<column name='TaxAmountRelieved'>0</column>"+
"<column name='PriceOverrideCode'> </column>"+
"<column name='UnitCostPurchasing'>32.1000</column>"+
"<column name='AmountExtendedCost'>32.10</column>"+
"<column name='CostOverrideCode'> </column>"+
"<column name='CostMethodPurchasing'> </column>"+
"<column name='PrintMessage1'> </column>"+
"<column name='PriceAdjustmentScheduleN'> </column>"+
"<column name='PricingCategory'> </column>"+
"<column name='PricingCategoryLevel1'> </column>"+
"<column name='CatalogName'> </column>"+
"<column name='DiscountFactor'>1.0000</column>"+
"<column name='PaymentTermsCode01'> </column>"+
"<column name='TaxableYN1'>N</column>"+
"<column name='TaxExplanationCode1'> </column>"+
"<column name='TaxArea1'> </column>"+
"<column name='AssociatedText'> </column>"+
"<column name='ContainerID'> </column>"+
"<column name='CommodityCode'> </column>"+
"<column name='NatureOfTransaction'> </column>"+
"<column name='FreightHandlingCode'> </column>"+
"<column name='FreightCalculatedYN'>N</column>"+
"<column name='ZoneNumber'> </column>"+
"<column name='RateCodeFrieghtMisc'> </column>"+
"<column name='RateTypeFreightMisc'> </column>"+
"<column name='BuyerNumber'>0</column>"+
"<column name='CarrierNumber'>0</column>"+
"<column name='ModeOfTransport'> </column>"+
"<column name='ConditionsOfTransport'> </column>"+
"<column name='ShippingCommodityClass'> </column>"+
"<column name='ShippingConditionsCode'> </column>"+
"<column name='UnitOfMeasurePrimary'>EA</column>"+
"<column name='UnitsPrimaryQtyOrder'>1</column>"+
"<column name='UnitOfMeasureSecondary'>EA</column>"+
"<column name='UnitsSecondaryQtyOr'>1</column>"+
"<column name='UnitOfMeasurePurchas'>EA</column>"+
"<column name='AmountUnitWeight'>80.0000</column>"+
"<column name='WeightUnitOfMeasure'>OZ</column>"+
"<column name='AmountUnitVolume'>2.2500</column>"+
"<column name='VolumeUnitOfMeasure'>FC</column>"+
"<column name='GlClass'>IN30</column>"+
"<column name='Century'>0</column>"+
"<column name='FiscalYear1'>0</column>"+
"<column name='LineStatus'> </column>"+
"<column name='ReasonCode'> </column>"+
"<column name='ApplyFreight'> </column>"+
"<column name='PostQuantities'> </column>"+
"<column name='GrossWeight'>0</column>"+
"<column name='UnitOfMeasureGrossWt'> </column>"+
"<column name='LedgerType'> </column>"+
"<column name='AcctNoInputMode'> </column>"+
"<column name='AccountId'> </column>"+
"<column name='PurchasingCostCenter'> </column>"+
"<column name='ObjectAccount'> </column>"+
"<column name='Subsidiary'> </column>"+
"<column name='SubledgerType'> </column>"+
"<column name='Subledger'> </column>"+
"<column name='SerialTagNumber'> </column>"+
"<column name='CostComponentNumber'>0</column>"+
"<column name='TagReference'> </column>"+
"<column name='CategoriesWorkOrder001'> </column>"+
"<column name='Plan'> </column>"+
"<column name='Elevation'> </column>"+
"<column name='CategoryCodeGl001'> </column>"+
"<column name='RetainageRule'> </column>"+
"<column name='CodeLocationTaxStat'> </column>"+
"<column name='PurgeCode1'> </column>"+
"<column name='ProcessingMode'> </column>"+
"<column name='FinalPayment'> </column>"+
"<column name='CodeAutomaticVoucher'>N</column>"+
"<column name='PrepaymentYN'> </column>"+
"<column name='WoOrderFreezeCode'>N</column>"+
"<column name='TypeMatch'> </column>"+
"<column name='RoutingProcessYN'> </column>"+
"<column name='ReceiptCode'> </column>"+
"<column name='PurchaseOrderStatus01'> </column>"+
"<column name='PurchaseOrderStatus02'> </column>"+
"<column name='PurchaseOrderStatus03'> </column>"+
"<column name='PurchaseOrderStatus04'> </column>"+
"<column name='PurchaseOrderStatus05'> </column>"+
"<column name='PurchaseOrderStatus06'> </column>"+
"<column name='PurchaseOrderStatus07'> </column>"+
"<column name='PurchaseOrderStatus08'> </column>"+
"<column name='PurchaseOrderStatus09'> </column>"+
"<column name='PurchaseOrderStatus10'> </column>"+
"<column name='CorrespondenceMethod'> </column>"+
"<column name='RoutingApproval'>DEMO</column>"+
"<column name='NumberChangeOrder'>0</column>"+
"<column name='ChangeOrderType'> </column>"+
"<column name='DocumentChangeOrder'>0</column>"+
"<column name='ChangeOrderLineNumber'>0</column>"+
"<column name='CurrencyCodeFrom'>USD</column>"+
"<column name='CurrencyConverRateOv'>0</column>"+
"<column name='ForeignPurchasingCost'>0</column>"+
"<column name='AmountForeignExtPrice'>0</column>"+
"<column name='AmountForeignUnitCost'>0</column>"+
"<column name='AmountForeignExtCost'>0</column>"+
"<column name='ForeignChangedAmount'>0</column>"+
"<column name='AmountForeignOpen'>0</column>"+
"<column name='AmountReceivedForeign'>0</column>"+
"<column name='UserReservedCode'> </column>"+
"<column name='UserReservedDate'> </column>"+
"<column name='UserReservedAmount'>0</column>"+
"<column name='UserReservedNumber'>0</column>"+
"<column name='UserReservedReference'> </column>"+
"<column name='TransactionOriginator'>TEST</column>"+
"<column name='UserId'>TEST</column>"+
"<column name='ProgramId'> </column>"+
"<column name='WorkStationId'>HUANGL1</column>"+
"<column name='DateUpdated'>11/10/99</column>"+
"<column name='TimeOfDay'>100712</column>"+
"</table>"+
"<inboundUBE>"+
"<UBEName>R4311Z1I</UBEName>"+
"<UBEVersion>XJDE0002</UBEVersion>"+
"</inboundUBE>"+
"<callbackFunction>"+
"<functionName></functionName>"+
" <functionLibrary></functionLibrary>"+
"</callbackFunction> "+
"</transaction>"+
"</jdeRequest>";
---------------------------------------------------------------------------------------------------------------
After excuting the request, i got the following response:
---------------------------------------------------------------------------------------------------------------
<?xml version='1.0' encoding='UTF-8' ?>
<jdeResponse type='trans' user='PSFT' xmlns='urn:Schemas-jdedwards-com:trans.response.JDEPOIN' session='1900.1142328820.1' environment='DV810'>
<transaction type='JDEPOIN' action='inbound'>
<returnCode code='20'>ERROR</returnCode>
<key>
<column name='EdiUserId'>TEST</column>
<column name='EdiBatchNumber'>110042</column>
<column name='EdiTransactNumber'>1600006</column>
<column name='EdiLineNumber'>1.000</column>
</key>
<writeSubsystemRecord>ERROR</writeSubsystemRecord>
<ERROR>Write subsystem record failed</ERROR>
</transaction>
</jdeResponse>
---------------------------------------------------------------------------------------------------------------
But when i checked the two interface tables F4301Z1 and F4311Z1 by browsing the database,i found that data which sent within request are populated into respective interface tables.
I tried same request with different environment but got the same error.
What could be the possible reasons for this failure?
If anyone has succeessfully tried the data insertion into JDE with inbound transaction,Please guide me more on inbound transactions.If possible please share some examples about inbound transactions so that i can try them.
Thanks in advance,
kiran
I am trying to insert data into JDE OneWorld 8.10 using XML interoperability.For this purpose I have written a xml request for inbound transaction for Inbound Purchase Order.
Request is as follows:
---------------------------------------------------------------------------------------------------------------
String xmlString = "<?xml version='1.0' ?>"+
"<jdeRequest type='trans' user='PSFT' pwd='PSFT' environment='DV810' session='' sessionidle='300'>"+
"<!-- This an Inbound Purchase Order, Should Pass. -->"+
"<transaction action='inbound' type='JDEPOIN'>"+
"<key>"+
"<column name='EdiUserId'>TEST</column>"+
"<column name='EdiBatchNumber'>110042</column>"+
"<column name='EdiTransactNumber'>1600006</column>"+
"<column name='EdiLineNumber'>1.000</column>"+
"</key>"+
"<!-- table name attribute value is optional, cross reference is used -->"+
"<table name='F4301Z1' type='header'>"+
"<column name='EdiDocumentType'> </column>"+
"<column name='TypeTransaction'>JDEPOIN</column>"+
"<column name='EdiTranslationFormat'> </column>"+
"<column name='EdiTransmissionDate'> </column>"+
"<column name='DirectionIndicator'>1</column>"+
"<column name='EdiDetailLinesProcess'>0</column>"+
"<column name='EdiSuccessfullyProcess'>N</column>"+
"<column name='TradingPartnerId'> </column>"+
"<column name='TransactionAction'>A</column>"+
"<column name='DocumentOrderInvoiceE'>204</column>"+
"<column name='CompanyKeyOrderNo'>00200</column>"+
"<column name='OrderType'>OP</column>"+
"<column name='OrderSuffix'>000</column>"+
"<column name='CostCenter'> 27</column>"+
"<column name='CompanyKeyOriginal'> </column>"+
"<column name='OriginalPoSoNumber'> </column>"+
"<column name='OriginalOrderType'> </column>"+
"<column name='CompanyKeyRelated'> </column>"+
"<column name='RelatedPoSoNumber'> </column>"+
"<column name='RelatedOrderType'> </column>"+
"<column name='AddressNumber'>1620</column>"+
"<column name='AddressNumberShipTo'>27</column>"+
"<column name='DateRequestedJulian'>08/10/2003</column>"+
"<column name='DateTransactionJulian'>08/10/2003</column>"+
"<column name='SchedulePickDate'>08/10/2003</column>"+
"<column name='DateOriginalPromisde'>08/10/2003</column>"+
"<column name='ActualShipDate'> </column>"+
"<column name='CancelDate'> </column>"+
"<column name='DatePriceEffectiveDate'> </column>"+
"<column name='DatePromisedShipJu'> </column>"+
"<column name='DatePromisedShipJu'> </column>"+
"<column name='Reference1'> </column>"+
"<column name='Reference2Vendor'> </column>"+
"<column name='DeliveryInstructLine1'> </column>"+
"<column name='DeliveryInstructLine2'> </column>"+
"<column name='NameRemark'> </column>"+
"<column name='Description'> </column>"+
"<column name='PrintMessage1'> </column>"+
"<column name='PriceAdjustmentScheduleN'> </column>"+
"<column name='PricingGroup'> </column>"+
"<column name='PaymentTermsCode01'> </column>"+
"<column name='TaxExplanationCode1'> </column>"+
"<column name='TaxArea1'> </column>"+
"<column name='CertificateTaxExempt'> </column>"+
"<column name='HoldOrdersCode'> </column>"+
"<column name='AssociatedText'> </column>"+
"<column name='InvoiceCopies'>0</column>"+
"<column name='NatureOfTransaction'> </column>"+
"<column name='ContainerID'> </column>"+
"<column name='FreightHandlingCode'> </column>"+
"<column name='ZoneNumber'> </column>"+
"<column name='BuyerNumber'>0</column>"+
"<column name='CarrierNumber'>0</column>"+
"<column name='ModeOfTransport'> </column>"+
"<column name='ConditionsOfTransport'> </column>"+
"<column name='ReasonCode'> </column>"+
"<column name='FreightCalculatedYN'> </column>"+
"<column name='ApplyFreight'>Y</column>"+
"<column name='PostQuantities'>1</column>"+
"<column name='AmountOrderGross'>32.10</column>"+
"<column name='PercentRetainage1'>0</column>"+
"<column name='RetainageRule'> </column>"+
"<column name='UnitOfMeasureWhtDisp'> </column>"+
"<column name='UnitOfMeasureVolDisp'> </column>"+
"<column name='PurgeCode1'> </column>"+
"<column name='LogicControl'> </column>"+
"<column name='ProcessingMode'> </column>"+
"<column name='TypeMatch'> </column>"+
"<column name='StatusPurchaseOrder'> </column>"+
"<column name='CodeAutomaticVoucher'>N</column>"+
"<column name='PrepaymentYN'> </column>"+
"<column name='CorrespondenceMethod'> </column>"+
"<column name='PurchasingReportCode5'> </column>"+
"<column name='RoutingApproval'>DEMO</column>"+
"<column name='NumberChangeOrder'>0</column>"+
"<column name='CurrencyMode'>D</column>"+
"<column name='CurrencyCodeFrom'>USD</column>"+
"<column name='CurrencyConverRateOv'>0</column>"+
"<column name='LanguagePreference'> </column>"+
"<column name='AmountForeignOpen'>0</column>"+
"<column name='OrderedBy'>LH5813131</column>"+
"<column name='OrderTakenBy'> </column>"+
"<column name='UserReservedCode'> </column>"+
"<column name='UserReservedDate'> </column>"+
"<column name='UserReservedAmount'>0</column>"+
"<column name='UserReservedNumber'>0</column>"+
"<column name='UserReservedReference'> </column>"+
"<column name='UserId'>LH5813131</column>"+
"<column name='ProgramId'>EP4310</column>"+
"<column name='WorkStationId'>HUANGL1</column>"+
"<column name='DateUpdated'>11/10/99</column>"+
"<column name='TimeOfDay'>100707</column>"+
"</table>"+
"<table name='F4311Z1' type='detail'>"+
"<column name='EdiDocumentType'> </column>"+
"<column name='TypeTransaction'>JDEPOIN</column>"+
"<column name='EdiTranslationFormat'> </column>"+
"<column name='EdiTransmissionDate'> </column>"+
"<column name='DirectionIndicator'>1</column>"+
"<column name='EdiDetailLinesProcess'>0</column>"+
"<column name='EdiSuccessfullyProcess'>N</column>"+
"<column name='TradingPartnerId'> </column>"+
"<column name='TransactionAction'>A</column>"+
"<column name='DocumentOrderInvoiceE'>203</column>"+
"<column name='CompanyKeyOrderNo'>00200</column>"+
"<column name='OrderType'>OP</column>"+
"<column name='OrderSuffix'>000</column>"+
"<!-- default line number is 1 -->"+
"<!-- have to specify line number if multiple records exist -->"+
"<column name='LineNumber'>1.000</column>"+
"<column name='CostCenter'>30</column>"+
"<column name='Company'>00001</column>"+
"<column name='CompanyKeyOriginal'> </column>"+
"<column name='OriginalPoSoNumber'> </column>"+
"<column name='OriginalOrderType'> </column>"+
"<column name='OriginalLineNumber'>0</column>"+
"<column name='CompanyKeyRelated'> </column>"+
"<column name='RelatedPoSoNumber'> </column>"+
"<column name='RelatedOrderType'> </column>"+
"<column name='RelatedPoSoLineNo'>0</column>"+
"<column name='ContractNumberDistributi'> </column>"+
"<column name='ContractSupplementDistri'>0</column>"+
"<column name='ContractBalancesUpdatedY'> </column>"+
"<column name='AddressNumber'>1620</column>"+
"<column name='AddressNumberShipTo'>1620</column>"+
"<column name='DateRequestedJulian'>11/10/99</column>"+
"<column name='DateTransactionJulian'>11/10/99</column>"+
"<column name='SchedulePickDate'>11/10/99</column>"+
"<column name='DateOriginalPromisde'>11/10/99</column>"+
"<column name='ActualShipDate'>11/10/99</column>"+
"<column name='CancelDate'> </column>"+
"<column name='DatePriceEffectiveDate'> </column>"+
"<column name='DatePromisedShipJu'> </column>"+
"<column name='DatePromisedShipJu'> </column>"+
"<column name='DateServiceCurrency'> </column>"+
"<column name='DtForGLAndVouch1'>11/10/99</column>"+
"<column name='PeriodNoGeneralLedge'>0</column>"+
"<column name='Reference1'> </column>"+
"<column name='Reference2Vendor'> </column>"+
"<column name='IdentifierShortItem'>60003</column>"+
"<column name='Identifier2ndItem'>1001</column>"+
"<column name='Identifier3rdItem'>1001</column>"+
"<column name='Location'> </column>"+
"<column name='Lot'> </column>"+
"<column name='FromGrade'> </column>"+
"<column name='ThruGrade'> </column>"+
"<column name='FromPotency'>0</column>"+
"<column name='ThruPotency'>0</column>"+
"<column name='DescriptionLine1'>Bike Rack - Trunk Mount</column>"+
"<column name='DescriptionLine2'> </column>"+
"<column name='LineType'>S</column>"+
"<column name='StatusCodeNext'>280</column>"+
"<column name='StatusCodeLast'>230</column>"+
"<column name='ItemNumberRelatedKit'> </column>"+
"<column name='ReportingCode1Sales'> </column>"+
"<column name='ReportingCode2Sales'> </column>"+
"<column name='ReportingCode3Sales'> </column>"+
"<column name='ReportingCode4Sales'>444</column>"+
"<column name='ReportingCode5Sales'>158</column>"+
"<column name='ReportCode1Purchasing'> </column>"+
"<column name='ReportCode2Purchasing'> </column>"+
"<column name='ReportCode3Purchasing'> </column>"+
"<column name='ReportCode4Purchasing'>240</column>"+
"<column name='ReportCode5Purchasing'> </column>"+
"<column name='UnitOfMeasureAsInput'>EA</column>"+
"<column name='UnitsTransactionQty'>1</column>"+
"<column name='UnitsChangeOrderQty'>0</column>"+
"<column name='UnitsOpenQuantity'>1</column>"+
"<column name='UnitsLineItemQtyRe'>0</column>"+
"<column name='CumulativeReceived'>0</column>"+
"<column name='UnitsRelieved'>0</column>"+
"<column name='OtherQuantity12'> </column>"+
"<column name='PurchasingUnitPrice'>32.1000</column>"+
"<column name='AmountExtendedPrice'>32.10</column>"+
"<column name='AmountChange'>0</column>"+
"<column name='AmountOpen1'>32.10</column>"+
"<column name='AmountReceived'>0</column>"+
"<column name='AmountRelieved'>0</column>"+
"<column name='TaxCommitment'>0</column>"+
"<column name='TaxAmountRelieved'>0</column>"+
"<column name='PriceOverrideCode'> </column>"+
"<column name='UnitCostPurchasing'>32.1000</column>"+
"<column name='AmountExtendedCost'>32.10</column>"+
"<column name='CostOverrideCode'> </column>"+
"<column name='CostMethodPurchasing'> </column>"+
"<column name='PrintMessage1'> </column>"+
"<column name='PriceAdjustmentScheduleN'> </column>"+
"<column name='PricingCategory'> </column>"+
"<column name='PricingCategoryLevel1'> </column>"+
"<column name='CatalogName'> </column>"+
"<column name='DiscountFactor'>1.0000</column>"+
"<column name='PaymentTermsCode01'> </column>"+
"<column name='TaxableYN1'>N</column>"+
"<column name='TaxExplanationCode1'> </column>"+
"<column name='TaxArea1'> </column>"+
"<column name='AssociatedText'> </column>"+
"<column name='ContainerID'> </column>"+
"<column name='CommodityCode'> </column>"+
"<column name='NatureOfTransaction'> </column>"+
"<column name='FreightHandlingCode'> </column>"+
"<column name='FreightCalculatedYN'>N</column>"+
"<column name='ZoneNumber'> </column>"+
"<column name='RateCodeFrieghtMisc'> </column>"+
"<column name='RateTypeFreightMisc'> </column>"+
"<column name='BuyerNumber'>0</column>"+
"<column name='CarrierNumber'>0</column>"+
"<column name='ModeOfTransport'> </column>"+
"<column name='ConditionsOfTransport'> </column>"+
"<column name='ShippingCommodityClass'> </column>"+
"<column name='ShippingConditionsCode'> </column>"+
"<column name='UnitOfMeasurePrimary'>EA</column>"+
"<column name='UnitsPrimaryQtyOrder'>1</column>"+
"<column name='UnitOfMeasureSecondary'>EA</column>"+
"<column name='UnitsSecondaryQtyOr'>1</column>"+
"<column name='UnitOfMeasurePurchas'>EA</column>"+
"<column name='AmountUnitWeight'>80.0000</column>"+
"<column name='WeightUnitOfMeasure'>OZ</column>"+
"<column name='AmountUnitVolume'>2.2500</column>"+
"<column name='VolumeUnitOfMeasure'>FC</column>"+
"<column name='GlClass'>IN30</column>"+
"<column name='Century'>0</column>"+
"<column name='FiscalYear1'>0</column>"+
"<column name='LineStatus'> </column>"+
"<column name='ReasonCode'> </column>"+
"<column name='ApplyFreight'> </column>"+
"<column name='PostQuantities'> </column>"+
"<column name='GrossWeight'>0</column>"+
"<column name='UnitOfMeasureGrossWt'> </column>"+
"<column name='LedgerType'> </column>"+
"<column name='AcctNoInputMode'> </column>"+
"<column name='AccountId'> </column>"+
"<column name='PurchasingCostCenter'> </column>"+
"<column name='ObjectAccount'> </column>"+
"<column name='Subsidiary'> </column>"+
"<column name='SubledgerType'> </column>"+
"<column name='Subledger'> </column>"+
"<column name='SerialTagNumber'> </column>"+
"<column name='CostComponentNumber'>0</column>"+
"<column name='TagReference'> </column>"+
"<column name='CategoriesWorkOrder001'> </column>"+
"<column name='Plan'> </column>"+
"<column name='Elevation'> </column>"+
"<column name='CategoryCodeGl001'> </column>"+
"<column name='RetainageRule'> </column>"+
"<column name='CodeLocationTaxStat'> </column>"+
"<column name='PurgeCode1'> </column>"+
"<column name='ProcessingMode'> </column>"+
"<column name='FinalPayment'> </column>"+
"<column name='CodeAutomaticVoucher'>N</column>"+
"<column name='PrepaymentYN'> </column>"+
"<column name='WoOrderFreezeCode'>N</column>"+
"<column name='TypeMatch'> </column>"+
"<column name='RoutingProcessYN'> </column>"+
"<column name='ReceiptCode'> </column>"+
"<column name='PurchaseOrderStatus01'> </column>"+
"<column name='PurchaseOrderStatus02'> </column>"+
"<column name='PurchaseOrderStatus03'> </column>"+
"<column name='PurchaseOrderStatus04'> </column>"+
"<column name='PurchaseOrderStatus05'> </column>"+
"<column name='PurchaseOrderStatus06'> </column>"+
"<column name='PurchaseOrderStatus07'> </column>"+
"<column name='PurchaseOrderStatus08'> </column>"+
"<column name='PurchaseOrderStatus09'> </column>"+
"<column name='PurchaseOrderStatus10'> </column>"+
"<column name='CorrespondenceMethod'> </column>"+
"<column name='RoutingApproval'>DEMO</column>"+
"<column name='NumberChangeOrder'>0</column>"+
"<column name='ChangeOrderType'> </column>"+
"<column name='DocumentChangeOrder'>0</column>"+
"<column name='ChangeOrderLineNumber'>0</column>"+
"<column name='CurrencyCodeFrom'>USD</column>"+
"<column name='CurrencyConverRateOv'>0</column>"+
"<column name='ForeignPurchasingCost'>0</column>"+
"<column name='AmountForeignExtPrice'>0</column>"+
"<column name='AmountForeignUnitCost'>0</column>"+
"<column name='AmountForeignExtCost'>0</column>"+
"<column name='ForeignChangedAmount'>0</column>"+
"<column name='AmountForeignOpen'>0</column>"+
"<column name='AmountReceivedForeign'>0</column>"+
"<column name='UserReservedCode'> </column>"+
"<column name='UserReservedDate'> </column>"+
"<column name='UserReservedAmount'>0</column>"+
"<column name='UserReservedNumber'>0</column>"+
"<column name='UserReservedReference'> </column>"+
"<column name='TransactionOriginator'>TEST</column>"+
"<column name='UserId'>TEST</column>"+
"<column name='ProgramId'> </column>"+
"<column name='WorkStationId'>HUANGL1</column>"+
"<column name='DateUpdated'>11/10/99</column>"+
"<column name='TimeOfDay'>100712</column>"+
"</table>"+
"<inboundUBE>"+
"<UBEName>R4311Z1I</UBEName>"+
"<UBEVersion>XJDE0002</UBEVersion>"+
"</inboundUBE>"+
"<callbackFunction>"+
"<functionName></functionName>"+
" <functionLibrary></functionLibrary>"+
"</callbackFunction> "+
"</transaction>"+
"</jdeRequest>";
---------------------------------------------------------------------------------------------------------------
After excuting the request, i got the following response:
---------------------------------------------------------------------------------------------------------------
<?xml version='1.0' encoding='UTF-8' ?>
<jdeResponse type='trans' user='PSFT' xmlns='urn:Schemas-jdedwards-com:trans.response.JDEPOIN' session='1900.1142328820.1' environment='DV810'>
<transaction type='JDEPOIN' action='inbound'>
<returnCode code='20'>ERROR</returnCode>
<key>
<column name='EdiUserId'>TEST</column>
<column name='EdiBatchNumber'>110042</column>
<column name='EdiTransactNumber'>1600006</column>
<column name='EdiLineNumber'>1.000</column>
</key>
<writeSubsystemRecord>ERROR</writeSubsystemRecord>
<ERROR>Write subsystem record failed</ERROR>
</transaction>
</jdeResponse>
---------------------------------------------------------------------------------------------------------------
But when i checked the two interface tables F4301Z1 and F4311Z1 by browsing the database,i found that data which sent within request are populated into respective interface tables.
I tried same request with different environment but got the same error.
What could be the possible reasons for this failure?
If anyone has succeessfully tried the data insertion into JDE with inbound transaction,Please guide me more on inbound transactions.If possible please share some examples about inbound transactions so that i can try them.
Thanks in advance,
kiran
