BI Publisher
Discussion List
-
Need help from substr and instr function used in etext templateSummary: Hello Team, I need help from substr and instr function used in etext template. For Ex; NAME (11001-Benefits Services) in etext template, i used substr(NAME, 7, …Janardhana K 133 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
BI Publisher for word is stuckSummary: BI Publisher for word is stuck Content (please ensure you mask any confidential information): Hi, BIP for MS Word has stopped working and the application is get… -
How to get specific value from XML_DATA_CACHE columnSummary: How to get specific value from XML_DATA_CACHE column in FUSION.HRC_TXN_HEADER table ? Content (please ensure you mask any confidential information): Version (in…Shlomo Elnekave 361 views 4 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
How to Associate RTF template with Data Model and configure E-Signature Validation.Summary: Hello All, Need support on below requirement. Kindly share if you have any reference. I am trying to the Fleet Safety acknowledgment document with an electronic…RamkumarKadhiravan 11 views 0 comments 0 points Started by RamkumarKadhiravan Reporting and Analytics for HCM -
Need to find table to get all Bank account related informationTeam, i need to fletch all the data related to bank account , can you please suggest which table suits ? ThanksNaidu.R-Oracle 23 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Audit trial for events on some modulesfor audit purposes , can we get a log if a person export data from module, or if a user query about data ? (like the search in the person managment for employee's data)Mustafa Abu Dayeh 1 view 0 comments 0 points Started by Mustafa Abu Dayeh Reporting and Analytics for HCM
-
Security and AOR Report: Inactive Assignment Locations IssueWe created a Security and AOR report that provides person roles and areas of responsibility. The expected result is when a user runs this report he should able to see al…Niranjan_1190 42 views 1 comment 0 points Most recent by Niranjan_1190 Reporting and Analytics for HCM
-
Need info on how to connect Absence Table with Time And LaborSummary: Hi All, I am facing an issue to connect the Absence Table with Time and Labor Tables to Fetch Absence Entry on Timecard. We basically want to Fetch absences ent…Abhishek Bhaskar 103 views 2 comments 1 point Most recent by Dineshkumar Ammasaikutti Reporting and Analytics for HCM -
Custom BI Reports and tables performance issue in fusionSummary: Hi Team we are recently facing performnace issue on PAY_PAYMT_SEARCH_RESULTS_VL view and it is resolved automatically after one week. Could you please provide d…Venkatesh Emani-Oracle 24 views 2 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration
-
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 12 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 292 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 13 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 44 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 11 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 22 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 13 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 17 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 1 view 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 243 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 77 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 29 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM