0 Replies Latest reply on Apr 4, 2017 8:50 AM by Ramakkagari Mahesh

    Unable to import journal entry data into GL_INTERFACE table using Fusion Soap WSDL

    Ramakkagari Mahesh

      Hi All,

       

      I am trying to import journal entry details into GL_INTERFACE table using Fusion Soap WSDL URL in Soap UI Tool. But I am getting the below issue in the response after executing the payload request.

       

      Below is the WSDL URL:

       

      https://hostdetails/finGlDesktopEntry/JournalImportService?WSDL

       

      Operation:

       

      importJournals

       

      Payload Data :

       

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/generalLedger/journals/desktopEntry/journalImportService/types/" xmlns:jour="http://xmlns.oracle.com/apps/financials/generalLedger/journals/desktopEntry/journalImportService/" xmlns:acc="http://xmlns.oracle.com/apps/financials/generalLedger/accounts/codeCombinations/publicFlex/Account/">

         <soapenv:Header/>

         <soapenv:Body>

            <typ:importJournals>

               <typ:interfaceRows>

                  <!--Optional:-->

                  <jour:BatchName>LumpsumRequest_Estimate_amount</jour:BatchName>

                  <!--Optional:-->

                  <jour:BatchDescription>LumpsumRequest_Estimate_amount Reservation</jour:BatchDescription>

                  <!--Optional:-->

                  <jour:LedgerId>300000001083006</jour:LedgerId>

                  <!--Optional:-->

                  <jour:AccountingPeriodName>Mar-2017</jour:AccountingPeriodName>

                  <!--Optional:-->

                  <jour:AccountingDate>2017-03-01</jour:AccountingDate>

                  <!--Optional:-->

                  <jour:UserSourceName>Spreadsheet</jour:UserSourceName>

                  <!--Optional:-->

                  <jour:UserCategoryName>Adjustment</jour:UserCategoryName>

                  <!--Optional:-->

                  <jour:ErrorToSuspenseFlag>false</jour:ErrorToSuspenseFlag>

                  <!--Optional:-->

                  <jour:SummaryFlag>false</jour:SummaryFlag>

                  <!--Zero or more repetitions:-->

                  <jour:GlInterface>

                   <!--Optional:-->

                     <jour:LedgerId>300000001083006</jour:LedgerId>

                     <!--Optional:-->

                     <jour:PeriodName>Mar-2017</jour:PeriodName>

                     <!--Optional:-->

                     <jour:AccountingDate>2017-03-01</jour:AccountingDate>

                     <!--Optional:-->

                     <jour:UserJeSourceName>Spreadsheet</jour:UserJeSourceName>

                     <!--Optional:-->

                     <jour:UserJeCategoryName>Adjustment</jour:UserJeCategoryName>

                     <!--Optional:-->

                     <jour:BalanceType>C</jour:BalanceType>

                     <!--Optional:-->

                     <jour:CodeCombinationId>300000001516280</jour:CodeCombinationId>

                     <!--Optional:-->

                     <jour:CurrencyCode>USD</jour:CurrencyCode>

                     <!--Optional:-->

                     <jour:EnteredCrAmount currencyCode="USD">25000</jour:EnteredCrAmount>     

                     <!--Optional:-->

                     <jour:AccountedCr>25000</jour:AccountedCr>

                     <!--Optional:-->

                     <jour:UserCurrencyConversionType>Corporate</jour:UserCurrencyConversionType>

                     <!--Optional:-->

                     <jour:CurrencyConversionDate>2017-03-01</jour:CurrencyConversionDate>

                     <!--Optional:-->

                     <jour:CurrencyConversionRate>1</jour:CurrencyConversionRate>

                     <!--Optional:-->

                     <jour:CurrencyConversionType>Corporate</jour:CurrencyConversionType>

                     <!--Optional:-->

                     <jour:TransactionDate>2017-03-04</jour:TransactionDate>

        <!--Optional:-->

                        <acc:SummaryFlag>FALSE</acc:SummaryFlag>

                        <!--Optional:-->

                        <acc:DetailPostingAllowedFlag>True</acc:DetailPostingAllowedFlag>

                        <!--Optional:-->

                        <acc:AccountType>Expense</acc:AccountType>

                        <!--Optional:-->

                        <acc:DetailBudgetingAllowedFlag>True</acc:DetailBudgetingAllowedFlag>

                        <!--Optional:-->               

                        <acc:EnabledFlag>True</acc:EnabledFlag>

                     <!--Optional:-->

                     <jour:AccountKFF>

        <!--Optional:-->

                        <acc:SummaryFlag>FALSE</acc:SummaryFlag>

                        <!--Optional:-->

                        <acc:DetailPostingAllowedFlag>True</acc:DetailPostingAllowedFlag>

                        <!--Optional:-->

                        <acc:AccountType>Expense</acc:AccountType>

                        <!--Optional:-->

                        <acc:DetailBudgetingAllowedFlag>True</acc:DetailBudgetingAllowedFlag>

                        <!--Optional:-->               

                        <acc:EnabledFlag>True</acc:EnabledFlag>

                     </jour:AccountKFF>

                  </jour:GlInterface>

               </typ:interfaceRows>

            </typ:importJournals>

         </soapenv:Body>

      </soapenv:Envelope>

       

      Could you please help me in fixing this issue:

       

      Error in Response:

       

      <tns:message>Unable to find the view definition for discriminator value: 101</tns:message>

                     <tns:severity>SEVERITY_ERROR</tns:severity>

       

      Regards,

      Mahesh