Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
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

Unable to load GL journals using SOAP

Accepted answer
14
Views
1
Comments
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!