OTBI
Discussion List
-
Define OTBI prompt default depends on login userSummary Would like to define OTBI prompt default depends on login userContent Is it possible to define OTBI prompt default depends on login user?Raku Komatsu-Oracle 20 views 1 comment 1 point Most recent by Valeriy Gorbunov General Ledger & Intercompany -
Different figures on one particular account code in account analysis and Trial balanceSummary:Is there a way to identify the difference. I mean is there a report to run to show us why there is a difference in the same account on different report. Content …David Sakeye 1 view 3 comments 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany -
GL Segments-OTBI ReportsSummary: I wanted to enable the 'Intercompany Segment' of the COA for OTBI reporting. Followed the steps as per the note- Fusion Financials OTBI : Setting up General Led… -
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…578130 2 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 15 views 6 comments 1 point 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 38 views 9 comments 2 points Most recent by Ahmed Maher K. 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 40 views 6 comments 2 points Most recent by Ahmed Maher K. 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? …Annelien Vorster-Oracle 3 views 1 comment 0 points Most recent by Anca Amarghioalei-Oracle General Ledger & Intercompany -
How to report on budget vs. actuals in OTBISummary: How to report on General Ledger budget vs. actuals in OTBI Content (required): How do I report on General Ledger Budget vs. actuals in General Ledger Balances R…Arny Elfa 12 views 1 comment 0 points Most recent by Anca Amarghioalei-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 2 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 …AngelOftheNorth 3 views 2 comments 1 point Most recent by AngelOftheNorth General Ledger & Intercompany
-
Does anyone have the SQL tables that define the BPM Journal Approval Workflows?Summary: We're trying to track the setting within the Journal Approval Workflow that disallows the JE creator from being an approver to support SOX audit controls Conten…Patrick Bonahoom 2 views 3 comments 0 points Most recent by AngelOftheNorth 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 31 views 6 comments 4 points Most recent by Arun_PK 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 …
-
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 19 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…JOHANN CHRISTIAN MORDENO 11 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…
-
Period Close-GLSummary Period Close-GLContent Is there a report that shows the day the GL period was closed.CraigX 25 views 5 comments 3 points Most recent by Baskar.Chakravarthi General Ledger & Intercompany
-
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 8 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 27 views 1 comment 1 point Most recent by Anca Amarghioalei-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 30 views 2 comments 1 point Most recent by Vaishnavi Aryasomayajula-Oracle General Ledger & Intercompany
-
Impact on Application behavior if we change the FUTURE1 Segment of COA Structure to ZONESummary Impact on Application behavior if we change the FUTURE1 Segment of COA Structure to ZONEContent Hi All, Greetings. Customer is live on Cloud Applications, having…Subramanyam Tumarada-Oracle 16 views 7 comments 1 point Most recent by Subramanyam Tumarada-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…CraigX 17 views 1 comment 1 point Most recent by Anca Amarghioalei-Oracle General Ledger & Intercompany
-
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 19 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 17 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 20 views 1 comment 10 points Most recent by Jeff Hare CPA CISA CIA General Ledger & Intercompany