Unable to load GL journals using SOAP — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Unable to load GL journals using SOAP

edited Jun 24, 2021 1:19PM in General Ledger & Intercompany 1 comment

Summary

Using apex_web_service.make_request to call JournalImportService - response result 0 but no data is inserted in interface table

Content

Hi community,

Has anybody successfully imported GL journals/journal lines into fusion cloud using SOAP from PL/SQL?

I am trying to do this using apex_web_service.make_request. I am aparantly getting OK result code as response from the web service;

RESPONSE:

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/&quot; 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:82cda4ff-6dc8-4ccb-8658-d0ca6a1ed398</wsa:MessageID></env:Header><env:Body><ns0:importJournalsAsyncResponse

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!