GL Web Services
Discussion List
-
update journal line DFF before posting the journalSummary: I need a web service (REST or SOAP) to update a journal line dff in Oracle Fusion 24D. Content (please ensure you mask any confidential information): I found th…Nermin Khaled-Oracle 9 views 0 comments 0 points Started by Nermin Khaled-Oracle General Ledger & Intercompany -
Has anyone uploaded a GL Journal using web services that contain Regionalization global_attributes?Summary: Hi experts. Can anyone shed any light on why global_attributexx values are not uploaded into gl_interface when using the SOAP JournalImportService. The journal …
-
Update the value of a supporting reference in a journal lineSummary: Update the value of a supporting reference in a journal line Content (please ensure you mask any confidential information): Hello everyone, Is it possible to up…
-
Journal approval API/SOAP/ESS JobSummary: Options to automate journal approval process. Content (please ensure you mask any confidential information): Hi everyone, I am exploring options to automate jou…
-
Can EDMCS integrate with Oracle GL ERP to delete/remove hierarchies without uploading FBDI in OracleCan EDMCS integrate with Oracle GL ERP to delete/remove hierarchies without uploading FBDI in Oracle? -
Do we have any currency rates api/rest service to create fx rates realtime?Summary: From the Oracle doc, I could only see GET API but need to create rates at realtime? Content (please ensure you mask any confidential information): Version (incl…Sumana Bhattacharjee_ 11 views 1 comment 0 points Most recent by NarendhreN M-Oracle General Ledger & Intercompany
-
What are the possible statuses returned by an ESS Job in REST APISummary: Content (please ensure you mask any confidential information): I am submitting an ESS job and checking the status. I want to understand what are all the possibl…Jaeyshree K K 13 views 2 comments 0 points Most recent by Jaeyshree K K General Ledger & Intercompany
-
MaxFetchLimit setting in REST API generates errorSummary: We are trying to get the GL balances using REST API (LedgerBalances) but having issues with large volumes. Documentation says to add MaxFetchLimit = N to allow …hayley Lawrence 11 views 2 comments 0 points Most recent by woodyatmove General Ledger & Intercompany
-
REST API SLA Response Times for varying volumesSummary: Response time for REST API with varying volume of entries. Content (please ensure you mask any confidential information): We are using the following REST API to…Nimish Doke 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Loading 200 Daily rates, but wanted to restrict 23 currencies for Journal/Invoice processSummary: Loading 200 Daily rates, but wanted to restrict 23 currencies for Journal/Invoice process. Can you please suggest any process to restrict the processing of Jour…Linga Murthy 41 views 4 comments 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
How to access related value sets using Rest APISummary: Need to access related value sets for an value set to get values from related value set. Content (please ensure you mask any confidential information): Version …Shailendra9844 31 views 3 comments 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany
-
How can I update the journal header programmatically?Summary: Our client has 1 requirement. We use OIC to convert XML data to GL Interface files and submit them to Fusion. Once the files have been successfully submitted, i…Siau Chuan Hor 24 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
whats argument2 in Load Interface File for ImportSummary: whats argument2 in Load Interface File for Import Content (please ensure you mask any confidential information): Im trying to submit Load Interface File for Imp…Jaeyshree Kumaran Kalpana 12 views 1 comment 0 points Most recent by Pooja Asthana-Oracle General Ledger & Intercompany
-
BI Publisher - Object_version_number column in gl_je_headers tableDear All, After creating a journal manually, the object_version_number in gl_je_headers is set directly to the value 3. Can anyone tell me what the purpose of this colum…George Mattar 11 views 1 comment 0 points Most recent by Uddipta Bhaumik-Oracle General Ledger & Intercompany
-
Retrieve Trial Balance via APINeed an API that allows me to retrieve the trial balance data.Khaled Elashkar 33 views 6 comments 0 points Most recent by Karun_Jain-Oracle General Ledger & Intercompany
-
Error in loading Journals/batches attachments using ERPObjectAttachment ServiceSummary: Hi Team, We are trying to load journal attachments using ERPAttachment SOAP service, but getting below errors, any pointers to what roles are needed, seeded Gen…raban 18 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
GL RVC OPERATOR ORACLE ERP CLOUDHello, In the RVC rule how to set up a rule containing the different of zero. The different operator seems not to work on zero values. Thanks -
Is there a scheduled job (ESS) or an OIC feature that allows importing related value sets ?Hi, The related value sets function has been released in 20D version that allows us to link one value set to another, enabling or restricting combinations between two va…Thibault Dufnerr 32 views 5 comments 0 points Most recent by Thibault Dufnerr General Ledger & Intercompany -
Getting error when trying process Reverse multiple Journal Batches using REST ( Doc ID 2739516.1 )Summary: Getting error when trying to process Reverse multiple Journal Batches using REST ( Doc ID 2739516.1 ) Content (please ensure you mask any confidential informati…Shikha_Singh12 3 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
What is the REST API for Account hierarchy in Oracle fusion Cloud FinancialsSummary: REST API for Account hierarchy in Oracle fusion Cloud Financials Content (please ensure you mask any confidential information): Version (include the version you…
-
Any REST API to set Auto Post criteria parametersWe are looking for a REST API which can set the parameters for auto post criteria.BiswajitPaul 31 views 3 comments 0 points Most recent by Anca S-Oracle General Ledger & Intercompany
-
How to Extract Chart of Accounts Values and HierarchiesSummary How to Extract Chart of Accounts Values and HierarchiesContent Hi I would just like to inquire if there is a standard report (OTBI), program or an API that can e…JOHANN CHRISTIAN MORDENO 744 views 9 comments 4 points Most recent by Truptesh Solanki General Ledger & Intercompany
-
GL Accounting Period Open/Close Update REST APIHi, We need to create a PAAS application to allow users to enter the period details to open and close the STAT leger periods. By using PAAS application to implement that…Praveen_Paul_raj 180 views 4 comments 0 points Most recent by Praveen_Paul_raj General Ledger & Intercompany
-
How to test CVR without creating journal or even going to Create Journal pageLet's say I have 200 Cross Validation Rule setup in the system and I want to test it. What are my ways to test the CVR if it is working or not without going to the Creat…Butch Melvin 13 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany
-
How to ensure valid Oracle GL Fusion code combinations are generated by source non-Oracle systemsSummary: How do we publish code combinations defined and available in Fusion GL to non-Oracle systems? Currently I see that even the Export/import action is disabled for…
-
How to retrieve value sets relationships with REST APISummary: Hello, Some chart of accounts value sets are related to each other. How can I retrieve the relationships between the values of these sets using a REST API? Than…Olivier Dupret 22 views 1 comment 1 point Most recent by RajendraV-Oracle General Ledger & Intercompany -
Funds Check SQL or APISummary: Is there a REST / SOAP API available to check funds in Oracle ERP Cloud General Ledger? If not, what would be the SQL / related tables to fetch the fund availab…Prithis 39 views 2 comments 0 points Most recent by Pooja Asthana-Oracle General Ledger & Intercompany
-
Outbound extract of GL BalancesSummary Outbound extract of GL BalancesContent Hi, Could someone suggest the best approach to extract GL balances on daily basis(incremental) and send it to third party …
-
is there a rest or soap service were we can query account combinationsSummary: We have a mail room that collects minimum data (2 segments of a 9 segment coa). We want a service that can call to look up the correct combinations for the othe…Mark Polito 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
REST APISummary: Is there any REST API available for related Value Sets? Content (please ensure you mask any confidential information): Version (include the version you are usin…Gupta Amit 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany