OTBI
Discussion List
-
Hi All can anyone help me to print these columns item and description in my transaction report.Summary: Please help me to print these columns in my transaction detail report please provide sql or tables where i can find these columns data. These are present under … -
Fusion SQL Linking between GL Transactions and PA to obtain the expenditure item idI have been asked to update a BIP GL report to provide the expenditure item id, should it exist, from projects. I have done lots of searches and some AI. The responses s…
-
what is the expected behaviour in total balance of a parent, if hierarchy is changedSummary: We have a scenario of Hierarchy change. and we need to know what balance should show in the parent level before hierarchy change and after the change Content (p…
-
I would like to customize the standard OTBI Trial Balance report in Oracle Fusion to meet our specifI would like to customize the standard OTBI Trial Balance report in Oracle Fusion to meet our specific reporting requirements. I am not sure about the exact steps involv…
-
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…
-
BICC PVO for FND_FLEX_VALUES_VLSummary: Need PVO for FND_FLEX_VALUES_VL table Can someone please share the BICC PVO for table FND_FLEX_VALUES_VL. Content (please ensure you mask any confidential infor…Sateesh Lakkireddy 4 views 1 comment 0 points Most recent by Harsha Sannappanavar-Oracle General Ledger & Intercompany
-
How to Find Table with Approver Details for General Ledger Lines.Summary I am trying to create a audit report for GL entries however i need to retrieve the journal approver details. Please advise which table would have this informatio…Dave Sherrard 505 views 9 comments 1 point Most recent by Deepak Kumar Dev-Oracle General Ledger & Intercompany
-
Is there an ability of showing on the UI the date of the last time an account combination was used ?Hi Team, I was informed that on prem Oracle used to have the ability of showing on the UI the date of the last time an account combination was used, similarly is this po…Baskara Sateesh-Oracle 11 views 2 comments 0 points Most recent by User_6WXUJ 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, …Bobby Choate 286 views 4 comments 3 points Most recent by Jakee_Agarwal-Oracle General Ledger & Intercompany -
Audit report to capture critical events of user activitySummary: Hi Everyone, One of our clients is looking for the reports that show logons, access attempts, and data modifications. Does any seeded report exists in the Oracl…Mahamood Sk 13 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
OTBI report unarchive from one instance to another instance is not workingSummary: We are facing an issue with OTBI report migration between environments. A report (e.g., Account Analysis) developed in one instance was archived and then unarch…Farooq Syed, CPA, PMP, CISA 12 views 1 comment 0 points Most recent by James McBride 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 592 views 3 comments 1 point Most recent by Wim vd Veer General Ledger & Intercompany -
How can I export journal entry data incl. user information for auditor (JET analysis)?Hi, we need to extract a full journal entry list including subledger data and information about the user who performed the transaction. The external auditor wants to use…Holger74 2 views 1 comment 0 points Most recent by Chandra Sekhar Kadali-Oracle General Ledger & Intercompany
-
Ledger ID stored in FA subject area instead of GL subject area (OTBI).Summary: The Ledger ID is an important key used to identify ledgers configured in the General Ledger application. In the database this is stored in the GL_LEDGERS base t…
-
How can we change a party NameHow can we change a party Name Segment Value for Entity was changed from ISO Ltd to a new name but the Old name is still appearing in the Reports as you can see below , …
-
From custom BI report Can we add 'From and To date' for seeing GL balances with backdated.Hi All, Business wanted to have one custom BI report for seeing GL balances and in that they want one parameter that is 'From and to date' to see the GL Balances with ba…Vasu N0897645321-Oracle 1 view 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany
-
drill down journal general ledger with specific valuewe need to use the drill down function to extract entries in the general ledger with specific values in debit and credit; is there a condition that we can use?for exam…Francesca1 13 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to auto-increment the accounting period on Trial balance report in BIPSummary: We have General Ledger Trial Balance in BIP and every month, end user needs to change the accounting period. Is there a way to auto-increment the accounting per…TBIRD1 16 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
R13 How to generate a Trial Balance from OTBISummary R13 How to generate a Trial Balance from OTBIContent Hello : I was wondering if you can share with me any document how to create a trial Balance from OTBI . As f…gabriel kinovisques-163562 138 views 3 comments 3 points Most recent by TBIRD1 General Ledger & Intercompany
-
Chart of Accounts Hierarchy Sort Order Field NameSummary: I'm building a custom BIP data model and report and I'm looking for the User-Defined hierarchy Sort Order field name info (table, field) schema = FUSION Content…Emile Helegbe 42 views 3 comments 0 points Most recent by Emile Helegbe General Ledger & Intercompany
-
How to create OTBI for chart of account value ?Summary: Can I create OTBI for all segments in the chart of account value sets, like the hierarchy structure? Content (please ensure you mask any confidential informatio…
-
Changing GL Segment value Description not reflected in OTBI ReportsChanging GL Segment value Description not reflected in OTBI Reports I thought it should update straight away.
-
Deeplink Drill Down from OTBI GL Journal Real Time to Subledger Journal Line formSummary: Is it possible to drill down using OTBI General Ledger - Journal Real Time subject area "- Journal Line Details"."General Ledger to Subledger Link Identifier" a…Vivek Ramadoss 52 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Need subject area for Bank return number to add column in OTBISummary: Hi Experts, I am looking for subject area for bank return number to add in OTBI report. Task: Payments—> Manage bank Returns —> search with invoice number— Retu…Mahindra reddy-Oracle 2 views 1 comment 0 points Most recent by MiaM-Oracle Receivables & Collections
-
Custom lookups in OTBISummary: We have created a custom look up as common lookups and we want to use it in OTBI reports. Please let me know if it is possible or not. If yes, then please guide…Richa Arora-Oracle 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Finding corresponding entity§ion of an intercompany transaction that hits an entity & sectionHow to find the originating entity and section number of a transation that ends up in another entity and section in the General Ledger. Currently our ERP COA has Entity,…
-
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 140 views 8 comments 1 point Most recent by PratikL General Ledger & Intercompany
-
Data Not Visible in OTBI Dashboard for the userSummary: We have create a custom OTBI dashboard to show Item Information, Inventory Information , Purchasing Information, Sales order Information, Price List Information…Santosh Vaidya 4 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Natural Account (SEGMENT2) Description on a custom reportSummary: Hello, We have built a custom report to compare the FA SLA balances to GL which contains an account column but which GL table do we use to include the account d… -
Is it possible to fetch ledger id in OTBI?Summary: Hi, I want to add a column that shows the Ledger ID in OTBI for reporting. I have checked in all the Subject areas as shown in the image below but I have not go…Gautam Buragohain 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany