OTBI
Discussion List
- 
             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 63 views 1 comment 0 points Most recent by Sahithi Kolasani-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 63 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 127 views 1 comment 2 points Most recent by Valeriy Gorbunov 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 127 views 1 comment 2 points 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 21 views 3 comments 0 points Most recent by Sharada Beleramane-Oracle 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 21 views 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… 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…User_2025-02-11-23-30-56-074 21 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri General Ledger & Intercompany 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 21 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 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 62 views 5 comments 2 points 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 62 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 57 views 8 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 57 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 21 views 1 comment 0 points Most recent by Anca A-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 21 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. … 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 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…User_2025-10-31-01-06-05-525 32 views 1 comment 0 points Most recent by Rohan Kamat General Ledger & Intercompany 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…User_2025-10-31-01-06-05-525 32 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 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 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 168 views 4 comments 4 points Most recent by Daniel Lundsteen Minke 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 168 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 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… 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 219 views 2 comments 2 points Most recent by Aishwarya Thapar-Oracle 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 219 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 76 views 1 comment 1 point Most recent by Anca A-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 76 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 99 views 2 comments 1 point Most recent by Vaishnavi Aryasomayajula-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 99 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… 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. 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… 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 129 views 3 comments 1 point Most recent by gabriel kinovisques-163562 General Ledger & Intercompany 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 129 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 27 views 2 comments 2 points Most recent by Vaishnavi Aryasomayajula-Oracle 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 27 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 59 views 1 comment 12 points Most recent by Jeff Hare CPA CISA CIA 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 59 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 … 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… 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 42 views 2 comments 2 points Most recent by User_2025-02-05-22-11-22-331 General Ledger & Intercompany 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 42 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 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