OTBI
Discussion List
-
Need to schedule a BI Publisher report to run on Business Day2Summary: Need to schedule a BI Publisher report to run on Business Day2 Content (required): How to schedule a BI Publisher report to run on Business Day2 from schedule p…User_2025-02-11-23-30-56-074 22 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri General Ledger & Intercompany
-
The new year budget is fewer COA segments from the last year budgetSummary Is there any problem when The new year budget is fewer COA segments from the last year budget,Content is there any problem when The new year budget is fewer COA …Yasmin Kennedy 35 views 6 comments 1 point Most recent by Kamal Ibrahim-Oracle General Ledger & Intercompany
-
List of all the recurring scheduled processes?Summary How to get a list of all the recurring scheduled processes?Content How to get a list of all the recurring scheduled processes?Yasmin Kennedy 60 views 5 comments 2 points Most recent by Kamal Ibrahim-Oracle General Ledger & Intercompany
-
GL Journals details?Summary How to build a report to get the journals details?Content Hi Experts, How to use OTBI to build a report to get the details of the GL journal? like the one below …Yasmin Kennedy 58 views 8 comments 2 points Most recent by Kamal Ibrahim-Oracle General Ledger & Intercompany
-
OTBI Report - GL JournalsSummary: OTBI report for GL Journals - I would like to create a report to allows me to see the Legal Entity relationship between a Balancing Entity and a Related Party? …AVorster-Oracle 23 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany
-
Trial Balance complete in ErrorSummary: Trial Balance complete in Error Content (required): Trial Balance complete in Error when submitted by a user. Seems as if BI publisher is not link to the user. …
-
Is there per field descriptions of OTBI tables/subject areas?Summary: I have searched Oracle's docs and the internet at large in an attempt to find a description of "Approval Status"."Approval Status Description" field in the "Gen…
-
Is there a Standard report for JE detail that includes Posted by and Final Approver?Summary: Content (required): Auditors are requesting STANDARD Journal Detail report that includes the Posted By and Final Approver fields. Version (include the version y…Cathy Watson Moore 33 views 1 comment 0 points Most recent by Rohan Kamat General Ledger & Intercompany
-
Budget Data from PBCS for Reporting (not control) - what reports exactly is it visible in?Summary: When you load budget data from PBCS to Fusion Financials General Ledger for reporting (not control budgets) can anyone confirm exactly which OTBI subject areas …User_2025-02-10-15-12-48-631 11 views 2 comments 1 point Most recent by User_2025-02-10-15-12-48-631 General Ledger & Intercompany
-
Reconciled Transactions ReportSummary: Reconciled Transactions Report and UnReconciled Transactions Report Content (required): What are the prerequisite for using these report. Whats setups involved …CraigX 31 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Segment Value Security Is Not Enforced In OTBIContent Hi all I have enabled Segment Value Security on Department (Cost Center) and it is working in the GL as you can see in the first image. Currently I have only acc…Daniel Lundsteen Minke 149 views 4 comments 4 points Most recent by Daniel Lundsteen Minke General Ledger & Intercompany
-
Journal Issue - "No sequence version is enabled or defined for sequence **** XX GL Accounting SequencContent Hi Guys I would just like to inquire if anyone of you have encountered this kind of error for created journals? Please kindly refer below "No sequence version is…User_2025-02-11-12-30-38-982 271 views 1 comment 1 point Most recent by Kallol Sinha General Ledger & Intercompany
-
After GL Budget Data loaded, how can we refresh OTBI / Cube?Content Hi, We have loaded data into GL_BUDGET_BALANCES table using FBDI from here: https://docs.oracle.com/en/cloud/saas/financials/21b/oefbf/general-ledger.html#import…
-
FBDI - Hierarchy Error MessageContent Hi All, Attached is the screenshots of the FBDI I need to use, on validating the segment Hierarchies (GL_SEGMENT_HIER_INTERFACE), I am getting error messages lik…Kanika Mahajan 209 views 2 comments 2 points Most recent by Aishwarya Thapar-Oracle General Ledger & Intercompany
-
Trial Balance ReportSummary Trial Balance Report in multiple currenciesContent Hello team, Are there any steps on how to create/customize a trial balance report in order to show local and f…Alex121-Oracle 78 views 1 comment 1 point Most recent by Anca A-Oracle General Ledger & Intercompany
-
Cash Flow Statement-Indirect Method ?Summary Cash Flow Statement-Indirect Method ?Content Hello The company needs a Cash Flow statement Report, hence first at all we reviewed the cash management reports and…gabriel kinovisques-163562 101 views 2 comments 1 point Most recent by Vaishnavi Aryasomayajula-Oracle General Ledger & Intercompany
-
How to clear account balancesSummary How to clear account balancesContent What is the best way to clear account balances? When I check the entered vs converted currency, the rate for some accounts a…
-
Report RistrictionSummary Report RistrictionContent How to only allow user to generate trial balance for account type Asset and Liabilities only and exclude expenses.
-
Account MappingSummary Account MappingContent For accounts that are not transaction accounts. How do i mapped these accounts when creating a report for instance an account that reflect…
-
FRS Cash Flow Statement-Direct/Indirect Method ?Summary FRS Cash Flow StatementContent Hello I was wondering if we can share with me any setup document in FRS (Financial Report Studio ) to generate a Cash Flow Report …gabriel kinovisques-163562 122 views 3 comments 1 point Most recent by gabriel kinovisques-163562 General Ledger & Intercompany
-
Roles and user assigned extractSummary Roles and user assigned extractContent How do I extract all the users and roles and application assigned?CraigX 28 views 2 comments 2 points Most recent by Vaishnavi Aryasomayajula-Oracle General Ledger & Intercompany
-
GL Ideas that are essential for security and compliance – Ideas that desperately NEED your votesContent There are a few Ideas (Enhancement Requests) that we and others have logged that are critical for SOX compliance and for the implementation of good internal cont…Jeff Hare CPA CISA CIA 60 views 1 comment 12 points Most recent by Jeff Hare CPA CISA CIA General Ledger & Intercompany
-
Desktop Integrator is not working when we are using for EBS and Cloud version from the same ComputerSummary Desktop Integrator is not working when we are using for EBS and Cloud version from the same ComputerContent We are working on a cloud implementation project and …
-
Intercompany (AGIS) AutomationContent Basically current steps : 1. When AP capture Invoice in Entity A with Entity B Interco chargeback dimension (last 3 digits) 2. Interco Module : Interco Team will…
-
System Posting Date Settings across GL module and BI reportingSummary Looking for confirmation that the time and date preferences set by the end user reflects the accurate JE posting date in both the GL module and BI reportsContent…User_2025-02-05-22-11-22-331 41 views 2 comments 2 points Most recent by User_2025-02-05-22-11-22-331 General Ledger & Intercompany
-
How to move functional changes from instance to other instanceSummary How to move functional changes from instance to other instance (simple changes like payment term)Content How to move functional changes from instance to other in…User783746-Oracle 72 views 8 comments 2 points Most recent by Sameer_Jain General Ledger & Intercompany
-
Income Statement and Balance SheetSummary Is there an OTBI or FR studio template to produce these two reports? Thanks for sharingBrian Hadizadeh-243825 68 views 5 comments 1 point Most recent by Baskar.Chakravarthi General Ledger & Intercompany
-
Budget data is not coming in queryContent Hello i upload budget in general ledger but is not coming in gl_balance table and i select atual_type is Budget "B" please advise Thanks MahgoubMahgoub S.Mohamed 40 views 1 comment 2 points Most recent by Anant Iyer-3611 General Ledger & Intercompany
-
Subject area analysis results are showing differently for different segment combinationsSummary we have an analysis created, with 3 subject areas, which is behaving differently for these GL account combinations. 1. Totals and columns are correct for the com…
-
Budgetary Control CubeSummary How to create Budgetary Control Cube?Content We created new budget for 2021, different than 2020, now how can we create the Budgetary Control Cube?