OTBI
Discussion List
-
Search AHCS transactions from UI via search criteria of Supporting Reference ValueSummary: There is a requirement to search AHCS transactions from UI via search criteria of Supporting Reference Value. Please suggest a workaround if current functionali…User_3UDBD 33 views 1 comment 0 points Most recent by Anca A-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 32 views 5 comments 0 points Most recent by Gifty Jose Subledger Accounting & Accounting Hub -
Customizing Payables Period Close Exceptions ReportSummary: My client is looking to customize the Payables Period Close Exceptions Report. They need additional fields in both the report parameters and the report output. …
-
Subledger DFF enabled not shown in OTBI subject areasSummary: BIenabled subedger line level DFF cannot be found in OTBI subledger accounting subject areas Content (please ensure you mask any confidential information): A li…Dian Minshan 1 view 2 comments 0 points Most recent by Vivianevasc Subledger Accounting & Accounting Hub -
General Accounting Entries link tax with initial amount in OTBIHi Could you please advise if, in the analysis or data model, there is any way to determine that the tax amount of 200 with the natural account X on line 2 is on the amo…Elyse Meouchi 51 views 0 comments 0 points Started by Elyse Meouchi Subledger Accounting & Accounting Hub
-
Report for Disabled GL account code combinations with balancesSummary: HI Team, Is there any report in Fusion GL which can list the disabled/invalid account code combinations along with their balances. Thanks Content (please ensure…Mayank Sapra 25 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
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 51 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 101 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 134 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 31 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle 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 140 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 72 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 48 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 47 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 36 views 6 comments 2 points Most recent by alexey.shtrakhov 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 28 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 81 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