Reports
Discussion List
-
Any method to search for a keyword usage in the OTBI Reports or HCM ExtractsSummary: Any method to search for a keyword usage in the OTBI Reports or HCM Extracts Content (required): Hi All, We have the requirement to identify the reports and int…Parag Hiremath 32 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Saved Linked Objects in Management ReportsA question to the community - does anyone know when management reports in Planning Cloud will support adding saved linked objects like we can in FR? We have a customer w… -
FR Report Que : Display Yeartotal on FR report and allow user to expand only if rqdSummary: We want to develop FR report in excel format such that the report opens at Yeartotal level and then allow the user to expand to month level only if the user wan…
-
How are you managing OTBI AgentsSummary: We have some analysis/dashboards that we want to schedule and send out as specific times using agents. Question is there any best practices around the managemen…amy hardtke 11 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
OTBI Edit Column Formula for YYYYMMDDSummary: Hello, We tried using the solution listed in the Oracle Doc below but unable to successfully edit the column formula of the OTBI analysis for Workforce Manageme…User_2025-02-11-05-19-35-410 541 views 7 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM -
HCM Extract| Balance ValueSummary: Hi, I need to fetch balance value for dimension YTD. I created the balance group and HCM extract(Followed the attached PDF). But it is not working as expected. … -
Need Report for Number of times hire-date changed and all hired dates changed(in one field)Content Hello , We need the report of, Number of times hire-date changed and all hired dates changed(in one field). Is it possible in BIP? If yes, pls share me the sampl…JanardhanaKondaveeti 35 views 7 comments 0 points Most recent by User_2025-11-28-00-22-13-803 Reporting and Analytics for HCM -
How to build a HCM extract to generate HDL files.Summary: As per the business requirement, I need to build a HCM extract to generate the CalculationCard.dat file. I need to build an extract which can give me balances y…
-
BIP Report to pull only terminated employeeContent how can we pull only terminated employees who does not have any active record as of sysdate -30 Example: Employee terminated as of yesterday and rehired as of to…Kavya Sreenivasulu 175 views 11 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Footing errorsContent In FCC financial reports there is option to set rounding. The problem is that after rounding, sum of accounts balances is different than parent value which inclu…User_YZ4FW 118 views 4 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
Time Stamp Diff based on User Entered Date ValueSummary: Time Stamp Difference function calculating with user prompted date value Content (required): I am using the following function to calculate years of service. I'…Jennifer Wiggs 41 views 8 comments 0 points Most recent by Jennifer Wiggs Reporting and Analytics for HCM
-
Extract should have two Parameters 1. Expense End Date 2. Payroll NameSummary: Need input on how to add parameters in HCM extract. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code s…Arti P 1 view 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM
-
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition… -
Documentation or Use Cases for putting reports on pages that use parametersSummary: Displaying reports on various pages that require page filters Content (required): We have successfully been able to add OTBI analysis to pages and filter on the… -
Pencil icon does not appear on grid containing Note ColumnsSummary: I have a user that cannot enter text into a grid containing Note columns. The pencil/Write functionality is not active for some reason for this user. The user i… -
Account Description is as the code in General Ledger Analysis and error when the columns are addedSummary: Content (required): Trying to build up an analysis report but when extracting the account description it is the same as the account code. But in the value sets …Dian Minshan 43 views 1 comment 0 points Most recent by Dian Minshan Reporting and Analytics for ERP -
Dynamic Wording in Word using Planning and related ToolsSummary: Given I have a statement like so (See Quote) in my Financial Statements in Microsoft Word is it possible to refresh the decreased by $5.6 Million using EPM? Not…
-
Document Number in OTBI Receivables - Transactions Real TimeContent I am building an OTBI report using Receivables - Transactions Real Time, and I'm looking for the column for 'Document Number'. Does anyone know if this column is…Brian Todd-Oracle 32 views 1 comment 0 points Most recent by Robert G Wilkinson Reporting and Analytics for ERP
-
Table(s) for Enabled / Not Enabled Functional Audit PoliciesSummary: Is there a table that contains the full list of functional Audit Policies that can be enabled / have been enabled already? Content (required): See PDF for scree…Jeff Hare CPA CISA CIA 11 views 1 comment 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Table for Names details in Usernames page for External usersWe have a requirement to pull all External user's usernames (users without person record) with other details like FirstName, LastName and Email displayed in "User Inform…Santhosh Bachu 61 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Resource Alert: Waitlist Exit AlertSummary: Hi All, I am working on a resource alert(alert composer) to achieve those learner details whose offering status change from waitlist status to some other learn …Arti P 31 views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM
-
Loss of benefit eligibilitySummary: Content (required): I am trying to report on employees who are losing eligibility to benefits based on recent life events processing. Can anyone help me with th…Scott Paulin 12 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
Learning bi publisher report How to display learner activity's status and grade?Hello , How can we implement BI publisher report ,which displays the status and grade of activity of learners in a course. A course can have few offerings - and we would…Revital Mefano 21 views 2 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
In OTBI Report, can we have details in single row per transaction with tax amount?Summary: We are looking to have only 1 line per transaction and when I add tax amount it splits the report to multiple lines per transaction. Is there a way around this?…Rahul Kumar Gupta.-Oracle 33 views 0 comments 1 point Started by Rahul Kumar Gupta.-Oracle Reporting and Analytics for ERP -
Details about PrivilegesHi Team, Am looking for a report/ query to find details about privileges. We are looking for finding a what is the exact purpose of a privilege. Example: AP_MANAGE_PAYAB…Swapnil Kashid 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Is there a report that shows how a workflow was approved?Summary: Requirement is to see the how many users approve in the application versus workflow email Content (required): Version (include the version you are using, if app…Anthony Cambria 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to properly use an excel function in an rtf template?Summary: I added an excel function in my RTF template but when the report is created in excel it shows the function and not the result of the function. Is there an solut…Geert Buyckx 32 views 3 comments 0 points Most recent by Geert Buyckx Reporting and Analytics for ERP