Reports
Discussion List
-
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 12 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 279 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 36 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…
-
Is Function "Drill on shared members" for Reports available?Summary: Is Function "Drill on shared members" for Reports available? Content (required): In reports I cannot find the function "drill on shared member" or any equivalen…
-
Can we have a multiple bursting in one reportSummary Can we have a multiple bursting in one reportContent Hello, Can we have multiple bursting in one report, I can create multiple burstings within the data model an…Koteswararao Yenikepalli 716 views 3 comments 2 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Schedule job list wanted by name of schedule time interval by schedule process by status waitSummary: I need the Report that can show me all schedule process running on interval and because we have many schedule process running. We have no track of those schedul…JayaramK_yash 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Is there other table store info about qualified entitlement planHi Teams, table anc_per_abs_qual_entl is holding the data when user records an absence, do we have any other table or view stores the entitlement information when user n…
-
Ability to load data into custom objects in file based using API similar to FBDISummary: We have a requirement to upload data into custom objects created using application composer file based, similar to FBDI approach. Has oracle exposed any service…Jepson Erattuparmbil 21 views 2 comments 0 points Most recent by Alex D-Oracle Reporting and Analytics for ERP
-
supplier bank accounts fusion querySummary: I am trying to retrive the supplier bank accounts loaded in fusion at supplier header level. I have loaded bank accounts with only BANK_ACCOUNT_NUM. I did not i…
-
The filter should show just the Years: 2021 2022 2023 2024Hi, this is about the excel format ,When the user clicks on the filter for Date of Joining or Last Working Day, instead of seeing individual dates like:30-Jan-2023 08-Fe…SenthilRaja 12 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL query to get net pay amount of an employee on the monthly basisContent Hi All, Creating an outbound interface where need to fetch the employee's monthly net amount. Hence, need SQL query for the same. Context: Employee have multiple…
-
Changing Fonts in PDF Forms within FinancialReportsWe are creating forms in FinancialReports and outputting them as PDFs. We wish to change the font used in these forms. We have confirmed that fonts can be changed on a c…
-
Need Seeded Data Extraction from HCM to Other SystemsHi Team, Can you please help us with the best available options for the below case… One our Entity has divested a portion of its banking business to another entity. The …
-
Can we customise notifications to users only if there is any data generated after an ESS job runs.Summary: We have a requirement for which we want the notifications/Emails to be sent to users after an ESS job runs every week and if it does not have any data we don't …
-
Request for SQL/OTBI to Extract Scheduled Process Parameters (ESS)Details: We are looking for a way to extract Scheduled Process details (ESS), specifically the following information that is visible in the UI for processes such as Calc… -
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…Sahil_Makhiza 489 views 25 comments 0 points Most recent by NeenaS25 Reporting and Analytics for ERP