createInvoiceInterface Operations in Payables Invoice in SOAP web service (createInvoiceInterface payload with Response)

Oracle Shooter

Create Invoice Interface

createInvoiceInterface Operations in Payables Invoice in SOAP web service (createInvoiceInterface payload with Response)

Service WSDL URL: https://servername/fscmService/InvoiceInterfaceService?WSDL

Code for REQUEST PAYLOAD :- “STANDARD INVOICE“


<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/types/" xmlns:inv="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/">
   <soapenv:Header/>
   <soapenv:Body>
      <typ:createInvoiceInterface>
         <typ:invoiceInterfaceHeader>
            <inv:Source>ELECTRONIC INVOICE</inv:Source>
            <inv:OperatingUnit>Snapdeal Private Limited</inv:OperatingUnit>
            <inv:VendorName>Test Supplier  App99</inv:VendorName>
            <inv:VendorSiteCode>DELHI-APP1099</inv:VendorSiteCode>
            <inv:AddTaxToInvoiceAmountFlag>false</inv:AddTaxToInvoiceAmountFlag>
            <inv:Description>Testing From SOAP API</inv:Description>
            <inv:DocumentCategoryCode>STD INV</inv:DocumentCategoryCode>
            <inv:InvoiceAmount currencyCode="INR">200</inv:InvoiceAmount>
            <inv:InvoiceCurrencyCode>INR</inv:InvoiceCurrencyCode>
            <inv:InvoiceDate>2022-12-26</inv:InvoiceDate>
            <inv:InvoiceNumber>SOAP_9001</inv:InvoiceNumber>
            <inv:InvoiceReceivedDate>2022-12-26</inv:InvoiceReceivedDate>
            <inv:InvoiceTypeLookupCode>STANDARD</inv:InvoiceTypeLookupCode>
            <inv:PaymentCurrencyCode>INR</inv:PaymentCurrencyCode>
            <inv:PaymentMethodCode>CHECK</inv:PaymentMethodCode>
            <inv:TermsDate>2022-12-26</inv:TermsDate>
            <inv:TermsName>Immediate</inv:TermsName>
            <inv:InvoiceInterfaceLine>
               <inv:AccountingDate>2022-12-26</inv:AccountingDate>
               <inv:Amount currencyCode="INR">200</inv:Amount>
               <inv:Description>Line-1</inv:Description>
               <inv:DistCodeConcatenated>11.99999.9999.999.5201001.99.99.9999</inv:DistCodeConcatenated>
               <inv:ItemDescription>Line No-1</inv:ItemDescription>
               <inv:LineGroupNumber>1</inv:LineGroupNumber>
               <inv:LineNumber>1</inv:LineNumber>
               <inv:LineTypeLookupCode>ITEM</inv:LineTypeLookupCode>              
            </inv:InvoiceInterfaceLine>            
         </typ:invoiceInterfaceHeader>
      </typ:createInvoiceInterface>
   </soapenv:Body>
</soapenv:Envelope>

Code for REQUEST PAYLOAD :- “DEBIT MEMO INVOICE”


<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/types/" xmlns:inv="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/">
   <soapenv:Header/>
   <soapenv:Body>
      <typ:createInvoiceInterface>
         <typ:invoiceInterfaceHeader>
            <inv:Source>ELECTRONIC INVOICE</inv:Source>
            <inv:OperatingUnit>Snapdeal Private Limited</inv:OperatingUnit>
            <inv:VendorName>Test Supplier  App99</inv:VendorName>
            <inv:VendorSiteCode>DELHI-APP1099</inv:VendorSiteCode>
            <inv:AddTaxToInvoiceAmountFlag>false</inv:AddTaxToInvoiceAmountFlag>
            <inv:Description>Testing From SOAP API</inv:Description>
            <inv:InvoiceAmount currencyCode="INR">-200</inv:InvoiceAmount>
            <inv:InvoiceCurrencyCode>INR</inv:InvoiceCurrencyCode>
            <inv:InvoiceDate>2022-12-26</inv:InvoiceDate>
            <inv:InvoiceNumber>SOAP_8002</inv:InvoiceNumber>
            <inv:InvoiceReceivedDate>2022-12-26</inv:InvoiceReceivedDate>
            <inv:InvoiceTypeLookupCode>DEBIT</inv:InvoiceTypeLookupCode>
            <inv:PaymentCurrencyCode>INR</inv:PaymentCurrencyCode>
            <inv:PaymentMethodCode>CHECK</inv:PaymentMethodCode>
            <inv:TermsDate>2022-12-26</inv:TermsDate>
            <inv:TermsName>Immediate</inv:TermsName>
            <inv:InvoiceInterfaceLine>
               <inv:AccountingDate>2022-12-26</inv:AccountingDate>
               <inv:Amount currencyCode="INR">-200</inv:Amount>
               <inv:Description>Line-1</inv:Description>
               <inv:DistCodeConcatenated>11.99999.9999.999.5201001.99.99.9999</inv:DistCodeConcatenated>
               <inv:ItemDescription>Line No-1</inv:ItemDescription>
               <inv:LineGroupNumber>1</inv:LineGroupNumber>
               <inv:LineNumber>1</inv:LineNumber>
               <inv:LineTypeLookupCode>ITEM</inv:LineTypeLookupCode>              
            </inv:InvoiceInterfaceLine>            
         </typ:invoiceInterfaceHeader>
      </typ:createInvoiceInterface>
   </soapenv:Body>
</soapenv:Envelope>

RESPONSE:- 


<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">
   <env:Header>
      <wsa:Action>http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/InvoiceInterfaceService/createInvoiceInterfaceResponse</wsa:Action>
      <wsa:MessageID>urn:uuid:260e3c86-1451-49ef-ab4e-a8c60042013e</wsa:MessageID>
   </env:Header>
   <env:Body>
      <ns0:createInvoiceInterfaceResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/types/">
         <ns2:result xsi:type="ns0:InvoiceInterfaceHeaderResult" xmlns:ns0="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/" xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:ns1="http://xmlns.oracle.com/adf/svc/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns2="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/types/">
            <ns0:Value>
               <ns0:Source>ELECTRONIC INVOICE</ns0:Source>
               <ns0:OrgId/>
               <ns0:OperatingUnit>Snapdeal Private Limited</ns0:OperatingUnit>
               <ns0:VendorId/>
               <ns0:VendorName>Test Supplier  App99</ns0:VendorName>
               <ns0:VendorNumber xsi:nil="true"/>
               <ns0:VendorSiteCode>DELHI-APP1099</ns0:VendorSiteCode>
               <ns0:VendorSiteId/>
               <ns0:AcctsPayCodeCombinationId xsi:nil="true"/>
               <ns0:AddTaxToInvoiceAmountFlag>false</ns0:AddTaxToInvoiceAmountFlag>
               <ns0:AmountApplicableToDiscount xsi:nil="true"/>
               <ns0:ApplicationId>200</ns0:ApplicationId>
               <ns0:ApplyAdvancesFlag xsi:nil="true"/>
               <ns0:Attribute1 xsi:nil="true"/>
               <ns0:Attribute10 xsi:nil="true"/>
               <ns0:Attribute11 xsi:nil="true"/>
               <ns0:Attribute12 xsi:nil="true"/>
               <ns0:Attribute13 xsi:nil="true"/>
               <ns0:Attribute14 xsi:nil="true"/>
               <ns0:Attribute15 xsi:nil="true"/>
               <ns0:Attribute2 xsi:nil="true"/>
               <ns0:Attribute3 xsi:nil="true"/>
               <ns0:Attribute4 xsi:nil="true"/>
               <ns0:Attribute5 xsi:nil="true"/>
               <ns0:Attribute6 xsi:nil="true"/>
               <ns0:Attribute7 xsi:nil="true"/>
               <ns0:Attribute8 xsi:nil="true"/>
               <ns0:Attribute9 xsi:nil="true"/>
               <ns0:AttributeCategory xsi:nil="true"/>
               <ns0:AwtGroupId xsi:nil="true"/>
               <ns0:AwtGroupName xsi:nil="true"/>
               <ns0:BankChargeBearer xsi:nil="true"/>
               <ns0:CalculateTaxDuringImportFlag>true</ns0:CalculateTaxDuringImportFlag>
               <ns0:ControlAmount xsi:nil="true"/>
               <ns0:CorrectionPeriod xsi:nil="true"/>
               <ns0:CorrectionYear xsi:nil="true"/>
               <ns0:CustomerRegistrationCode xsi:nil="true"/>
               <ns0:CustomerRegistrationNumber xsi:nil="true"/>
               <ns0:DeliveryChannelCode xsi:nil="true"/>
               <ns0:Description>Testing From SOAP API</ns0:Description>
               <ns0:DocumentCategoryCode xsi:nil="true"/>
               <ns0:DocumentSubType xsi:nil="true"/>
               <ns0:ExchangeDate xsi:nil="true"/>
               <ns0:ExchangeRate xsi:nil="true"/>
               <ns0:ExchangeRateType xsi:nil="true"/>
               <ns0:ExclusivePaymentFlag xsi:nil="true"/>
               <ns0:ExternalBankAccountId xsi:nil="true"/>
               <ns0:ExternalDocumentReference xsi:nil="true"/>
               <ns0:GlDate xsi:nil="true"/>
               <ns0:GlobalAttribute1 xsi:nil="true"/>
               <ns0:GlobalAttribute10 xsi:nil="true"/>
               <ns0:GlobalAttribute11 xsi:nil="true"/>
               <ns0:GlobalAttribute12 xsi:nil="true"/>
               <ns0:GlobalAttribute13 xsi:nil="true"/>
               <ns0:GlobalAttribute14 xsi:nil="true"/>
               <ns0:GlobalAttribute15 xsi:nil="true"/>
               <ns0:GlobalAttribute16 xsi:nil="true"/>
               <ns0:GlobalAttribute17 xsi:nil="true"/>
               <ns0:GlobalAttribute18 xsi:nil="true"/>
               <ns0:GlobalAttribute19 xsi:nil="true"/>
               <ns0:GlobalAttribute2 xsi:nil="true"/>
               <ns0:GlobalAttribute20 xsi:nil="true"/>
               <ns0:GlobalAttribute3 xsi:nil="true"/>
               <ns0:GlobalAttribute4 xsi:nil="true"/>
               <ns0:GlobalAttribute5 xsi:nil="true"/>
               <ns0:GlobalAttribute6 xsi:nil="true"/>
               <ns0:GlobalAttribute7 xsi:nil="true"/>
               <ns0:GlobalAttribute8 xsi:nil="true"/>
               <ns0:GlobalAttribute9 xsi:nil="true"/>
               <ns0:GlobalAttributeCategory xsi:nil="true"/>
               <ns0:GoodsReceivedDate xsi:nil="true"/>
               <ns0:GroupId xsi:nil="true"/>
               <ns0:ImportDocumentDate xsi:nil="true"/>
               <ns0:ImportDocumentNumber xsi:nil="true"/>
               <ns0:InvoiceAmount currencyCode="INR">200</ns0:InvoiceAmount>
               <ns0:InvoiceCurrencyCode>INR</ns0:InvoiceCurrencyCode>
               <ns0:InvoiceDate>2022-12-26</ns0:InvoiceDate>
               <ns0:InvoiceId>300000019708017</ns0:InvoiceId>
               <ns0:InvoiceIncludesPrepayFlag xsi:nil="true"/>
               <ns0:InvoiceNumber>SOAP_9004</ns0:InvoiceNumber>
               <ns0:InvoiceReceivedDate>2022-12-26</ns0:InvoiceReceivedDate>
               <ns0:InvoiceTypeLookupCode>STANDARD</ns0:InvoiceTypeLookupCode>
               <ns0:LegalEntityId xsi:nil="true"/>
               <ns0:LegalEntityName xsi:nil="true"/>
               <ns0:NetOfRetainageFlag xsi:nil="true"/>
               <ns0:NoExchangeRateBaseAmount xsi:nil="true"/>
               <ns0:PaidOnBehalfEmployeeId xsi:nil="true"/>
               <ns0:PartyId xsi:nil="true"/>
               <ns0:PartySiteId xsi:nil="true"/>
               <ns0:PayGroupLookupCode xsi:nil="true"/>
               <ns0:PayProcTrxnTypeCode xsi:nil="true"/>
               <ns0:PaymentCrossRate>1</ns0:PaymentCrossRate>
               <ns0:PaymentCrossRateDate xsi:nil="true"/>
               <ns0:PaymentCrossRateType xsi:nil="true"/>
               <ns0:PaymentCurrencyCode>INR</ns0:PaymentCurrencyCode>
               <ns0:PaymentFunction xsi:nil="true"/>
               <ns0:PaymentMethodCode>CHECK</ns0:PaymentMethodCode>
               <ns0:PaymentMethodLookupCode xsi:nil="true"/>
               <ns0:PaymentPriority xsi:nil="true"/>
               <ns0:PaymentReasonCode xsi:nil="true"/>
               <ns0:PaymentReasonComments xsi:nil="true"/>
               <ns0:PONumber xsi:nil="true"/>
               <ns0:PortOfEntryCode xsi:nil="true"/>
               <ns0:PrepayApplyAmount xsi:nil="true"/>
               <ns0:PrepayGlDate xsi:nil="true"/>
               <ns0:PrepayLineNumber xsi:nil="true"/>
               <ns0:PrepayNumber xsi:nil="true"/>
               <ns0:ProductTable xsi:nil="true"/>
               <ns0:Reference1 xsi:nil="true"/>
               <ns0:Reference2 xsi:nil="true"/>
               <ns0:ReferenceKey1 xsi:nil="true"/>
               <ns0:ReferenceKey2 xsi:nil="true"/>
               <ns0:ReferenceKey3 xsi:nil="true"/>
               <ns0:ReferenceKey4 xsi:nil="true"/>
               <ns0:ReferenceKey5 xsi:nil="true"/>
               <ns0:RemittanceMessage1 xsi:nil="true"/>
               <ns0:RemittanceMessage2 xsi:nil="true"/>
               <ns0:RemittanceMessage3 xsi:nil="true"/>
               <ns0:RemitToSupplierName xsi:nil="true"/>
               <ns0:RemitToSupplierId xsi:nil="true"/>
               <ns0:RemitToAddressName xsi:nil="true"/>
               <ns0:RemitToAddressId xsi:nil="true"/>
               <ns0:RelationshipId xsi:nil="true"/>
               <ns0:RemitToSupplierNumber xsi:nil="true"/>
               <ns0:RequesterEmployeeNumber xsi:nil="true"/>
               <ns0:RequesterFirstName xsi:nil="true"/>
               <ns0:RequesterId xsi:nil="true"/>
               <ns0:RequesterLastName xsi:nil="true"/>
               <ns0:SettlementPriority xsi:nil="true"/>
               <ns0:ShipToLocation xsi:nil="true"/>
               <ns0:SupplierTaxExchangeRate xsi:nil="true"/>
               <ns0:SupplierTaxInvoiceDate xsi:nil="true"/>
               <ns0:SupplierTaxInvoiceNumber xsi:nil="true"/>
               <ns0:TaxInvoiceInternalSequence xsi:nil="true"/>
               <ns0:TaxInvoiceRecordingDate xsi:nil="true"/>
               <ns0:TaxRelatedInvoiceId xsi:nil="true"/>
               <ns0:TaxationCountry xsi:nil="true"/>
               <ns0:TermsDate>2022-12-26</ns0:TermsDate>
               <ns0:TermsId xsi:nil="true"/>
               <ns0:TermsName>Immediate</ns0:TermsName>
               <ns0:UniqueRemittanceIdentifier xsi:nil="true"/>
               <ns0:UriCheckDigit xsi:nil="true"/>
               <ns0:USSGLTransactionCode xsi:nil="true"/>
               <ns0:VendorEmailAddress xsi:nil="true"/>
               <ns0:VoucherNumber xsi:nil="true"/>
               <ns0:WorkflowFlag xsi:nil="true"/>
               <ns0:B2BSiteCode xsi:nil="true"/>
               <ns0:B2BProgramName xsi:nil="true"/>
               <ns0:BudgetDate xsi:nil="true"/>
               <ns0:LoadRequestId>-1</ns0:LoadRequestId>
               <ns0:RoutingAttribute1 xsi:nil="true"/>
               <ns0:RoutingAttribute2 xsi:nil="true"/>
               <ns0:RoutingAttribute3 xsi:nil="true"/>
               <ns0:RoutingAttribute4 xsi:nil="true"/>
               <ns0:RoutingAttribute5 xsi:nil="true"/>
               <ns0:FirstPartyRegistrationId xsi:nil="true"/>
               <ns0:FirstPartyRegistrationNumber xsi:nil="true"/>
               <ns0:ThirdPartyRegistrationId xsi:nil="true"/>
               <ns0:ThirdPartyRegistrationNumber xsi:nil="true"/>
               <ns0:Status xsi:nil="true"/>
               <ns0:AttributeDate1 xsi:nil="true"/>
               <ns0:AttributeDate2 xsi:nil="true"/>
               <ns0:AttributeDate3 xsi:nil="true"/>
               <ns0:AttributeDate4 xsi:nil="true"/>
               <ns0:AttributeDate5 xsi:nil="true"/>
               <ns0:AttributeNumber1 xsi:nil="true"/>
               <ns0:AttributeNumber2 xsi:nil="true"/>
               <ns0:AttributeNumber3 xsi:nil="true"/>
               <ns0:AttributeNumber4 xsi:nil="true"/>
               <ns0:AttributeNumber5 xsi:nil="true"/>
               <ns0:ImageDocumentNumber xsi:nil="true"/>
               <ns0:ImageDocumentUri xsi:nil="true"/>
               <ns0:GlobalAttributeDate1 xsi:nil="true"/>
               <ns0:GlobalAttributeDate2 xsi:nil="true"/>
               <ns0:GlobalAttributeDate3 xsi:nil="true"/>
               <ns0:GlobalAttributeDate4 xsi:nil="true"/>
               <ns0:GlobalAttributeDate5 xsi:nil="true"/>
               <ns0:GlobalAttributeNumber1 xsi:nil="true"/>
               <ns0:GlobalAttributeNumber2 xsi:nil="true"/>
               <ns0:GlobalAttributeNumber3 xsi:nil="true"/>
               <ns0:GlobalAttributeNumber4 xsi:nil="true"/>
               <ns0:GlobalAttributeNumber5 xsi:nil="true"/>
               <ns0:CorrelationId xsi:nil="true"/>
               <ns0:RequesterEmailAddress xsi:nil="true"/>
               <ns0:InvoiceInterfaceLine>
                  <ns0:AccountSegment xsi:nil="true"/>
                  <ns0:AccountingDate>2022-12-26</ns0:AccountingDate>
                  <ns0:Amount currencyCode="INR">200</ns0:Amount>
                  <ns0:ApplicationId xsi:nil="true"/>
                  <ns0:AssessableValue xsi:nil="true"/>
                  <ns0:AssetBookTypeCode xsi:nil="true"/>
                  <ns0:AssetCategoryId xsi:nil="true"/>
                  <ns0:AssetsTrackingFlag xsi:nil="true"/>
                  <ns0:Attribute1 xsi:nil="true"/>
                  <ns0:Attribute10 xsi:nil="true"/>
                  <ns0:Attribute11 xsi:nil="true"/>
                  <ns0:Attribute12 xsi:nil="true"/>
                  <ns0:Attribute13 xsi:nil="true"/>
                  <ns0:Attribute14 xsi:nil="true"/>
                  <ns0:Attribute15 xsi:nil="true"/>
                  <ns0:Attribute2 xsi:nil="true"/>
                  <ns0:Attribute3 xsi:nil="true"/>
                  <ns0:Attribute4 xsi:nil="true"/>
                  <ns0:Attribute5 xsi:nil="true"/>
                  <ns0:Attribute6 xsi:nil="true"/>
                  <ns0:Attribute7 xsi:nil="true"/>
                  <ns0:Attribute8 xsi:nil="true"/>
                  <ns0:Attribute9 xsi:nil="true"/>
                  <ns0:AttributeCategory xsi:nil="true"/>
                  <ns0:AwardId xsi:nil="true"/>
                  <ns0:AwtGroupId xsi:nil="true"/>
                  <ns0:AwtGroupName xsi:nil="true"/>
                  <ns0:BalancingSegment xsi:nil="true"/>
                  <ns0:ControlAmount xsi:nil="true"/>
                  <ns0:CostCenterSegment xsi:nil="true"/>
                  <ns0:CostFactorId xsi:nil="true"/>
                  <ns0:CostFactorName xsi:nil="true"/>
                  <ns0:CreditCardTrxId xsi:nil="true"/>
                  <ns0:DefAcctgEndDate xsi:nil="true"/>
                  <ns0:DefAcctgNumberOfPeriods xsi:nil="true"/>
                  <ns0:DefAcctgPeriodType xsi:nil="true"/>
                  <ns0:DefAcctgStartDate xsi:nil="true"/>
                  <ns0:DefaultDistCcid xsi:nil="true"/>
                  <ns0:DeferredAccountingFlag xsi:nil="true"/>
                  <ns0:Description>Line-1</ns0:Description>
                  <ns0:DistCodeCombinationId xsi:nil="true"/>
                  <ns0:DistCodeConcatenated>11.99999.9999.999.5201001.99.99.9999</ns0:DistCodeConcatenated>
                  <ns0:DistributionSetId xsi:nil="true"/>
                  <ns0:DistributionSetName xsi:nil="true"/>
                  <ns0:ExpenditureItemDate xsi:nil="true"/>
                  <ns0:ExpenditureOrganizationId xsi:nil="true"/>
                  <ns0:ExpenditureType xsi:nil="true"/>
                  <ns0:ExternalDocumentLineReference xsi:nil="true"/>
                  <ns0:FinalMatchFlag xsi:nil="true"/>
                  <ns0:GlobalAttribute1 xsi:nil="true"/>
                  <ns0:GlobalAttribute10 xsi:nil="true"/>
                  <ns0:GlobalAttribute11 xsi:nil="true"/>
                  <ns0:GlobalAttribute12 xsi:nil="true"/>
                  <ns0:GlobalAttribute13 xsi:nil="true"/>
                  <ns0:GlobalAttribute14 xsi:nil="true"/>
                  <ns0:GlobalAttribute15 xsi:nil="true"/>
                  <ns0:GlobalAttribute16 xsi:nil="true"/>
                  <ns0:GlobalAttribute17 xsi:nil="true"/>
                  <ns0:GlobalAttribute18 xsi:nil="true"/>
                  <ns0:GlobalAttribute19 xsi:nil="true"/>
                  <ns0:GlobalAttribute2 xsi:nil="true"/>
                  <ns0:GlobalAttribute20 xsi:nil="true"/>
                  <ns0:GlobalAttribute3 xsi:nil="true"/>
                  <ns0:GlobalAttribute4 xsi:nil="true"/>
                  <ns0:GlobalAttribute5 xsi:nil="true"/>
                  <ns0:GlobalAttribute6 xsi:nil="true"/>
                  <ns0:GlobalAttribute7 xsi:nil="true"/>
                  <ns0:GlobalAttribute8 xsi:nil="true"/>
                  <ns0:GlobalAttribute9 xsi:nil="true"/>
                  <ns0:GlobalAttributeCategory xsi:nil="true"/>
                  <ns0:IncludedInTaxableLineFlag xsi:nil="true"/>
                  <ns0:IncomeTaxRegion xsi:nil="true"/>
                  <ns0:InventoryItemId xsi:nil="true"/>
                  <ns0:InvoiceLineId>300000019708018</ns0:InvoiceLineId>
                  <ns0:ItemDescription>Line No-1</ns0:ItemDescription>
                  <ns0:LineGroupNumber>1</ns0:LineGroupNumber>
                  <ns0:LineNumber>1</ns0:LineNumber>
                  <ns0:LineTypeLookupCode>ITEM</ns0:LineTypeLookupCode>
                  <ns0:Manufacturer xsi:nil="true"/>
                  <ns0:MatchOption xsi:nil="true"/>
                  <ns0:ModelNumber xsi:nil="true"/>
                  <ns0:OrgId xsi:nil="true"/>
                  <ns0:ProjectBillableFlag xsi:nil="true"/>
                  <ns0:ProjectCapitalizableFlag xsi:nil="true"/>
                  <ns0:ProjectContextCategory>AP_Invoice_Line</ns0:ProjectContextCategory>
                  <ns0:ProjectContractId xsi:nil="true"/>
                  <ns0:ProjectContractLineId xsi:nil="true"/>
                  <ns0:ProjectExpenditureItemDate xsi:nil="true"/>
                  <ns0:ProjectExpenditureTypeId xsi:nil="true"/>
                  <ns0:ProjectFundingAllocationId xsi:nil="true"/>
                  <ns0:ProjectOrganizationId xsi:nil="true"/>
                  <ns0:ProjectProjectId xsi:nil="true"/>
                  <ns0:ProjectReservedAttribute1 xsi:nil="true"/>
                  <ns0:ProjectReservedAttribute10 xsi:nil="true"/>
                  <ns0:ProjectReservedAttribute2 xsi:nil="true"/>
                  <ns0:ProjectReservedAttribute3 xsi:nil="true"/>
                  <ns0:ProjectReservedAttribute4 xsi:nil="true"/>
                  <ns0:ProjectReservedAttribute5 xsi:nil="true"/>
                  <ns0:ProjectReservedAttribute6 xsi:nil="true"/>
                  <ns0:ProjectReservedAttribute7 xsi:nil="true"/>
                  <ns0:ProjectReservedAttribute8 xsi:nil="true"/>
                  <ns0:ProjectReservedAttribute9 xsi:nil="true"/>
                  <ns0:ProjectTaskId xsi:nil="true"/>
                  <ns0:ProjectUserDefineAttribute1 xsi:nil="true"/>
                  <ns0:ProjectUserDefineAttribute10 xsi:nil="true"/>
                  <ns0:ProjectUserDefineAttribute2 xsi:nil="true"/>
                  <ns0:ProjectUserDefineAttribute3 xsi:nil="true"/>
                  <ns0:ProjectUserDefineAttribute4 xsi:nil="true"/>
                  <ns0:ProjectUserDefineAttribute5 xsi:nil="true"/>
                  <ns0:ProjectUserDefineAttribute6 xsi:nil="true"/>
                  <ns0:ProjectUserDefineAttribute7 xsi:nil="true"/>
                  <ns0:ProjectUserDefineAttribute8 xsi:nil="true"/>
                  <ns0:ProjectUserDefineAttribute9 xsi:nil="true"/>
                  <ns0:ProjectWorkTypeId xsi:nil="true"/>
                  <ns0:PaAdditionFlag>false</ns0:PaAdditionFlag>
                  <ns0:PaCcArInvoiceId xsi:nil="true"/>
                  <ns0:PaCcArInvoiceLineNumber xsi:nil="true"/>
                  <ns0:PaCcProcessedCode xsi:nil="true"/>
                  <ns0:PaQuantity xsi:nil="true"/>
                  <ns0:PackingSlip xsi:nil="true"/>
                  <ns0:POHeaderId xsi:nil="true"/>
                  <ns0:PONumber xsi:nil="true"/>
                  <ns0:POLineId xsi:nil="true"/>
                  <ns0:POLineNumber xsi:nil="true"/>
                  <ns0:POLineLocationId xsi:nil="true"/>
                  <ns0:POShipmentNumber xsi:nil="true"/>
                  <ns0:PODistributionId xsi:nil="true"/>
                  <ns0:PODistributionNumber xsi:nil="true"/>
                  <ns0:POReleaseId xsi:nil="true"/>
                  <ns0:PriceCorrectInvoiceLineNumber xsi:nil="true"/>
                  <ns0:PriceCorrectInvoiceNumber xsi:nil="true"/>
                  <ns0:PriceCorrectionFlag xsi:nil="true"/>
                  <ns0:PrimaryIntendedUse xsi:nil="true"/>
                  <ns0:ProductCategory xsi:nil="true"/>
                  <ns0:ProductFiscClassification xsi:nil="true"/>
                  <ns0:ProductTable xsi:nil="true"/>
                  <ns0:ProductType xsi:nil="true"/>
                  <ns0:ProjectId xsi:nil="true"/>
                  <ns0:ProrateAcrossFlag xsi:nil="true"/>
                  <ns0:PurchasingCategory xsi:nil="true"/>
                  <ns0:PurchasingCategoryId xsi:nil="true"/>
                  <ns0:InvoicedQuantity xsi:nil="true"/>
                  <ns0:RcvTransactionId xsi:nil="true"/>
                  <ns0:ReceiptLineNumber xsi:nil="true"/>
                  <ns0:ReceiptNumber xsi:nil="true"/>
                  <ns0:Reference1 xsi:nil="true"/>
                  <ns0:Reference2 xsi:nil="true"/>
                  <ns0:ReferenceKey1 xsi:nil="true"/>
                  <ns0:ReferenceKey2 xsi:nil="true"/>
                  <ns0:ReferenceKey3 xsi:nil="true"/>
                  <ns0:ReferenceKey4 xsi:nil="true"/>
                  <ns0:ReferenceKey5 xsi:nil="true"/>
                  <ns0:ReleaseNumber xsi:nil="true"/>
                  <ns0:RequesterEmployeeNumber xsi:nil="true"/>
                  <ns0:RequesterFirstName xsi:nil="true"/>
                  <ns0:RequesterId xsi:nil="true"/>
                  <ns0:RequesterLastName xsi:nil="true"/>
                  <ns0:SerialNumber xsi:nil="true"/>
                  <ns0:ShipToLocationCode xsi:nil="true"/>
                  <ns0:ShipToLocationId xsi:nil="true"/>
                  <ns0:SourceApplicationId xsi:nil="true"/>
                  <ns0:SourceEntityCode xsi:nil="true"/>
                  <ns0:SourceEventClassCode xsi:nil="true"/>
                  <ns0:SourceLineId xsi:nil="true"/>
                  <ns0:SourceTrxId xsi:nil="true"/>
                  <ns0:SourceTrxLevelType xsi:nil="true"/>
                  <ns0:StatisticalAmount xsi:nil="true"/>
                  <ns0:TaskId xsi:nil="true"/>
                  <ns0:Tax xsi:nil="true"/>
                  <ns0:TaxClassificationCode xsi:nil="true"/>
                  <ns0:TaxCode xsi:nil="true"/>
                  <ns0:TaxCodeId xsi:nil="true"/>
                  <ns0:TaxJurisdictionCode xsi:nil="true"/>
                  <ns0:TaxRate xsi:nil="true"/>
                  <ns0:TaxRateCode xsi:nil="true"/>
                  <ns0:TaxRateId xsi:nil="true"/>
                  <ns0:TaxRegimeCode xsi:nil="true"/>
                  <ns0:TaxStatusCode xsi:nil="true"/>
                  <ns0:TaxableFlag xsi:nil="true"/>
                  <ns0:TrxBusinessCategory xsi:nil="true"/>
                  <ns0:Type1099 xsi:nil="true"/>
                  <ns0:UnitOfMeasLookupCode xsi:nil="true"/>
                  <ns0:UnitPrice xsi:nil="true"/>
                  <ns0:UserDefinedFiscClass xsi:nil="true"/>
                  <ns0:USSGLTransactionCode xsi:nil="true"/>
                  <ns0:VendorItemNumber xsi:nil="true"/>
                  <ns0:WarrantyNumber xsi:nil="true"/>
                  <ns0:BudgetDate xsi:nil="true"/>
                  <ns0:ConsumptionAdviceHeaderId xsi:nil="true"/>
                  <ns0:ConsumptionAdviceLineId xsi:nil="true"/>
                  <ns0:ConsumptionAdviceNumber xsi:nil="true"/>
                  <ns0:ConsumptionAdviceLineNumber xsi:nil="true"/>
                  <ns0:ShipFromLocationId xsi:nil="true"/>
                  <ns0:ShipFromLocationCode xsi:nil="true"/>
                  <ns0:FinalDischargeLocationId xsi:nil="true"/>
                  <ns0:FinalDischargeLocationCode xsi:nil="true"/>
                  <ns0:PjcExpenditureTypeName xsi:nil="true"/>
                  <ns0:PjcOrganizationName xsi:nil="true"/>
                  <ns0:PjcProjectName xsi:nil="true"/>
                  <ns0:PjcTaskNumber xsi:nil="true"/>
                  <ns0:PjcProjectNumber xsi:nil="true"/>
                  <ns0:PjcTaskName xsi:nil="true"/>
                  <ns0:PjcWorkType xsi:nil="true"/>
                  <ns0:PjcContractName xsi:nil="true"/>
                  <ns0:PjcContractNumber xsi:nil="true"/>
                  <ns0:PjcFundingSourceName xsi:nil="true"/>
                  <ns0:PjcFundingSourceNumber xsi:nil="true"/>
                  <ns0:DefAcctgAccrualCcid xsi:nil="true"/>
                  <ns0:DefAccrualCodeConcatenated xsi:nil="true"/>
               </ns0:InvoiceInterfaceLine>
            </ns0:Value>
         </ns2:result>
      </ns0:createInvoiceInterfaceResponse>
   </env:Body>
</env:Envelope>

Comments

Post a Comment

Popular posts from this blog

E-Text Report In Fusion | Types of E-Text reports

 WHAT IS Oracle Fusion E-Text Report ? An eText template is an RTF-based template that is used to generate text output  for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). How it generate the output for User or Bank? At runtime, BI Publisher applies this template to an input XML data file to create an output text file. that can be transmitted to a bank or other customer.  Because the output is intended for electronic communication, the eText templates must follow very specific format instructions for exact placement of data. Example :- Bank payment file , Bank MT940 File .. etc what is look and feel of this file ? Note:  There are two types of eText templates:  1. fixed-position based (EFT templates)  2. Delimiter-based (EDI templates) What IS EFT File? An EFT is an electronic transmission of financial data and payments to banks in a specific fixed-position format flat file (text). Link for download:- EFT :-  https://docs.google....
Read more

Supplier API's

API's for Create Supplier, Create Supplier Site, Create Supplier Site Contacts --======================================================================= -------------Supplier API ------------- 1. First Write a CURSOR for Required Data 2. FND_GLOBAL.APPS_INITIALIZE 3. Pass required Values in Proper way. 4. API :- For Supplier Create (pos_vendor_pub_pkg.create_vendor)    API :- For Supplier Site Create (pos_vendor_pub_pkg.create_vendor_site)    API :- For Supplier Create Contact (ap_vendor_pub_pkg.create_vendor_contact) 5. Run API 6. Checking ------------------------------  Query For APPS_INITIALIZE   --------------------------------------------- select 'USER_ID' REMARKS , user_name NAME, user_id ID from fnd_user where user_name like 'DEVELOPER' union select 'RESPONSIBILITY_ID' NAME, responsibility_name , RESPONSIBILITY_ID from fnd_responsibility_tl where responsibility_name like 'Payables Manager' union s...
Read more

How to pass default Parameter in cursor

--==================================================== --Parameterized Cursors /* Syntax of Parameterized Cursor :- CURSOR cur _ name (parameter list may be one, two, or more or Default ) IS SELECT statement; OPEN cur _ name (Parameter value) */ EMPNO ENAME HIREDATE DOB GENDER SAL DEPTNO COMM 1000 Sachin 11-Sep-85 01-Mar-20 M 25000 20 1002 Rena 01-Aug-82 11-Mar-20 F 125000 20 1008 Sonu 11-Sep-85 01-Mar-20 M 2500 10 100 1003 Chavi 25-Mar-81 15-Feb-20 F 5000 20 1006 Ravi 11-Sep-89 01-Mar-19 M 2500 10 100 1005 Vinod 18-Sep-86 01-Mar-20 ...
Read more