Tech Trainings

Oracle Cloud ERP – Journal Import Using SOAP WSDL

October 10, 2020 by admin

Journal Import Using SOAP WSDL Involves the below steps :

1. Load the data into the GL_INTERFACE tables using the SOAP WSDL : https://servername/fscmService/JournalImportService?WSDL
2. Run the ESS : Import Journals : to load the data from Interface table to base tables

*Tips : make sure to mention Group ID for every Journal Import and always validate the data inserted in the interface table

--Sample Request Payload for : ImportJournals Method
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Header>
      <wsse:Security soap:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
         <wsu:Timestamp wsu:Id="TS-25A23F3340EB6EF050160233802922342">
            <wsu:Created>2020-10-10T13:53:49.223Z</wsu:Created>
            <wsu:Expires>2020-10-12T00:11:25.223Z</wsu:Expires>
         </wsu:Timestamp>
         <wsse:UsernameToken wsu:Id="UsernameToken-25A23F3340EB6EF050160233802129841">
            <wsse:Username>casey.brown</wsse:Username>
            <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">Hpc43594</wsse:Password>
            <wsse:Nonce EncodingType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary">XBqjTLZQcw+/XDW3+mINDA==</wsse:Nonce>
            <wsu:Created>2020-10-10T13:53:41.298Z</wsu:Created>
         </wsse:UsernameToken>
      </wsse:Security>
   </soap:Header>
   <soap:Body>
      <ns1:importJournalsAsync xmlns:ns1="http://xmlns.oracle.com/apps/financials/generalLedger/journals/desktopEntry/journalImportService/types/">
         <ns1:interfaceRows xmlns:ns2="http://xmlns.oracle.com/apps/financials/generalLedger/journals/desktopEntry/journalImportService/">
            <ns2:BatchName>XXGLBatchOCt2020_90002</ns2:BatchName>
            <ns2:BatchDescription>XXGLBatchOCt2020_90002_Desc</ns2:BatchDescription>
            <ns2:LedgerId>300000101474319</ns2:LedgerId>
            <ns2:AccountingPeriodName>10-20</ns2:AccountingPeriodName>
            <ns2:AccountingDate>2020-10-10</ns2:AccountingDate>
            <ns2:UserSourceName>Manual</ns2:UserSourceName>
            <ns2:UserCategoryName>Manual</ns2:UserCategoryName>
            <ns2:ErrorToSuspenseFlag>True</ns2:ErrorToSuspenseFlag>
            <ns2:SummaryFlag>True</ns2:SummaryFlag>
            <ns2:ImportDescriptiveFlexField>N</ns2:ImportDescriptiveFlexField>
            <ns2:GlInterface>
               <ns2:LedgerId>300000101474319</ns2:LedgerId>
               <ns2:PeriodName>10-20</ns2:PeriodName>
               <ns2:AccountingDate>2020-10-10</ns2:AccountingDate>
               <ns2:UserJeSourceName>Manual</ns2:UserJeSourceName>
               <ns2:UserJeCategoryName>Manual</ns2:UserJeCategoryName>
               <ns2:GroupId>90002</ns2:GroupId>
               <ns2:ChartOfAccountsId/>
               <ns2:BalanceType>A</ns2:BalanceType>
               <ns2:CodeCombinationId/>
               <ns2:Segment1>110</ns2:Segment1>
               <ns2:Segment2>00000</ns2:Segment2>
               <ns2:Segment3>11310</ns2:Segment3>
               <ns2:Segment4>00</ns2:Segment4>
               <ns2:Segment5>00000</ns2:Segment5>
               <ns2:Segment6>000</ns2:Segment6>
               <ns2:Segment7>000</ns2:Segment7>
               <ns2:Segment8>00000</ns2:Segment8>
               <ns2:CurrencyCode>USD</ns2:CurrencyCode>
               <ns2:EnteredCrAmount currencyCode="USD">250.00</ns2:EnteredCrAmount>
               <ns2:AccountedCr/>
               <ns2:AccountedDr/>
            </ns2:GlInterface>
            <ns2:GlInterface>
               <ns2:LedgerId>300000101474319</ns2:LedgerId>
               <ns2:PeriodName>10-20</ns2:PeriodName>
               <ns2:AccountingDate>2020-10-10</ns2:AccountingDate>
               <ns2:UserJeSourceName>Manual</ns2:UserJeSourceName>
               <ns2:UserJeCategoryName>Manual</ns2:UserJeCategoryName>
               <ns2:GroupId>90002</ns2:GroupId>
               <ns2:ChartOfAccountsId/>
               <ns2:BalanceType>A</ns2:BalanceType>
               <ns2:CodeCombinationId/>
               <ns2:Segment1>110</ns2:Segment1>
               <ns2:Segment2>00000</ns2:Segment2>
               <ns2:Segment3>11310</ns2:Segment3>
               <ns2:Segment4>00</ns2:Segment4>
               <ns2:Segment5>00000</ns2:Segment5>
               <ns2:Segment6>000</ns2:Segment6>
               <ns2:Segment7>000</ns2:Segment7>
               <ns2:Segment8>00000</ns2:Segment8>
               <ns2:CurrencyCode>USD</ns2:CurrencyCode>
               <ns2:EnteredDrAmount currencyCode="USD">250.00</ns2:EnteredDrAmount>
               <ns2:AccountedCr/>
               <ns2:AccountedDr/>
            </ns2:GlInterface>
         </ns1:interfaceRows>
      </ns1:importJournalsAsync>
   </soap:Body>
</soap:Envelope>

--Sample Response for the above request  (0 is success)
<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/generalLedger/journals/desktopEntry/journalImportService/importJournalsAsyncResponse</wsa:Action>
      <wsa:MessageID>urn:uuid:ef52c5b3-8fc9-4cf2-aadc-1861e3ebce11</wsa:MessageID>
      <wsse:Security env:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
         <wsu:Timestamp wsu:Id="Timestamp-KETySx70B1tTL37gAsVJaw22" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
            <wsu:Created>2020-10-10T13:57:59Z</wsu:Created>
            <wsu:Expires>2020-10-14T01:17:59Z</wsu:Expires>
         </wsu:Timestamp>
      </wsse:Security>
   </env:Header>
   <env:Body>
      <ns0:importJournalsAsyncResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/generalLedger/journals/desktopEntry/journalImportService/types/">
         <result xmlns="http://xmlns.oracle.com/apps/financials/generalLedger/journals/desktopEntry/journalImportService/types/">0</result>
      </ns0:importJournalsAsyncResponse>
   </env:Body>
</env:Envelope>

--DB Query Details

select REFERENCE1 , REFERENCE2, 
STATUS, ACCOUNTING_DATE ,CURRENCY_CODE,DATE_CREATED,CREATED_BY,ACTUAL_FLAG, ENTERED_DR , ENTERED_CR ,
PERIOD_NAME , USER_JE_CATEGORY_NAME, GROUP_ID , USER_JE_SOURCE_NAME , SET_OF_BOOKS_ID,
SEGMENT1,SEGMENT2,SEGMENT3,SEGMENT4,SEGMENT5,SEGMENT6,SEGMENT7,SEGMENT8
 from  gl_interface
where trunc(creation_date) = trunc(sysdate) 


select * from gl_je_batches

select * from gl_je_headers

select * from gl_je_lines 

Comments |0|