OTBI
Discussion List
-
Period Close-GLSummary Period Close-GLContent Is there a report that shows the day the GL period was closed. -
Journal entry reportSummary: Journal entry report Content (required): Account analysis gives one leg of the entry and don't give another leg of the entry. Business wants to see both lines i… -
Chart of Accounts Tree Report for segmentSummary: Chart of Accounts Tree Report Content (required): User would like to view Chart of accounts Tree for each segment and download in excel. Do we have any seeded r…
-
Journal ApprovalSummary: Report that reflects Journal Approval Content (required): Is there any report or sql that reflects the approvers of GL Journals. Looking for an approval report …CraigX 22 views 2 comments 1 point Most recent by Cezar - Fusion Oracle Support-Oracle General Ledger & Intercompany
-
GL segments not visible in OTBISummary: Hi all, I have an issue where some GL segments aren´t visible in OTBI. I tracked down some issues for why it was not visible and followed this note: https://sup…Daniel Lundsteen Minke 23 views 1 comment 1 point Most recent by HaripriyaP-Oracle General Ledger & Intercompany -
ERP Event - What's Available in General Ledger to Meet My Reporting Needs? (Sep 14, 9am PT)Registrations are open for the event ERP - What's Available in General Ledger to Meet My Reporting Needs? If you have questions for this event, please post them here or …Maria Centeno-Cloud ERP-Oracle 21 views 0 comments 2 points Started by Maria Centeno-Cloud ERP-Oracle General Ledger & Intercompany
-
JE_Lines_ DFF in OTBISummary: JE_Lines_ DFF in OTBI Content (required): Which of the GL subject area can I find the DFF when creating an Analysis? Will the field name listed as Atribute1,2,3…CraigX 11 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle General Ledger & Intercompany
-
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 27 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 1 view 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 37 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? …AVorster-Oracle 2 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 1 view 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 1 view 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 3 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 33 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 …CraigX 1 view 1 comment 0 points Most recent by Mihaela Cozma GL_Oracle-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 18 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 10 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 7 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 26 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