BI Publisher
Discussion List
-
HRC_TXN_CONSOLE_ENTRY table is not fetching the effective_start_date updated during approval processHRC_TXN_CONSOLE_ENTRY table is not fetching the effective_start_date updated during approval process by HR , instead it has the effective_start_date entered in when and …Kavya Sreenivasulu 11 views 2 comments 0 points Most recent by Kavya Sreenivasulu Reporting and Analytics for HCM -
Performance document questionnaire with answers for worker and manager queryI am trying to build a query for Performance document questionnaire with answers for worker and manager query but its not giving correct answers. When I add the tables f…Deepeeka Nath 328 views 0 comments 0 points Started by Deepeeka Nath Reporting and Analytics for HCM
-
Error when we schedule a notificationSummary: Error when we schedule a notification Content (please ensure you mask any confidential information): We schedule a report (once a day). The Data Model and the r…Barile Alberto 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Restrict user to go to Analytics pageIs there a way to restrict user to access to Reports & Analytics page. From Structure i have disable the Report & analytics page from Navigator and springboard. But we a…Sourabh Patial 56 views 7 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Need inputs to display Payroll Run Results based on JobSummary: Need inputs to display Payroll Run Results based on Job Content (please ensure you mask any confidential information): We need to display Payroll Run Results da…Visu 21 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
How to get the meaning of the MODULE_NAME( PER, WLF etc) from FND_APPL_TAXONOMYSummary: How to get the meaning of the MODULE_NAME( PER, WLF etc) from FND_APPL_TAXONOMY Tried with FND_LOOKUP_VALUES.Meaning does not return any vaue Can anybody Please…MilanMohanty 12 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Can we have multiple RTF templates as links instead of tabs in BIP report?Instead of having as tabs in case of multiple templates, we would like to have them as links in single view/screen, in one page. Attached the usual format, which we don'…
-
Report to show all employees who have not been paid in last 3 weeksSummary: Need a report to see the employee, assignment, last paid date and benefit termination date for the employees who have not been paid in last 3 weeks. Content (pl…Priyabrata Prusty 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Excel Report Errorummary: Hi experts, we are trying to upload a ready excel file as a Report, but we continue to receive the following error message when trying to view it. We have alread…Marlon Castillo Maliglig 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to display XML tables in BI PublisherSummary: How to display XML tables in Word's BI Publisher add-in Content (please ensure you mask any confidential information): Hello. In my project, I am using Word's R…Keita Furuya 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to handle the data which has a new line in it in LOV/BI Reports.Summary:User has mistakenly entered new line in a column, where data type CLOB is text, for that the LOV value is populated in 2 line and the report parameter is not han…Sura Yashaswini 12 views 3 comments 0 points Most recent by Sura Yashaswini Reporting and Analytics for HCM
-
Periodic Payroll Activity Report bursting Based on LocationSummary: Hi I have a requirement to split Periodic Payroll Activity report based on location. I tried bursting option by creating a copy of globalreport data model and c…
-
Unable to convert date in specific formatSummary: We are fetching termination date from xml table which is fetched in string format. We need to convert date in format 'DD-MON-YYYY' which is not happening. Data …Arpit Dhalawat 15 views 2 comments 0 points Most recent by Arpit Dhalawat Reporting and Analytics for HCM
-
How to report on Directly Assigned detail in AOR TemplateSummary: I'm looking to report on the Directly Assigned detail in an AOR Template Content (please ensure you mask any confidential information): I've looked in all the A…
-
How can I access the candidate profile source via BI publisher?Summary: I need to access the source fields on the candidate profile. I have so far identified that I can access the application source via the IRC_SOURCE_TRACKING table… -
Enterprise Hire Date in BI PublisherSummary: Enterprise Hire Date in BI Publisher Content (please ensure you mask any confidential information): Hi, we would like to create a BI Publisher report which cont…Barile Alberto 22 views 4 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Payroll Balance Real Time - Multiple Assignments Not showingSummary: Trying to pull a report with the Payroll Balance Real Time that brings in the multiple (primary & secondary) assignments with hours worked & payroll for each as…Rhonda Fischer 2 views 2 comments 0 points Most recent by Rhonda Fischer Reporting and Analytics for HCM -
Need help on Long Running Custom BI Report - running more than 5 hours and failingSummary: The Custom bip report is running for long time(more than 5 hours) and erroring out saying that "Elapsed Time is exceeded" . Would you please help in tuning the …Rama123-Oracle 278 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to create report of Payroll check numbers with employee name and addressWe have a requirement to provide list of payroll checks with check date, amount, employee name, employee address. If it can be done using "Analysis", please advise on Su…Kit Stephenson 95 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
query to identify the processed and unprocessed payroll transactions for BI reportsVersion (include the version you are using, if applicable): for version "Oracle Fusion Cloud Applications24A (11.13.24.01.0)".Immanuel Aruldoss 37 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
How to report in BI Publisher the Approval Date for Change Assignment TransactionSummary: How to report in BI Publisher the Approval Date for Change Assignment Transaction Content (please ensure you mask any confidential information): Hi, we configur…Barile Alberto 5 views 0 comments 0 points Started by Barile Alberto Reporting and Analytics for HCM
-
How to enable password for P60 Document with date of birthSummary: We are trying to password protect the Oracle P60 document with employee's Date of Birth. The XML doesn't have the Date of Birth tag. Can we modify the seeded Da…SAHAD 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
BI Report for otbi reports and the scheduled agentsWhich table stores the information of otbi reports and its scheduled agents.Aishwarya Somvanshi 66 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Report off of Attachments Within Performance ModuleSummary Managers and employees can add attachements to their performance form. I need to know who has an attachment.Content Our managers can use the attachment field at …User_2025-01-25-00-37-41-739 63 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Resubmission Reason and Resubmission Status values in Manage Time cardsContent Hi All, In which column and table holds "Resubmission Reason" and "Resubmission Status" values. Navigation:Navigator--> My Client Groups-->Time Management--> Man…
-
Manage Administrator Profile Values ReportSummary: We are trying to Fetch the Module Name (Meaning) Can anybody Please advise for fetching the Module Name of Manage Administrator Profile Values Content (please e…MilanMohanty 165 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
link between FND_SESSIONS table to country and stateSummary: link between FND_SESSIONS table to country and state Content (please ensure you mask any confidential information): By using FND_SESSIONS table, we can get the …
-
Oracle Payroll fast formula to fetch from VbyC tables?Summary: Can we access our own VBC records with a Oracle Payroll fast formula to fetch from VbyC tables? ex. PAY_VBC_VALUE_IDENTS_VL OR below picture list. thank you Con…JBW_HCM 7 views 1 comment 0 points Most recent by Divya Jayaraman-Oracle Reporting and Analytics for HCM
-
Query to get delayed payroll flowsSummary: Query to get delayed payroll flows - the ones which did not start on scheduled time Content (please ensure you mask any confidential information): Hi Team, Gree…Parag Hiremath 11 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Looking for System Usage MetricsSummary Reporting on who/when/how/what users are accessing in HCMContent Need to report on system usage and adoption rates for our HCM system with a focus on Employee an…Becky Stalsby 230 views 13 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM