GL Web Services
Discussion List
-
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 … -
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 43 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 34 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 13 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 13 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 12 views 1 comment 0 points Most recent by Uddipta Bhaumik-Oracle 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…
-
Retrieve Trial Balance via APINeed an API that allows me to retrieve the trial balance data.Khaled Elashkar 31 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 11 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 21 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 1 view 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 581 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 56 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 11 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 21 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 24 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 2 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How can access the data securities REST API without Manage data access for users privilege?Summary: We are trying to invoke the dataSecurities REST API from VBCS. However, it appears that the "Manage Data Access" privilege is necessary for this call. Since gra…
-
Is there anyway to bulk download outputs from Content Server ( Oracle Content Server)Summary: Currently we have scheduled to run this ESS Job "General Ledger and Subledger Accounting by Journal Lines Report" for all modules every Day morning. Correspondi…Bhaskar Koduri 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Load Limits for loading journal lines via the erpintegrations REST API ImportBulkDataHi Guys I am specifically interested in the limits for loading journal lines via the erpintegrations REST API ImportBulkData Operation which uses the FBDI process under …GAVMAX 131 views 3 comments 0 points Most recent by Anthony Iannuccilli General Ledger & Intercompany
-
Create GL Code Combination using webserviceSummary: Hi Everyone, There is one requirement to create GL Code combination dynamically while creating Movement Request using Webservice. Integration should check if Co…ROHIT CHARAYA 52 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Clearing account automatically reconcilliationDear all kindly find the below: I have done the clearing account reconciliation manually it is done i created a transaction in the journal ledger and went to do the auto… -
Auto-generate batch name when I import journals using fbdiDear All, I am attempting to import journals using FBDI. After the import, the batch name is auto-generated in the following format: (batch_name) (source) (actual flag?)…George Mattar 32 views 3 comments 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany
-
SOAP/REST API to update DFF in account combinationsHello, I just configured a DFF (attribute1) in the Account combination window. Is there any WebService available in order to update the value of that column (gl_code_com…mauriciobmx 62 views 1 comment 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany