Get Started with Redwood: Oracle Cloud SCM and Purchasing
BI Publisher
Discussion List
-
BIP Query to list 'Data Security Policies' tied to a job roleSummary: Client has a requirement to list ALL the Inherited Roles, Privileges and 'Data Security Policies' tied to a job role. We are able to list the Inherited Roles, P…Shrikant Gupta 641 views 8 comments 0 points Most recent by inoappsms Reporting and Analytics for HCM -
How to link absence details and payroll detailsSummary: Hi all We need a report that provides absence details along with the payroll elements processed based on those absences. Specifically, for the OFFICIAL TRIP abs…Shameer Muhammed P M 46 views 0 comments 0 points Started by Shameer Muhammed P M Reporting and Analytics for HCM -
We need to get Timecard reason on like WFH or Client Site and so onWe need to get Timecard reason on like WFH or Client Site and so on please help with relevant tables
-
BIP error oracle.xdo11g.xqxp.XQException: FORG0001Summary: BIP error oracle.xdo11g.xqxp.XQException: FORG0001 Content (please ensure you mask any confidential information): Hi Team, Greetings! We have run into error for…Parag Hiremath 247 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
Is Oracle BI Publisher Desktop Plug-In freeSummary: The Oracle BI Publisher Desktop Add-In, which can be downloaded to work with MS Word and Excel, requires a separate license for installation on machines. We are…User_OPF0Z 170 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Requirement for Custom QuerySummary: Hi Experts! We had a requirement from the customer to have a role which would grant access only to CONTRACTOR records and should satisfy the following condition…
-
Is it possible to report on Workforce Compensation Change Statement Volumes executed by managers?Summary: We have our Compensation Change statements configured to Printed and delivered by managers, we would like to monitor and report on how many managers are accessi…Adam_Cantwell 13 views 1 comment 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM
-
BIP Report schedule to send data only when it has dataSummary: I want to schedule a BIP Report daily but it only send the report if there is a data in the report. If the report does not have any data, it will skip. Content …Haikal Hamdan 21 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…Abhishek Jois 229 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How can we call BIP Report from Offer Progress Redwood Page through parameterSummary: Navigation: MyClientGroup>Hiring>Job Offer>Progress Content (please ensure you mask any confidential information): Version (include the version you are using, i…Nagendra Chitra-Oracle 23 views 0 comments 0 points Started by Nagendra Chitra-Oracle Reporting and Analytics for HCM
-
Query to get Position History along with Changed Attributes.Summary : I have a requirement to find out Position History details along with the changed attributes as shown in screenshot below. If anyone have query for this kindly …
-
Calculate FTE and headcount automatically filed nameSummary: Calculate FTE and headcount automatically filed name Content (please ensure you mask any confidential information): In the "Change Assignment" UI, we have "Calc…Visu 23 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
How to use the BIP Report Data Set (Sql queries) into the OTBI Subject AreaSummary: We have created a custom HCM OTL Roster report on the monthly basis based on the scheduler profile. We have to use these Data Set (SQL Queries) directly into th…Venkatesh Babu Somalinga 100 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to create report for this absence plan pageSummary: Hi , I want to code this page , can anyone help me in this . And i want to get the it as of balance calculation date my report should work. Content (please ensu…Vishnupriya 12 views 1 comment 0 points Most recent by Ionela - Oracle Reporting and Analytics for HCM
-
BI Publisher report errors while running from Scheduled ProcessesSummary: Hello Team, Our technical team has developed a BI publisher report under Reports and Analytics—>Custom—>HCM folder. But when a user tries to run the same from T…Neha_C-Oracle 65 views 4 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Date a collaborator was added on req ORCSummary: Is there a way to report off when a collaborator was added to a requisition? Content (please ensure you mask any confidential information): Version (include the…Shanna Oppenheim 3 views 0 comments 0 points Started by Shanna Oppenheim Reporting and Analytics for HCM -
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …Tejashree S 55 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 28 views 12 comments 0 points Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM -
Query to get the scheduled work hours of employee from shifts the employee has assignedContent I have a requirement to report the weekly work hours the employee is scheduled for. Employee will be assigned work schedule and work schedule will be liked with …Raghavendra M 4.5K views 7 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
SQL Behind the Package FUSION.PAY_BALANCE_PKG.GET_VALUE_DBIWe are trying to debug one the issue in BIP SQL where they have used the FUSION.PAY_BALANCE_PKG.GET_VALUE_DBI to bring the data from this column. But wea re not able to …
-
Is there a way to export HCM organizational charts?Summary: What are the options to take HCM organizational charts and export them in some type of format that could be used in a PowerPoint? Content (please ensure you mas…Dae 68 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hide catalog and home options to usersSummary: Hide catalog and home options to users Content (please ensure you mask any confidential information): Hi Team, I have a requirment, in my organization under me …
-
Report to get the Listing the existing reports with the subfoldersSummary: Report to get the list of all existing seeded and custom BIP reports Content (please ensure you mask any confidential information): Hi All, Greetings! Is there …Parag Hiremath 28 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
When does the STATE column in table HRC_TXN_DATA changes to 'INITIAL'Summary: An approval transaction is always showing as DRAFT status in the table HRC_TXN_DATA with STATE column having value 'INITIAL'. This transaction is not visible th…Anoop K N 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF …Cansel Karasoy 42 views 9 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
Pension Automatic Enrolment calculation card report in OTBISummary: Content (required): Hi, hoping someone can steer me in the right direction here. I'm looking to report on the data contained in employees' PAE calculation card …
-
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…Kamini Kaushik-Oracle 492 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
SUM in Table ValuesetTeam, We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful. SELECT SUM(peevf.screen_entry_value) FROM pay_element_entries_f …
-
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1…User720640-Oracle 399 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM