OTBI
Discussion List
-
Prompt for Assigned on Date and Completion Date are not filtered based on the security of user (OLC)Dears, I've created a prompt with two filters: YEAR(Learning Record Details.Assigned on Date) YEAR(Learning Record Details.Completion Date) I don't understand the reason… -
Need help with SQL query (OBIEE Dataset)Summary Building a report showing a persons information on 2 different dates - need help with some sql design (if possible)Content Hi All, I am trying to build a report …User_2025-02-04-08-51-08-912 40 views 6 comments 0 points Most recent by Roma Pandey Reporting and Analytics for HCM -
OTBI Row to Columns Conversion (FA HCM Rel 9.2)Summary Can we convert rows into columns in Fusion OTBIContent Hi Experts, Please have a look at attached word document and png file s and adviseAshishERPCloud 82 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
Any report available to fetch ESS -scheduled pick waveSummary: Any standard report available to fetch scheduled pick wave ESS. Content (required): our client has 5 inventory organizations, and each org has multiple pick wav…
-
How to grant read-only access to "Costing - Inventory Valuation Real Time" without UI AccessSummary: How to grant read-only access to "Costing - Inventory Valuation Real Time" without Application access. Content (required): We have a requirement where we need a…
-
Customer Statement Report using OTBI.Summary: I want to modify existing OTBI report for Customer Statement Report for which I have to fetch Commitment cost as Expenses under Expenditure Category. For which …Yashdeep 52 views 4 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for HCM
-
How to create Coupons for DiscountsSummary: We want to offer Coupons to offer discounts to the Customer Content (required): We need to offer Coupons to the customers via Coupon Codes. Once they bring that…
-
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve…
-
How do add export option to Dashboard UI reportContent Hi, I cannot find a way to make the option export in the UI dashboard available. of course through OBIEE this option is available, but after adding the report to…Gal Shani 96 views 7 comments 0 points Most recent by Satheesh Nesamani Reporting and Analytics for HCM -
Need source of PO Charge account for OTBI reportSummary: what is the database source field for the PO charge account - would like to include in an OTBI report Content (required): PO charge account on the page - what d…Bernadette Dorris 41 views 6 comments 0 points Most recent by Bernadette Dorris Reporting and Analytics for SCM
-
Incorrect value/Same Value being displayed in Projects-OTBI reportsSummary: Content (required): Projects-OTBI reports show incorrect values, Budgets, Actuals, and Commitments are all displayed as "3".Occasionally, or depending on what e… -
How can I get only the latest results when reporting on the status of a certain training?Summary: I try to report on the status of a certain required learning to see who has not completed it yet. If the learning was deployed this year, but also the year befo…Cora_Stanciu 31 views 3 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM
-
Using Country of Origin field in Inventory TransactionsSummary: We have disabled the checkbox for tracking inventory by Country of Origin in Organization Parameters. But the Country of Origin field is available on receiving …
-
Restrict the access for creating data model and create analysisSummary: Hi All, How to find the roles which are giving create and edit access of analysis and BIP report? is anyone have any SQL for to find out these in any custom rol…Amit_Ekbote 41 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
While running whole population in OTBI we are facing issue.Summary: Content (required): we are using Pivot table output in the OTBI report for 1 or 2 employee it's working fine when we are running whole population, we are gettin…challa praveen 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need sql query to get invoice number in fulfillment line detailsSummary: Need query to get invoice number in Fulfillment lines. Screenshot attached. Content (required): As business request we have to add invoice number to order fulfi…kalyan gade 1.1K views 2 comments 0 points Most recent by kalyan gade Reporting and Analytics for SCM
-
Unable to see the Goal Status for Goal plan reportSummary: Unable to see the Goal Status for the Goal Plan OTBI report Content (required): Employee has submitted the goals for approval, but the same is not reflecting in…
-
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca…Parag Hiremath 61 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
OTBI-Expense-Expense Transactions - SQL to Link Expense and PPM ?Summary: OTBI-Expense - Expense Transactions - SQL to Link Expense and PPM Content (required): Hello I have an OTBI report with the subject area Expense-Expense Transact…Cesar Saveedra 41 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management
-
How to report date/time stamp when a Candidate Label was added.Summary: Content (required): is there a way to report the date/time stamp when a label was added to recruiting>candidate>candidate - labels> label Name ? I see there is … -
Report to get the duplicate element entries in a given pay periodSummary: Report to get the duplicate element entries in a given pay period Content (required): Hi Team, Greetings! Is there an existing report to get the duplicate eleme…Parag Hiremath 11 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to add account balancing segment filter in Receivables Aging report?Summary: I need to add multiple balancing segment filters in "Receivables Aging by General Ledger Account Report" Content (required): Hello, What i see now in the balanc…Teodora Bulancea 61 views 2 comments 0 points Most recent by Teodora Bulancea Receivables & Collections
-
Mass Update messagesSummary: Content (required): What table stores the messages from Mass Update transactions? Version (include the version you are using, if applicable): Code Snippet (add …Scott Paulin 41 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM