OTBI
Discussion List
-
How we can get Journal approver/assigned detail in OTBISummary: We do have a business requirement to create an OTBI report which provides below below-mentioned details. 1# Basic Journal header information (which we can get f…YogeshJain 51 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Segment related PVOs not visible in BICCSummary: There are segments created in Fusion (GL#) and all the required jobs to extend the OTBI are executed. However after the execution it is visible in OTBI for repo…Vedasubramanian Muthuswamy 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Instruction: Add a (DFF) to a specific Value Set for additional COA attributesSummary Add a context sensitive DFF to a value set (COA)Content One of the requirements for my organization was to add DFF's to the value sets of our chart of accounts, … -
Account Cube UpdateSummary Account Cube UpdateContent I did an update to Account Hierarchy and generate the "Publish Chart of Accounts Dimension Members and Hierarchies" not publishing Hie…
-
Account Analysis ReportSummary: Account Analysis Report Content (required): Does any of the GL Analysis report contains supplier name, address and withholding Tax Code? If not which can be mod…
-
Account Analysis Report - P_CUSTOM_PARAMETER_1 fieldsSummary: how to customize the Account Analysis Reports in following fields P_CUSTOM_PARAMETER_1, .... Content (please ensure you mask any confidential information): Hi, …
-
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 15 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 71 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 22 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 Financials – General (READ ONLY) -
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 83 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 22 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 41 views 3 comments 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
How to create custom ESS jobset to run Revaluation rules.Summary: As Part of month end, we are running multiple Revaluation rule, our question is can we group them based on our requirement (Region Wise) and create a custom ESS…Shadaab Ahmed 41 views 1 comment 0 points Most recent by CA Nirmal Choudhary 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 91 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 126 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…KanikaMahajan 381 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 371 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…Abelardo Pascual 54 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 104 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