GL Inquiry
Discussion List
-
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 51 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 54 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…GAVMAX 102 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
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 161 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 161 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 71 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 241 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 132 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 61 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 51 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…Umer.Farooq 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 51 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…Umer.Farooq 61 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 81 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…
-
How can we transfer Project Cost from one LE to another LESummary: We mistakenly booked cost in one project belong to SG BU, we want to transfer the cost of the project to another US BU using Project Adfdi/FBDI Template. Please…PKumar 31 views 1 comment 0 points Most recent by Suresh Kumarasamy-Oracle General Ledger & Intercompany -
Inquire on Detail Balances Drill ThruSummary: drill down on the Beginning and Ending balances for a Period. Content (required): Use Account Monitor / Inquire on Detail Balances A customer raised a need to d…Wael.Dawood-Oracle 71 views 2 comments 0 points Most recent by Balaji Rangaswamy General Ledger & Intercompany -
Can we have Accounting period sorted to have the latest period on top in Inquire & AnalyzeonBalancesSummary: Content (required): If there is a way to have Accounting period sorted to have the latest period on top in Inquire & Analyze on Balances and Inquire on Detail B…HiteshChugh 41 views 2 comments 0 points Most recent by Ravi Kanth Vuddagiri General Ledger & Intercompany
-
Is it possible to export a custom FRS TB report to Excel?Summary: Is it possible to export a custom FRS TB report to Excel? Content (required): Hi team, We have a custom FRS report that needs to be exported to Excel, we know t…Mostafa Gharib 41 views 2 comments 0 points Most recent by uchitha-Oracle General Ledger & Intercompany -
How to retrieve table valueset valuesSummary: Hi Team, I have created a table valueset where I used the table name as fnd_currencies. with the API i'm not able to call the values present in the table. Could…Karthik Dara-Oracle 31 views 2 comments 0 points Most recent by Brad Sayer General Ledger & Intercompany
-
How to update "Control account" and "Financial Category" in "Manage account combinations"Summary: Current setup for a account combination is control account = "Restrict Manual Journals" and financial category = " Accounts Receivable" user wants to enter a sp…User_2025-02-11-08-59-18-251 706 views 1 comment 0 points Most recent by Balaji Rangaswamy General Ledger & Intercompany