Reports
Discussion List
-
Query to fetch sum of debit memos and credit memos for an original invoiceSummary Am looking for a query to get sum of credit memos linked to original invoice ie Original invoice -HCS1 Credit memo-HCS2 as shown in below screenshots.Content I w…Sankeerthana Anumasula-Oracle 937 views 2 comments 1 point Most recent by Sankeerthana Anumasula-Oracle Reporting and Analytics for ERP -
Hours worked counted by Calendar Weeks LogicSummary Need help with logic to count hours worked based on calendar weeks worked for 401K vendorContent Hi Friends, We have a requirement where our 401K plan requires h… -
What's New in 21.05?Summary A lot of cool technical updates plus more features!Content Well, I'm sure you are all celebrating the 5th anniversary of the Planning Modules in the EPM Cloud (f… -
How to sort Age BinsSummary Sorting Age Bins in a ChartContent Hello, I am trying to get my Age Bands to sort in numeric order but the Bin Labels with text keep defaulting to the end of the…Rebekah Gilday 49 views 5 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Current status is "Interim"Summary Trying to report on all employees who are an interim assignmentContent I'm trying to report on all employees who are currently on an "Interim". Using the HR Acti…
-
BI Publisher report should send email with Digital signatures in email body.Summary We have a business requirement to digitally sign the email while transmitting transaction prints to customers. Basically, the email body needs to have the digita…User_85V95 42 views 4 comments 2 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
New Absence within 3 days of old AbsenceSummary We require a report that would show any colleague who had an absence closed, and a new absence opened within 3 days.Content Hi, I am currently working on an abse…Mitch_123456 21 views 1 comment 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM
-
Access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS).Content Hi all, Please clarify whether the "General Accountant" role has access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS). Best Regards, VipushaVipusha Chandrakumaran 73 views 1 comment 1 point Most recent by Anca A-Oracle Reporting and Analytics for ERP
-
What's New in 21.02?Summary We kick-off the new year in style!Content Faithful followers may have noticed I skipped the 21.01 update last month. The January update tends to be lighter given…
-
What's New in 21.03?Summary A really big Enhancement!Content Well, to say I'm excited to share this post may be an understatement and I believe you may very well share my excitement! In fac…
-
Account Segment Group ObjectsContent Our team is looking to group together certain accounting segments for use in some of their reporting and imports. They currently have specific payroll object gro… -
Nee a delivered report path that triggers approval notification email for time and labor module.Summary Nee a delivered report path that triggers approval notification email for time and labor module.User_2025-02-04-07-00-18-658 23 views 7 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
List of all Scheduled BIP ReportsSummary List of all Scheduled BIP ReportsContent Hi Team Is it possible to extract the list of all scheduled BIP reports along with owner and schedule frequency? Which t…Karthik K-Oracle 127 views 6 comments 3 points Most recent by User_KM4LK Reporting and Analytics for HCM -
BI REST APIsSummary BI REST APIsContent Hi All, Has anyone tried using the REST APIs to invoke a BI Report? I am having a hard time to get it working. If you have sample code and ca…Arun Raj 95 views 1 comment 0 points Most recent by Suresh Pallapothu Reporting and Analytics for ERP -
The Ability to Report on Task Manager CommentsContent Our business partner would like to have a report that shows which tasks were on time, which were late, and the comments added in the task, so they don't have to …Austin Loud 15 views 1 comment 0 points Most recent by Tom LeFebvre-Oracle Financial Consolidation and Close -
OTBI > Ability to Capture Name of Employee Performing Adjust Balance on Employee BalanceContent Hello All, I will appreciate your support on the following issue: Our customer wants to capture the name of the employee who performs Adjust Balance on Employee …Bernard T 16 views 6 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Bursting to SNOW - Postmaster issueSummary Emails are being blockedContent Hi Team, I've implemented a report to burst an emailt to ServiceNow Inbox with copy to my own email (Dev environment). I am getti…Alvaro Couto 37 views 6 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
How to access Custom ESS Job SetContent Business Users are not able to access the Custom ESS Job Set. We checked the below Oracle notes, but nothing works. How to Grant Execution Privileges to ESS Cust… -
Help Building HCM Group Membership ReportSummary I need to build a report that pulls all employees HCM Group membershipContent It doesn't seem that there is an easy way to find out what HCM Groups an employee i…David Rabalais 130 views 1 comment 2 points Most recent by David Rabalais Reporting and Analytics for HCM -
Report on BI Publisher Bursting RecipientsSummary Extracting details of bursted email recipients over set periodContent Hello, We have a nightly bursted email report inviting employees leaving our business to co…RebeccaAult1799 48 views 4 comments 9 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM
-
BIP | SQL query to get details of the employees belonging to departments below the selected departmContent Requirement: 1) Report should display employees belonging to the departments of the selected organization type. 2) Report should also display employees belonging… -
Report on employee careers of interestContent Hi, Has anyone built a report that indicates people and their careers of interest under career development in Oracle HCM Cloud? I am specifically looking to buil…Dishti Malhotra-Oracle 28 views 2 comments 0 points Most recent by Krista Kay Reporting and Analytics for HCM
-
Configuring Key Flexfield Segments in Oracle Financials Cloud to leverage OTBI for ad-hoc analysesSummary Configuration Steps to enable OTBI reporting of Key Flexfields (KFF's) in GL, Budgetary Control and Fixed Assets (Rel 11)Content To report on Key Flexfield Segme…Anand DN-Oracle 1.7K views 8 comments 12 points Most recent by Chris Lynch - IBM Reporting and Analytics for ERP
-
Can we update a column after BI report bursting for person levelSummary Can we update a column after BI report bursting for person levelContent Hi , We have a requirement in compensation module to avoid the letter bursting multiple t…User_MC37Q 47 views 2 comments 0 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM -
Budget balances not available in General Ledger subject areasSummary Can we query budget balances in General Ledger subject areas?Content Budget balances not available in General Ledger subject areas like 'General Ledger - Balance… -
BI report to extract time informationSummary Any pre build BI report to extract time information available?Content Hello anyone has any prebuild report to read Time information? Thanks, Nicola
-
Bursting HistorySummary Need to find the table for bursting report hisotryContent Hi Guys, I found a table for BIP Bursting report history but seem that the only usable column is the US…User_2025-02-05-11-53-59-507 80 views 9 comments 2 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM
-
Dynamic text generation based on dimension member alias in the Management ReportsContent I have one report where in A.O. and A.S.F text is use in the suffix of the member name. if the entity is consist of text "Approp" will use A.O. or else use A.S.F…Himani Jain-Oracle 20 views 2 comments 3 points Most recent by Himani Jain-Oracle Narrative Reporting -
Missing Salary Report on OTBIContent Hi all. I'm trying to build a simple report on OTBI that reports the employees who are missing salary at the current date. I tried to use both Compensation - sal…BenZionP 80 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM