Forum Stats

  • 3,727,349 Users
  • 2,245,373 Discussions
  • 7,852,749 Comments

Discussions

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

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

This discussion has been closed.