Reports
Discussion List
-
Briefing Books FunctionalitySummary Briefing Books FunctionalityContent Hi All, I would like to know the briefing books functionality, Please share the briefing book document or session video if an…[Deleted User] 40 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM -
Procure to Pay dashboard not displaying invoice amount on Invoices tabContent We have just discovered the Procure to Pay dashboard and are very interested in the Invoices charts and metrics however every reference to a display which involv… -
Page break in reportSummary Page break in reportContent Hi all, We have a financial report with a grid with just one row, with two sparse dimensions (entity + product) in the row and two de… -
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…Sam Samaddar 47 views 4 comments 1 point Most recent by Sam Samaddar Reporting and Analytics for ERP -
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha…Sushan Peiris 371 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
Tile in Fusion for Managers to directly take them to their Manager ReportsContent We are trying to figure out if it is possible to create a tile in Fusion for anyone with a Manager role to have a tile to take them to our Manager Reports folder…User_2025-02-05-16-39-03-485 47 views 4 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM -
DATA_CACHE column deprecation from HRC_TXN_DATA tableContent We are currently on Oracle HCM Cloud 20D. We have a scenario where we need your suggestion/feedback. Oracle is deprecating DATA_CAHE column from HRC_TXN_DATA tab…Abhishek_Jain 91 views 2 comments 2 points Most recent by Hari Arumugam Reporting and Analytics for HCM -
Retrieving Affected Party column in HRHDContent Sharing the data model for reference and for others to benefit. This column was unavailable in OTBI at the time the report was built.User_2025-02-10-08-27-16-805 42 views 6 comments 1 point Most recent by Noopur Sapatnekar Reporting and Analytics for HCM -
Mail Merge TemplateSummary Create a document that will populate certain fields directly into the documentContent Looking to create a document i.e. VOE that will grab and populate the data … -
Calculating Month difference between DatesContent Hi, I have Data looks like bellow . Emp No. Occurrence Partnership Level Partnership Level Date Months Difference 1 1 Level1 1/1/2006 Months (12/1/2007-1/1/2006)…User_2025-02-07-19-03-14-525 48 views 6 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Report Recipient's list ReportContent Hi All, Is there any way to get Report for all recipients list. Recipient Name Report Name Frequency abc Report1 Daily xyz Report 12 Monthly Thanks, VijayUser_2025-02-07-19-03-14-525 30 views 1 comment 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Do we have any report to see configured Approval Rules?Content Hello, We need a list of all HCM related processes for which approvals are configured in system. Do we have any report or query through which it can be extracted…Devanshi Fulvani 28 views 2 comments 0 points Most recent by Devanshi Fulvani Reporting and Analytics for HCM -
How can I Remove Create/Catalog for some usersSummary How can I Remove Create/Catalog for some usersContent How can I Remove Create/Catalog for some users, because I need buttons enable specific usersMurilo Damasceno 44 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Reports Note Function with Note Template parameter not workingSummary Note Function with Note TemplateContent I am trying to use a Note function in a MR grid. I have multiple Note Templates that overlap on the same POV. I want to d… -
Candidate and questionnaire JOIN BIP reportContent Hi,How to join the questionnaire and answers to a specific candidate in BIP.does anyone have a working SQL that can share ? Thank YouAwadhendra Tripathi 33 views 1 comment 0 points Most recent by Juan Rendon Reporting and Analytics for HCM -
Workers Compensation wage reports neededSummary Looking for recommendations and examples of reports related to Workers CompensationContent Our team that administers our Workers Compensation programs has not fo… -
"Procurement - Requsition real time" x "Workforce Profiles - Model profiles real time"Summary Relate procurement with workforce to get department nameContent Hi, We are trying to relate the procurement requisition real time subject area with the workforce…Yordan Oliveira 19 views 4 comments 0 points Most recent by Yordan Oliveira Reporting and Analytics for ERP -
Can we call Lookup value in OTBI analysis?Summary Calling up Lookup value in OTBI analsyisContent We are setting up an OTBI analysis using 'Subledger Accounting- Journals real time'. We want to call look up valu…Yogesh Mhalgi 826 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Need help with BI publisher reportSummary Need help with SQL for BI publisher ReportContent Hello, I have a BI publisher report that is run at the end of every pay period to provide payroll information o…GauravGupta39 51 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Query to check if an invoice have a prepayment included or notContent Hi all, I want a query that can provide me with a flag whether an invoice has an applied prepayment or not. I checked if a flag is available in the invoice table…Sushan Peiris 65 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
How to schedule BI report only when it has dataContent Hi All, Can some please help me if its possible to schedule BI Report when there is data. I know we do it in OTBI in condition tab. Thanks, VijayUser_2025-02-07-19-03-14-525 37 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
What's New in 21.07?Summary Better late than never for me to post...Content Yes, I know I'm 2 weeks later than normal. Sorry if you haven't been able to sleep at night awaiting this post bu…