GL Inquiry
Discussion List
-
Creating view only role for general ledger setupsSummary: We have a requirement to create a role that allows you to only view the setups related to general ledger. There should be no edit access present in this role; s…Palak Sharma 119 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
New Values in the Scenario Drop Down ListSummary: Our DEV environments are including New Values in the Scenario Drop Down List in the Inquire on Detailed Balance Screen and others. Content (required): Our DEV e…Adrian Townsend 32 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
How to set up cutoff date for posting to GLSummary: Hi! We need to set up a cutoff date so that users cannot post to GL after a certain date of the month, nearing period close. Could someone please provide us wit…ShailenS 105 views 4 comments 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
GL_ADFDI_UPL_ER_NO_LEDGER: The ledger is invalid for your current data access setHi Guys Please can you help, I am getting this error intermittently: GL_ADFDI_UPL_ER_NO_LEDGER: The ledger is invalid for your current data access set I need to set up a…GAVMAX 92 views 5 comments 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany
-
GL_PERIOD_STATUSES in BIP not up to date?Hi Guys I must be doing something wrong because I am not seeing the same values in the oracle backend database via BIP that I am seeing in the Oracle Front End. In the f…
-
Unable to use deep link to navigate to view journal page through OTBI.We want to use Deep links in our OTBI report for journals. By using that deep link we should be able to navigate to view journal page in the application. However we have…KanikaGupta 516 views 1 comment 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Ability to drill down to transactions from Trial Balance Report Account balancesSummary: Ability to drill down to transactions from Trial Balance Report Account balances Content (required): We have a requirement to drill down to see transactions per…Ajay Hareesh 457 views 9 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
Anyone else experiencing issue exporting search results and/or journal details to ExcelSummary: Experiencing issue exporting search results and/or journal details to Excel Content (required): Since last Monday (June 29th) we are unable to export large sear… -
Consolidation -- Trial Balance QuerySummary: Consolidation -- Trial Balance Query Content (required): Business created Primary ledger, Secondary ledger in different currency, reporting currency ledger, Con…Kumar 57 52 views 2 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
GL Journal Header Event Date and Time postedSummary GL Journal Header Event Date and Time postedContent Good Day, We have a client requirement to fetch the GL Journal Header Event Date and Time for posted transact…User_2025-01-30-04-45-54-197 58 views 7 comments 2 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
Updating Journal Header DFFs using REST API/SOAP ServiceSummary: Hi Guys We would like to be able to load 2 x DFFs for a Journal Header via the importBulkData REST API when loading our journal lines, but unfortunately this do…
-
Inquire on Detailed Balances page is blankSummary: When entering Inquire on Detailed Balances page from quick actions menu the page displays nothing. Users have access to Ledger and data sets. Content (required)…
-
Want to migrate Journals from Legacy to Fusion for few months.Summary: Want to migrate Journals from Legacy to Fusion for few months. Content (required): Go-Live is July 1st week and business want all TBs upto March-2023 and want d…
-
What the the tables containing the daily balances for all code combinations and cat codes?Summary: What is the table containing the daily balances for all code combinations and cat codes? Content (required): Hello, I understood that in JD Edwards it is a tabl…Teodora Bulancea 51 views 3 comments 0 points Most recent by Nitin Kumar05 General Ledger & Intercompany
-
Is there any FBDI or ESS jobs to update the Journal Line DFF values?Summary: Hi Team, We have an outbound integration wherein we are sending journals from Oracle Fusion to a third party system and once the outbound file is generated it s…Srishti Kedia-Oracle 133 views 2 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How to view attributes for a value within OTBI Subject Areas such as enabled flag, start date etc.Summary: Need to view attributes of a value such as enabled flag, start date, end date, allow posting, account type etc. Content (required): Our client wants to be able …Shiva K 125 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Inquire detailed balancesSummary: We cannot select newly created ledger when navigating to Inquire on Detail Balances. Please advise Version (include the version you are using, if applicable): O…
-
Journal source for entries loading via FBDISummary: Is it normal that the journal source for all entries loaded via FBDI template are being replaced by group ID in the GL_JE_HEADERS Tables. Note that the journal …El1a 62 views 3 comments 1 point Most recent by Ravi Prakash Shukla-Oracle General Ledger & Intercompany
-
SQL Query to extract Journals in particular date rangeSummary: SQL Query to extract Journals in particular date range Content (required): Business wants to migrate Journals (Transactional data of all categories) from EBS to…
-
GL Report with Beginning balance, Period Activity (all transaction in selection duration), End BalanSummary: GL Report with Beginning balance, Period Activity (all transaction in selection duration), End Balance Content (required): Business wants simple GL Report with …
-
After Upgrade 23A Account Analysis Report is emptySummary: Scheduled update was made for 23A and when generating the report Account Analysis with any account and parameters does not return data. Content (required): Sche…Yerwin Blanco 242 views 1 comment 0 points Most recent by Haripriya-Oracle General Ledger & Intercompany -
Translate GL account balancesHi,We did a change in the exchange and had to rerun the Translate GL account balance program However, the TB balances are not reflecting the rate changes that we did.It …
-
How to Create Custom Role To not Manage Chart of Account Values ?Summary: How to Create Custom Role To not Manage Chart of Account Values ? Content (required): Hello Although I created a Custom Role and I did not assigned the Privileg…Cesar Saveedra 122 views 4 comments 0 points Most recent by Cesar Saveedra General Ledger & Intercompany
-
Need Journal Posted By detailsSummary: We need a a field that maps with Journal Posted by details Content (required): In EBS JE_Batches table we have Posted by field available. In fusion we don't hav…Raavi Srikanth -Oracle 66 views 3 comments 0 points Most recent by Raavi Srikanth -Oracle General Ledger & Intercompany
-
Trial Balance - Detail GLTRBALDSummary: Trial Balance - Detail GLTRBALD Content (required): We have Trial Balance - Details report in EBS application where we can see Journal in Foreign Currency and p…Kumar 57 52 views 1 comment 0 points Most recent by Elena Enache-Oracle General Ledger & Intercompany
-
WRS best practice for Financial reports or Oracle BI publisher is more stable?Summary WRS vs BI Publisher for reportingContent WRS vs BI PublisherWhere is it recommended to develop a complicated financial report with compairsons Oracle BI Publsihe…Umer272 34 views 2 comments 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Account/Period parameter in Account InspectorSummary: Account/Period parameter in Account Inspector Content (required): User wants Account/Period parameter in Account Inspector. I don't see this parameters in searc…Kumar 57 43 views 4 comments 2 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
How to make a DFF with autonumberingSummary: We can make a valueset with Date possibility of making a Autonumbering DFF ? Content (required): Version (include the version you are using, if applicable): Cod…Umer272 62 views 4 comments 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
User of Reference, Ref Date, Company Fields in Journal Entry PageSummary: User of Reference, Ref Date, Company Fields in Journal Entry Page Content (required): I just want know the significance of Reference, Ref Date, Company Fields i…Kumar 57 82 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Incorrect values in Account Monitor - DashboardSummary: We have created account monitors They show 0 in the value field for 2022 However, if I export all transaction for one of the accounts, I'm getting a value diffe…