OTBI
Discussion List
-
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 21 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 32 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 12 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 12 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 30 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 22 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 17 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 17 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 16 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 17 views 1 comment 3 points Most recent by Anca Amarghioalei-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 51 views 2 comments 1 point Most recent by mho-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 37 views 1 comment 1 point Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub