Category 81
Discussion List
-
Employee Length of service (LOS) sql query based on Hire Date/Rehire Date in fusion hcmHello Team, I need a sample Employee Length of Service (LOS) SQL query based on hire date/rehire date in Fusion HCM to use outbound integration for one of my customers. …Janardhana Kondaveeti 334 views 1 comment 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
How to get completion record for learning activities under course and offering?Summary: Hello, I'm trying to create a report for completion of activities. Can anyone point me where to find from the Workforce Learning - Learning Records Real Time su… -
What privilege or configuration is needed to ensure the user could view Demographic Info it in OTBI?Summary: Content (please ensure you mask any confidential information): One user can see PER_PERSON_LEGISLATIVE_DFF on the screen but not in OTBI, while another user can… -
SQL to extract location mailing addressSummary: Please could you let me know the SQL to extract mailing address that is stored in Manage Locations task. I have checked in the HR_LOCATIONS table but I cannot f…
-
How to have the report names show when embedded on the left side bar?Summary: Hi there, We are embedding reports as pages/tabs to the left side of certain pages I'm not sure how to get the name of the tab to show. Is there a setting that …Ruby Hui 4 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Run Payroll Costing Results - load column into FDI?Hello, Is there a way to take a column from the seeded Run Payroll Costing Results report and move that into FDI for reporting use? The need for it is stemming from payr…Sean-B-01 18 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP | SFTP filenames with .XLS or .XLSX extensions are not readable in SFTPSummary: Hi Experts, My requirement is to place the SFTP file in .XLSX format. SFTP filename with .XLS or .XLSX extensions are not readable in SFTP, but filenames with .…Arti_Priya 16 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
ANC_PER_ABS_DAILY_DTLS - Issues with Overnight Shifts / Absence BreakdownSummary: We want to report on absences related to a shift, however the table seems to store the hourly breakdown per day rather than per shift start date. Example; 25/06…
-
Numbering Adjustment in RTF TemplatesCustomer have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is di…Sonal_Lalwani 24 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Can I download bi publisher to mac?Summary: Hi team, I want to switch to mac , I saw that is problem to download BI publisher, someone tried? and there any other problem with mac?Guy_Ora 8 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Rolling Average Wage ReportHi Does anyone have a sql query or a report that provides the average weekly wage over a 52-week period based on a specific date? We are trying to provide our Workers Co… -
How to return specified run result values on one row in Payroll Run ResultsSummary: Without using a pivot table, how can I get payroll run results to show input value names as the column headers, then the relevant run result values horizontally…
-
Impact in the reports/dashboards after enabling RedwoodHave you encountered any issues with Reports/Dashboards after enabling Redwood across the HCM modules? Is there any documentation or impact analysis available for this? -
What table stores the extended lookup code name for Visas and Permits?Summary: I am trying to build a DM for Visa and Permit notifications. What table stores the extended lookup code name for visas and permits? I would assume there is a ta…Luke.Findex 36 views 5 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
How to get the Job offer Approval history in a BIP report?Summary: Hello, We have a requirement to fetch the approvers, their approval comments and the date of approval in a report. How do we get this via BIP report? Version (i…Shreya Datir 63 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
I want more than 2 prompt input lines in OTBI.Summary: I want more than 2 prompt input lines in OTBI. Content (please ensure you mask any confidential information): When a graph is created in OTBI, the value list is…User_53LLL 8 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is there a way to find all data-models that use Bursting?Summary: We are planning a change in Sender Address in our ERP Instance and one of the requirements is to also amend it for all the Bursting reports configured in the sy…Prateek Mohan 10 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Reporting Agent failed with error message SQLSetStmtAttrWSummary: We have reporting agents set up which all ran into error, when normally no issues. Content (please ensure you mask any confidential information): We have report…Max W 16 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 657 views 7 comments 0 points Most recent by ManavM Reporting and Analytics for HCM -
Filters on evaluation deep linkSummary: Filters on evaluation deep link Content (please ensure you mask any confidential information): I have the following deep links: Evaluate Performance (EVALUATE_P…Stefano_Mazzocca 15 views 2 comments 0 points Most recent by reneechapa Reporting and Analytics for HCM -
Calculate number of DAYS between two dates in XX YEARS XX MONTHS XX DAYS format in OTBISummary: We have a requirement in OTBI analysis to calculate the number of days between 2 dates in the following format – XX YEARS XX MONTHS XX DAYS. We have tried some …Balakumar231286 70 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Standard PL/SQL API Caching ErrorWe use SOA to expose a PL/SQL procedure as a REST API and post requests to it. This procedure utilizes standard PL/SQL APIs to create and update Person and Assignment re…Salma Mohamed Salem 5 views 0 comments 0 points Started by Salma Mohamed Salem Reporting and Analytics for HCM
-
Trying to add a telephone number hyperlink like "tel:###" to an RTF template for BI email burstingSummary: I'm trying to add a clickable telephone number hyperlink like "tel:###" to an RTF template used for BI-Publisher email bursting. According to this, it should be…
-
release statement to workerSummary: We would like to report on the field " release statement to worker" to check how many Line Managers have enabled this for their direct reports once comp cycle i…Manoj B. Cheruvathoor 7 views 3 comments 0 points Most recent by Saliha MAACHA Reporting and Analytics for HCM
-
How to encrypt and decrypt images in Oracle fusionSummary: How to encrypt and decrypt images in Oracle fusion Content (please ensure you mask any confidential information): Hi All, We got a requirement to encrypt and de…
-
Can you help me to adding the name of the employee in this SQL query?Summary: Hello team! I have this code, but I don't know how to add the name of the employee. Could you please help me with that? Content (please ensure you mask any conf…Claudia Linares L 27 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Query to get Vacation Rules informationSummary: Query to get Vacation Rules information Hi, We need to create a report for vacation rules for all employees in the system and I know that there is a seeded repo…Kiran345 649 views 14 comments 0 points Most recent by Deepak Kumar Dev-Oracle Fusion Applications Administration
-
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis…
-
BIP Pivot Table Row Label Header PropertySummary: Hello, I'm trying to have a header label for my rows in a pivot table in BI Publisher. I'm using the Row Label Header property but does not show anything. Can y…Guillaume SAVALL 145 views 6 comments 0 points Most recent by Austin Rodola Reporting and Analytics for HCM