GL Inquiry
Discussion List
-
Daily Activity in SmartviewSummary: Hi All, I am currently using Smartview version 25.100 and have encountered an issue when attempting to retrieve data. Specifically, when the "Amount Type" is se… -
How to get the Audit report through Audit Policies for Purge Interface table in GLSummary: There is one requirement to check who did the purging through ESS program Purge interface table or need the Audit report for Purge Interface table in GL Content…Neelesh Singh 6 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Account Analysis Report - How to Pass Account Filter (P_FLEX_FIELD_RANGE_FILTER_ID)Summary: We are working with the Account Analysis Report in Oracle Fusion (ESS Job). When we apply an Account filter (Natural Account segment) in the report submission U…sailesh_cloudare 10 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
restrict source payroll journal in GLHi All The customer that i work there request to make the payroll journal in general accounting to show only for two employee . Is there any way to restrict the payroll …Abdallah Fekry 7 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
could you please share the steps for creating recurring in Oracle fusion journal ledgerSummary: could you please share the steps for creating recurring in Oracle fusion journal ledger. I have followed the video posted in Oracle my learning but I'm getting …ChittiKrishna 14 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
New project doesn't appear in budget tables. Pushing budget from EPM to ERPOnce a new project is added, the PPM to GL sync process updates the GL COA and the Project is added to the tree as well. However, unless the tree's rows and columns are …HarshitBa 18 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Currency Rates API. Fetching for All at onceHi, We have tried using the currency rates API but noticed that it is only allowing one pair of currency at a time like USD to EUR. Is it possible to have everything be …Gene Garcia 11 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
why does Period Name move a year ahead when creating a fiscal calendar?I am creating a Fiscal Calendar with a Start Date of 4\1\2024 with a format = MMMYYYY fiscal year. The first Period Name shows as Apr-2025….Why would this not show as Ap…Jason Madden 19 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
implement Segment Value Data Security (SVS) in BI Publisher ReportHi All, Could someone provide insights on how to implement Segment Value Data Security (SVS) in a BI Publisher Report on the GL budget balance table? We have a requireme…
-
Remove the JV Approval if the JV is come from other moduleSummary: Remove the JV Approval if the JV is come from other module Content (please ensure you mask any confidential information): Hi, As per current setup, all the post…Boo 15 views 5 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
inquire on detail balance doesn't workSummary: inquire on detail balance doesn't work Content (please ensure you mask any confidential information): knowing that the user already has access to all ledgers an…Abdelrhman Samy 77 views 4 comments 0 points Most recent by Abdelrhman Samy General Ledger & Intercompany
-
Disable Drill down from Journals page for specific user/Ledger who has access to Journal creationHi, we have a requirement to disable drill down functionality for specific users/ledgers who has access to journal creation. We tried using custom financial analyst role…
-
How to change from a calendar year to a fiscal yearWe went live with an entity six months ago using a calendar year in the GL. We now need to switch from a calendar year to a fiscal year (Apr - Mar). Does this require us…
-
Issue Converting Accounting Calendar from Fiscal Year to Calendar Year in Oracle FusionSummary: Hello Team, We are in the process of modifying our existing accounting calendar setup in Oracle Fusion Financials. Currently, the ledger is using a fiscal year …
-
Is it possible to use DFF to calculate for the specified journal amount?Summary: To provide context, business is using General Ledger Module to create AR transactions and account it accordingly. Specifically, they are using DFFs to define th…Mira Dela Cruz 16 views 2 comments 0 points Most recent by Anca A-Oracle General Ledger & Intercompany
-
We're facing some performance issues on General Ledger report execution.We're facing some performance issues on General Ledger report execution. We opened a SR and ran the HAR file as requested. Afterward, we received the following message, …Laura Garcia de Souza Pinto 13 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
Understanding Impact on Enterprise StructureGiven the current setup in which primary ledgers vary by country, is it feasible to consolidate them into a single ledger? What would be the potential impact of doing so?
-
CCC - We are trying to create GL enquiry role for each user based on cost center.Summary: CCC - We are trying to create GL enquiry role for each user based on cost center. Content (please ensure you mask any confidential information): Our system supp…
-
Daily trial Balance reportSummary:Hi , We have a requirement to generate the Trial Balance report on a daily basis instead of PTD data. Could someone please confirm if it is possible to obtain a …Jeeva_Kharsha 20 views 2 comments 0 points Most recent by Kamal Ibrahim-Oracle General Ledger & Intercompany
-
reserved or restricted word in GL setupI am currently in the process of setting up an environment in Oracle Cloud. I would like to ask the following three questions regarding restricted or reserved words when…Komi_I 26 views 1 comment 0 points Most recent by Kamal Ibrahim-Oracle General Ledger & Intercompany
-
Update Action not enabled for Journal Update Batch DFF APISummary: We are using this API for updating a journal batch. And we are facing Update action not enabled.Let us know the cause for it.Update a batchpatch/fscmRestApi/res…
-
Seeking API to restrict approvals and add relevant approvers—please advise.Summary: We have checked this API, but we would want to know if there is any other API to restrict few approvers & add others? As an alternative approach we are trying t…Manasa G 12 views 1 comment 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany
-
OANDA daily rate load web serviceSummary: We are currently loading daily rates from OANDA application with FBDI. Do you know if we have any web service which can be used for this? Appreciate any help Co…
-
Is there a table that stores ALLOW_POSTING_FLAG?Oracle Fusion Cloud Financials 25A Is there a table that stores the value for allow_posting_flag for a segment value loaded into gl segment values? that field can be loa…
-
Post 25A: Unable to view data in Inquire on Detail Balances with custom GL roleHello Experts, We have noticed an issue in the Inquire on Detail balances UI where users who were able to access the data before aren't able to after 25A was applied. Ha…MdeZilva 16 views 4 comments 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany -
Request for Alternative Solution to Import Journal Entries with Regional Localization FieldsSummary: Problem Statement The business needs to import journal entries with regional localization fields (e.g., for Mexico) into Oracle Cloud ERP. Standard tools like A…
-
Difference between Date_created column and creation_date column in GL_INTERFACE TableSummary: Difference between Date_created column and creation_date column in GL_INTERFACE Table. Name Datatype Comments CREATION_DATE TIMESTAMP Who column: date and time …
-
How to Populate Journal Line DFFs in the ADFDI SpreadsheetSummary: Hello Everyone. I have created a DFF text box named "PO Number" at the journal line level. I need to populate this DFF in the "Create Journal in Spreadsheet" AD…
-
Need role for FRC report viewers that allows drill-through to inquire detail balances and beyondSummary: I need to create role for FRC report viewers that allows drill-through to inquire detail balances and through to transactions that DOES NOT trigger full ERP fin…Damir Antunović 449 views 30 comments 0 points Most recent by Michael_LDN General Ledger & Intercompany -
disabled expense account still showing in P&L reportSummary: GL expense account deactivated/disabled. Content (please ensure you mask any confidential information): We have a GL expense account which was deactivated since…