BI Publisher
Discussion List
-
Issue with Subquery/Outer Query with BOM LEVEL - Results Messed UpSummary: Hi everyone, I would greatly appreciate any suggestions or help regarding the use of outer queries or subqueries. I want to use multiple subqueries and join the… -
Based on the parameter year i should get the data based on that year i should get the data.lets say the paramter is audit_year = '31-12-2021' the requirement is something that we should get the data based on the parameter i.e i should get the person record bas…
-
How to have a report send email that report is ready to be viewed in checklist?Summary: We would like to have a report send notification that the report is ready to be viewed in checklist. But, we do not wish to attach the report output to that ema… -
QR Codes For Billing and PaymentsSummary QR Code Integration For Oracle PaymentsContent This summer (June 2020) Switzerland has announced that it will be switching from payment slips (orange and red) to…User_8O6L5 750 views 13 comments 3 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
Payroll Flow - BI Report - Bursting - Not generating output file.Hi folks, I'm generating a payroll report and pushing it on SFTP using bursting. Template, filename and path is derived via bursting .This report is attached to a Payrol…
-
Request Documentation on Critical PVOs for Oracle Fusion HCM Integration with Data LakeDear Team, We have recently implemented Oracle Fusion HCM and are now working on integrating it with our Data Lake. To better understand the critical PVOs required for t…MDge 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Chetana Pawar 811 views 2 comments 0 points Most recent by Maheswar Reddy Reporting and Analytics for HCM
-
Deep link for changes failed to navigate to open up the correct page. BI Publisher ReportI have created a deep link for the Change Order in my report, but the URL opens a blank page and does not work as expected. I tested it by hardcoding a Change ID, but ev…Ramsha Zameer 21 views 2 comments 0 points Most recent by Ramsha Zameer Reporting and Analytics for ERP -
Not able to add Concatenated Segments for the expenses inside the Expense Approval Report Template.Summary: We are trying to include concatenated segment string for each expense item. Content (please ensure you mask any confidential information): Hi, We've a requireme…
-
How to customize the seeded deduction report?Summary: We would like to add additional columns like assignment status to the standard deduction report that runs part of the payroll flow. What is the recommended appr…
-
Table details to get Business unit for a tax code definedSummary: We need table or query to fetch business unit name for the given tax rate code. Content (required): Version (include the version you are using, if applicable): …Nishanth B Jain 131 views 4 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management -
User is facing time out error while running OTBI reportHow can i increase query governing execution time for see error below Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PState: HY000. Code: 1005…Shahid Qureshi 113 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Self Service related Privilege's for Oracle Fusion PayablesSummary: We are looking Self service related Privilege's to Invoice Payables. The below two privileges provide access to Payables and are considered part of the license …Linga Murthy 231 views 4 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Report to identify Users when Clicked on Learning Tile under My Client GroupsSummary: Report to identify Users when Clicked on Learning Tile under My Client Groups Content (please ensure you mask any confidential information): I am looking to see…Thulasi Ram 13 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Overridden Seeded Workflow Notification Templates - what do we do to get the seeded templates?It seems that we no longer have the seeded templates in our Seeded folders. Not sure how long this has been the case, but could be since Go Live (>4 years ago) How do we…Rebecca Hawker 11 views 7 comments 0 points Most recent by Rebecca Hawker Reporting and Analytics for ERP -
Can't access report and analyticsSummary: Content (required): All the users can't access to Reports and analytics even in admin User. The error massage is Insufficient permissions You do not have suffic…LiorZiv 662 views 10 comments 0 points Most recent by Parth Trivedi-Oracle Reporting and Analytics for HCM
-
Is there a function to get the display name from the username?Summary: Content (required): I'm looking for a function where you can pass the username and get the display name returned? I know I can do a query to the per_users table…CraigP 661 views 5 comments 0 points Most recent by Shivendra Kumar-Oracle Reporting and Analytics for ERP
-
How to know list of approver of an employee expense through webservicesSummary: How to know list of approver of an employee expense through webservices Content (please ensure you mask any confidential information): Hi Expert, we have a belo…
-
Does anyone knows how to query current task in Performance Document?Summary: I need the select statement to fetch this value Content (please ensure you mask any confidential information): I'm trying to write a query that selects this fie…Stefano_Mazzocca 222 views 4 comments 0 points Most recent by RahulMore Reporting and Analytics for HCM -
Report Fail with ErrorSummary: Content (please ensure you mask any confidential information): I have created a report to retrieve unreconciled transaction details. The report contains four da…Tharushi Sathsarani 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Query to get Latest offer extended by details in ORCHi Folks, We are trying to fetch the latest offer extended details in our report, we tried latest updated by column from irc_offers, but It didn't work. Scenario: Hiring…Sushant95-Oracle 31 views 1 comment 0 points Most recent by Anu Puchha Reporting and Analytics for HCM
-
BIP publisher email unable to send to icloud candidate emailSummary: Hi, we are using BIP jobs to trigger emails to new hires based on task completion in journeys and recently BIP email is getting failed to deliver to icloud doma… -
How to show an icon based on company?Summary: How to show an icon based on company? Content (please ensure you mask any confidential information): An icon of a report can be shown only if user has specific …Stefano_Mazzocca 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is it possible to access the audit logs of selects placed on certain tables via Oracle cloud?Hi, I need the logs of some tables that are important for confidentiality. Is there a table on BI Publisher that contains the details of who ran it and when it was run i…Cansel Karasoy 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
pay_range_items_f table VALUE1 is empty.Summary: The VALUE1 column for a calculation card element is coming out to be '-999999999' in this table even though the value exists in the front end. The same value is…
-
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 353 views 1 comment 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Is there a way to extract the information regarding the Overflow Check Numbers in Oracle?Auditors needing to see the Overflow check numbers and I could not find any reports that can do fetch that information. Any reference or pointers will be greatly appreci…Kay 1 view 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
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…