OTBI
Discussion List
-
Newly Created Supporting References not showing up in OTBI ReportSummary: I created two non-balance carrying supporting references - see steps I followed below. After creating these, I ran the following query within Reports & Analytic…Akbar Ahmed 24 views 1 comment 0 points Most recent by Akbar Ahmed Subledger Accounting & Accounting Hub -
Is There Way to Join Subledger to Payables Invoices via Query?Summary: Is there a way to join Payables Invoices - Transactions Real Time to Subledger Accounting - Journals Real Time via a SQL query? Content (please ensure you mask …hannah_barry 23 views 0 comments 0 points Started by hannah_barry Payables, Payments & Cash Management
-
Equivalent table/view of GMS_BALANCES from EBS in Oracle CloudSummary: I am not able to find equivalent table for GMS_BALANCES from EBS. I had an interface which fetched period to date values from eBS (mentioned below) but not able…N Goyal 41 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Subledger Accounting & Accounting Hub
-
FAH to GL reconciliation reportSummary: FAH to GL reconciliation report Content (required): Hi All, I am looking to prepare FAH to GL reconciliation report. This report should provide the details of a…Mayank Patni 101 views 1 comment 0 points Most recent by Harshad N Godbole Subledger Accounting & Accounting Hub
-
Reporting on Supporting Reference Balances for a secondary ledgerSummary: When reporting on Supporting References in OTBI the values associated with secondary ledgers exist in the "Subledger Journals Real Time" subject area but not th…Daniel Martin 33 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
Restrict Control Account within SubledgerContent We have a requirement to restrict entering control account in AR & AP Transactions. We managed to achieve this partially via Customer/Supplier Control Option und…Rihan Jameel 22 views 4 comments 0 points Most recent by Rihan Jameel Subledger Accounting & Accounting Hub -
Subledger Period Close Exceptions Report - SQL query time exceeds the limit (2400 sec)Summary Report times out when run for ProjectsContent Hi, just wondering if anyone has any experiences with the Subledger Period Close Exceptions Report timing out when …Gavin Smith 99 views 3 comments 1 point Most recent by Gavin Smith Subledger Accounting & Accounting Hub
-
Need an OTBI report/field that shows Mapping set for natural account by procurement categoryContent Hi, I would like to see if any of the OTBI subject areas for Procurement have a field that shows the natural account mapped by procurement category? On Procureme…Vanessa Garma-Oracle 62 views 3 comments 1 point Most recent by Vaishnavi Aryasomayajula-Oracle Subledger Accounting & Accounting Hub
-
Performance Impact of multiple contexts on a Supporting Reference with BalancesSummary Topic discusses the performance impact of source from multiple contexts on Supporting Reference Reporting.Content Within a single supporting reference with balan…Daniel Martin 37 views 3 comments 1 point Most recent by Shyam Santhanam Subledger Accounting & Accounting Hub
-
Drill down to Subledger Journal Entries from OTBIContent We are trying to drill down to the subledger journal entries for a specific period. We are referring to the attached document but with the information as contain…Adam Williams 49 views 2 comments 2 points Most recent by Vaishnavi Aryasomayajula-Oracle Subledger Accounting & Accounting Hub
-
'Batch Source' Field From Subledger Journal Line required (Table and Field Name required)Content Hi Community, We require the Batch Source (see sreenshot) field from the Subledger Journal Lines for reporting purposes. Can anyone advise what table and field t…Kunal Daya-175386 35 views 6 comments 2 points Most recent by ashtrakhov-Oracle Subledger Accounting & Accounting Hub
-
Support of special characters (- Hyphen) in supporting reference with balancesContent Hi Team, We have observed a strange behavior in how Oracle AHCS maintain supporting reference balances when we get special characters ( - hyphen) in the source f…Saichand Reddy Danda 29 views 1 comment 3 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
Supporting References with balancesSummary Calculate YTD balances for Supporting References with balances fieldsContent Hi all, Can YTD balances be derived or calculated for Supporting References with bal…Pavan SK 70 views 2 comments 1 point Most recent by Miranda Ho-Oracle Subledger Accounting & Accounting Hub
-
Subledger Journals - OTBI Subject AreaContent Hi, In Subledger Journals OTBI subject area, Accounting period column does NOT show in ascending/descending order in prompts. Using the below SQL in the prompts …Vinod Kumar Mohanraj 56 views 1 comment 1 point Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub