OTBI
Discussion List
-
How to report postprocessing lead time at the item/org levelSummary: Trying to report the postprocessing lead time at the item/org level in OTBI Content (please ensure you mask any confidential information): Trying to report the … -
Stopping Learning AssignmentsSummary: Hello, We have a Project that will require us to stop the Learning Assignments Add/Remove through the Analysis, whether they are assigned through an Initiative …
-
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…
-
Can I know if there is a list of dashboards that is not part of Standard Fusion that is downloadableSummary: Is there a place where all the dashboards are available for download similar to the one available for expenses (provided by Andy in 2016) Content (please ensure…Anand_Ranganathan 21 views 2 comments 0 points Most recent by Anand_Ranganathan Reporting & Analytics for Fusion Service
-
Need to run the BIP report with one parameter which is having 500k Values .Summary: Hi All, I have a requirement to run the BIP report for 500k records which we will pass as a PARAMETER to the report . Please suggest the ideal way to do it . Is…
-
DFF causes error in joint GL and SL subject area analysis in OTBIReposting this question using my corporate ID as I am still having the same issue. I created a joint subject area analysis for General Ledger Journals and Subledger Acco…Walter L Gess 52 views 5 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How to get Node name and description from Manage Account Hierarchies: Specify NodesSummary: I need to get this value for a report, someone knows in which table this information is? Content (please ensure you mask any confidential information): Version …Diego Zegarra 31 views 1 comment 7 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany -
Drill down in OTBI Dashboard does not work correctlySummary: Drill down in OTBI Dashboard does not work correctly Content (please ensure you mask any confidential information): Hi, we created a Dashboard based on a OTBI R…Barile Alberto 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report to pull purchase order issued from each punchout and catalogSummary: OTBI report to pull purchase order issued from each punchout and catalog Content (please ensure you mask any confidential information): Hi Team, We have require…Nidhi Chhajed 11 views 2 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for SCM
-
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware … -
HR own position data not appearing for HR rolesSummary: Position Report is showing positions to the HR teams but its not showing their data Content (please ensure you mask any confidential information): I have a posi… -
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 21 views 3 comments 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP -
How can we add Date Prompt to DB prompt without using column from Subject areasSummary: We need to add a Dashboard prompt for Start Date and End Date. These two fields are just a Date parameter. We dont want to use any OTBI analysis column. How can…Abhishek Jois 31 views 6 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM
-
what does below hint mean?Summary: SET VARIABLE OBIS_ORACLEDB_HINTS_FOR_TOP_SELECT='OPT_PARAM(''_push_join_predicate'',''false'') OPT_PARAM(''_complex_view_merging'',''false'') GATHER_PLAN_STATIS…Pritha 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 , …
-
Learning Initiative OTBI report showing only limited recordsHi, We have a Learning Initiative with Report analysis criteria OTBI. The analytics reports has around 9K records and it doesn't have any complex filters. The report is …
-
how to check Invoice is Accounted or not in Invoice Header Table AP_inovices_AllSummary: how to check Invoice is Accounted or not in Invoice Header Table AP_inovices_All Content (required): Business wants to see the list of invoices in BI Report whe… -
Unable to view the Supplier 360 DashboardHi, During the Oracle demo demonstration session, Supplier 360 Dashboard was shown to us, however, we are unable to navigate to the same in our Test/Live instance. Suppl… -
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…Visu 922 views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
Chinese cannot show Bold when use rtf template to pdfHi All, I tried to customize a report's rtf template but I found the Chinese in the report cannot show bold while English show bold. I followed the disucss https://commu… -
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
-
Failed to get creation date for Landed cost in OTBI ReportSummary: I have developed an OTBI report for Landed Cost. I didn't get any field for creation date, is that anyway to get this field please Content (please ensure you ma… -
Separate Remittance Advice based on custom data modelSummary: Is there a way of customising the disbursement extract associated with the Separate Remittance Advice for cloud customers. Our requirement is to add details to …
-
Unable to view the Procurement DashboardHi, During the Oracle demo demonstration session, Procurement Dashboard was shown to us, however, we are unable to navigate to the same in our Test/Live instance. Procur…
-
Report on Parent Position's Current Incumbent when Position is vacantContent We need a way to report on the parent position's current incumbent when the position itself is vacant. The report that we created shows the incumbent name for bo…Joanne Chung 484 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …User_2025-02-11-06-12-35-024 202 views 3 comments 5 points Most recent by John Ban Reporting and Analytics for ERP