OTBI
Discussion List
-
OTBI Report analysisSummary: I have created mostly Reports development in Oracle BiPublisher. Where i used to show prompt input parameters in Reports and formatting easily with multiple gro… -
How to create a trial Balance either in OTBI or FRC ?Summary: How to create a trial Balance either OTBI or FRC ? Content (please ensure you mask any confidential information): Hello The company would like to have a trial b…Cesar Saveedra 27 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Ability to Drill down from OTBI to edit journal passing data access set on general accountingSummary: Deeplink on a column in order to edit the journal , also if the user is set on general accounting on a ledger different from the report row ledger Content (plea…GNCC33 211 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
deletedelete -
general ledger - Balance real time subject area not showing hierarchy values for balancing segmentsSummary: In General ledger - Balance Real time Subject area - Balancing segment - There is no value coming in hierarchy (22nd level of hierarchy for balancing segment) t…Shreeya Jain 21 views 1 comment 0 points Most recent by Madhavi Godbole General Ledger & Intercompany
-
Hide the OTBI Seeded Folder in the shared folderSummary: Is it possible to hide the OTBI seeded folder in the shared folder and will just only show the custom folder? Content (please ensure you mask any confidential i…Altagracia Javier 31 views 1 comment 0 points Most recent by Haripriya-Oracle Reporting and Analytics for ERP -
it is possible to include the CX module in the OTBI?Summary: It is possible to include the CX Module in the OTBI since CX have a separate UI from the Oracle? Content (please ensure you mask any confidential information): …
-
OTBI analysis joining General ledger and Project subject areas blank fieldsSummary: We are trying to pull GL transaction data and add the project and invoice information to it when relevant. Content (please ensure you mask any confidential info…Tashi Temple-Wood 137 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Best practice for AR Aging to TB ReconciliationSummary: Best practice for AR Aging to TB Reconciliation Content (please ensure you mask any confidential information): Currently we see huge difference between AR Aging…Ajay Hareesh 21 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
"Receivables Aging by General Ledger Account ReportSummary: We are trying to create a custom report based on "Receivables Aging by General Ledger Account Report" but we are facing issue with transactions falling into wro…
-
Sub Analysis & Activity Hierarchy Info not available in General Ledger Subject area (OTBI)Summary: Sub Analysis & Activity Hierarchy Info not available in General Ledger Subject area (OTBI) Content (required): We are working on OTBI Customization reports on G…Sreedhar Reddy palle 41 views 3 comments 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Can we create OTBI report using multiple subject areas ?Summary: Can we create OTBI report using multiple subject areas ? Content (required): Is there any confirmed dimension in below given GL subject areas in OTBI, can you p…Sreedhar Reddy palle 43 views 3 comments 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Ledger Revaluation Process Audit and ReconciliationSummary Ledger Revaluation Process Audit and ReconciliationContent Hi Does anyone have experience to audit and reconcile the Ledger Revaluation process? I know we can ge…Kashif Hussain-Oracle 86 views 2 comments 2 points Most recent by GAVMAX General Ledger & Intercompany -
How to retrieve data from GL Cube?Summary: How to retrieve data from GL Cube? Content (required): The link below provides some information about the GL Cube (Overview of Oracle General Ledger Balances Cu…RS_CSAA 174 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Unable to use deep link to navigate to view journal page through OTBI.We want to use Deep links in our OTBI report for journals. By using that deep link we should be able to navigate to view journal page in the application. However we have…KanikaGupta 525 views 1 comment 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Ability to drill down to transactions from Trial Balance Report Account balancesSummary: Ability to drill down to transactions from Trial Balance Report Account balances Content (required): We have a requirement to drill down to see transactions per…Ajay Hareesh 461 views 9 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 55 views 7 comments 2 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
Restrict user access to application UI and seeded reports only to the particular LE / Ledger / BUSummary: Restrict user access to application UI and seeded reports only to the particular LE / Ledger / BU Content (required): In our existing setup of 6 LE / Ledgers, t…Clyde 61 views 3 comments 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany
-
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
-
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 123 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Account Analysis report SQL Code requiredSummary: Account Analysis report SQL Code required Content (required): Account Analysis report SQL Code required. We need to customize this report based on Natural Accou… -
How to translate the "Account Analysis Report" in a different currency that the ledger one?Summary: I need to translate the "Account Analysis Report"/"Generate Financial Reports and Account Groups" into a different currency than the ledger one. Content (requir…Teodora Bulancea 51 views 4 comments 0 points Most recent by Teodora Bulancea General Ledger & Intercompany
-
GL seeded report or similar report requiredSummary: Business wants to generate Foreign currency detail TB. Content (required): Business wants to generate Foreign currency detail TB. UK Ledger currency GBP and the…Kumar 57 61 views 2 comments 0 points Most recent by Suresh Kumarasamy-Oracle General Ledger & Intercompany
-
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 41 views 2 comments 1 point Most recent by Cezar - Fusion Oracle Support-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 61 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 130 views 1 comment 2 points Most recent by Valeriy Gorbunov General Ledger & Intercompany