Reports
Discussion List
-
Accessing Usage Metrics Drill Through ReportsWe are using version 22B. I received an email about accessing a usage metrics report showing user license consumption. However, I fail to find how to locate / generate t… -
Get Service Usage Metrics Drill Through report on demandSummary: Get Service Usage Metrics Drill Through report on demand Content (please ensure you mask any confidential information): Hi We need have the information about me…Jazmin Saldierna 2 views 0 comments 0 points Started by Jazmin Saldierna Reporting and Analytics for ERP -
Matching Report = Account in Rows behaviourSummary: Content (please ensure you mask any confidential information): Hi all I want to know what is the exact behaviour of "Accounts in Rows" within Intercompany Repor… -
Is there a payroll report that compares the current payroll to a previous payroll?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Passing multiple person numbers as input parameters in HCM ExtractSummary: To pass multiple person numbers as input parameter in HCM Extract Content (please ensure you mask any confidential information): Trying to pass multiple person …
-
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…SireeshaJaladi 51 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Access SmartView from Word and connect Oracle Planning reports , without having Narrative ReportingHello, Is it possible to access SmartView from Word and connect Oracle Planning reports (made with reports and not Financial reporting) without having Narrative Reportin…
-
Create infolets with the use of FDI reportsHello, We have been implementing the new reporting tool of FDI and we have been asked if it is possible to create Infolets for the FDI reports in the home page of Oracle…Ioannis Adamou 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Adding additional column to get headcount for each month in OTBISummary: How to add additional column or calculated item to get the head count for every month? Content (required): I am using 'Workforce Trend Real time Subject Area' a…Raghavendra M 371 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Project to GL Reconciliation ReportCan you confirm if there is an existing Project to GL Reconciliation Report? We are trying to check if there is a counterpart for Projects. Sample is attached screenshot…
-
Which SQL Table store the Activity Information of Time Entry in OTL.Which SQL Table store the Activity Information of Time Entry in OTL. Please share the inputs if you know -
How to find the revenue_category_id from revenue_category_code in PPMI need to filter data using revenue category code in PPM. Revenue category code is kept in PJF_REVENUE_CATEGORY lookup. Now when I use joins in PPM table they are holdin… -
Multiple pdf outputs to be sent to single emailSummary: Hi We are looking for sending multiple pdf's from a report, to a single email using bursting query or to be zipped and sent to a single email Content (please en…
-
Convert excel formula to apply in reports in FCCSSummary: I’m trying to convert the following Excel Smart View formula into an FCCS report formula: =IFERROR(B23-W23,"-") I’ve experimented with different syntax variatio…
-
USOnline Payslip Report CustomisationHi Team, We are looking for detailed steps for customising the USOnline Payslip report, with the output format in XML. Report output should be delivered to FTP. Please s…Swapnil Kashid 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Oracle Fusion Publisher - How to design a template with merged cells and recurring rowsHi Community, I am trying to develop a excel template report for my client with Oracle Fusion Publisher. This report composes of multiple tables with recurring rows at t…
-
Combination Chart with Cluster Stack Bars and Cluster Line in Narrative Reporting not working.Summary: Combination Chart with Cluster + Stack Bars and Cluster Line in Narrative Reporting Content (please ensure you mask any confidential information): Hi All, I’m t… -
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …Amarnath 6K views 17 comments 0 points Most recent by Mostfa Shehata Reporting and Analytics for ERP
-
Start Date change on ORC side - Need to know table where Old start date value is storedSummary: When a candidate is in Post Offer stage and the Start date is changed to a new value, in which table does the old value reside? Context - We are trying to build…Patrick Turcotte 91 views 9 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Can we report on the number of job requisitions raised by "use" type (template, position etc)Summary: We are looking to establish the behaviour of users and which way they raise job requisitions in Oracle Recruiting. Is it possible to report on how many requisit…Craig Hennessy 22 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
HCM OTBI- How do I run report to see any positions with an entry in the 'Funding Source'?Summary: Need run a report to see if there are any positions with an entry in the 'Funding Source' field however I'm unable to find the field in any HCM Subject Areas. C…Sangken 1 view 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Select a particular value from concatenated fieldSummary: To obtain a specific value from concatenated field. The business requirement is to obtain information regarding people reporting to C suite (Senior Leadership) …Pranav Waichal 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to export a Report in a single Excel tab instead of multiple tabs?Summary: Is it possible for a Report that has two or more grids to be exported in Excel as one tab instead of each grid being separated on tabs? Content (please ensure y…AndreeaG 71 views 13 comments 0 points Most recent by Joost Mellegers Financial Consolidation and Close
-
Audit Trail in Procurement and Self Service ProcurementSummary: Currently in Procurement its possible to see only Supplier Audit History. Requisiton and Purchase Orders don't have any detailed history data available. Content… -
Financial Reporting Center reports not showing in searchHello, We are having an issue with reports showing in FRC. When a user searches for a report in FRC they return no results, but if the user navigates to the BI Catalog r…bobby.hussey 302 views 10 comments 0 points Most recent by Florence Z Reporting and Analytics for ERP -
BIP Report - Certification File Attachment - Assemble URL for downloading attachment from reportGreetings, During Auditing, our desire is to be able to quickly download any Certification attachments direct from the BI Report results. I'm trying to create SQL for a …Michael_Burgett 11 views 0 comments 0 points Started by Michael_Burgett Reporting and Analytics for HCM -
Reported Time Card Real Time Performance Very SlowSummary: Reported Time Card Real Time Performance Very Slow Content (please ensure you mask any confidential information): Good Day, Is there a way to improve the perfor…JMLMIII 31 views 10 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
Unable to create OTBI AnalysisHi to all, as an administrator user, when I try to create a OTBI Analysis I'm only able to view my own informations. I can't see the information about other users. The s…