BI Publisher
Discussion List
-
How can i query the "Active" Organization Tree version description?Summary: How can i query the "Active" Organization Tree version description? Content (required): I'd like to be able to return the value / name of the Version ID tied to…Shant Karakashian 4 views 1 comment 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
Embedded Reports not loading 1st time opening the screensSummary: Embedded Reports not loading 1st time opening the screens Content (required): Hello We have 2 embedded reports in the absence screens which are not loading on t…Helen Thomas 9 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The …Vijay Ramani VJ 33 views 2 comments 0 points Most recent by Vijay Ramani VJ Reporting and Analytics for HCM -
Query to extract Mail address Effective start dateSummary: Content (required): Hello experts, please, could you share the SQL query to extract employees effective start date? Thanks in advance for your time! Kind Regard…Valerio Curzi 40 views 9 comments 0 points Most recent by DavidBlake Reporting and Analytics for HCM -
Unable to find the Subject area/SQL query to get the Final close date value in the PayrollRelationUISummary: In the Payroll Relationship UI we have final close date value at the Element duration dates as well as Assignment level. I am unable to find any subject area/SQ…
-
Table and field references for compensation manager hierarchySummary: Content (required): Hello experts, for this compensation campaign we should change the manager hierarchy workflow and we set the primary hierarchy as in the att…Valerio Curzi 17 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…Jaeyshree Kumaran Kalpana 34 views 7 comments 1 point Most recent by Jaeyshree Kumaran Kalpana Reporting and Analytics for HCM
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
Unable to see xls export option for BIP report after 22DSummary: Unable to see xls export option for BIP report after 22D Content (required): Hi , we are unable to see xls export option for BIP report after 22D and xlsx gives…PriyankaM 25 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Organization logo not showing up when exported (MHTML format)Summary: Organization logo not showing up when exported (MHTML format) Content (required): Hi , We have added organization logo in RTF header, and it shows up correctly …
-
Query to extract Goal Measurement IDSummary: Content (required): Hello experts, as MeasurementId is not available in OTBI analysis, please could you share the query to extract this information? Thanks a lo…Valerio Curzi 20 views 4 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …Swati U 29 views 2 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for HCM
-
Is there a way to encrypt the scheduled reports?Summary: Is there a way to encrypt the scheduled reports Content (required): We are looking into scheduling reports but we need to make sure there is an encryption in pl…Balazs Grajczar 22 views 2 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
Which table holds the HR Representative Data for a particular employee?Summary Which table holds the HR Representative Data for a particular employee?Content Hi, Can anyone please let me know, which table holds the HR Representative Data fo…User_MC37Q 83 views 20 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Table which stores User password expiration dateSummary: Table which stores User password expiration date Content (required): Hi All, Which table stores the user password expiration date? The user wants to create a re…
-
Is it possible to build workforce compensation approval workflow by OTBI or BI?Summary: Hello experts, our customer would like to represent the workforce compensation approval workflow by report. Do you know if it is possible to do it by OTBI or BI…Valerio Curzi 20 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL Query to retrieve User Status both Active and InactiveSummary: Query to retrieve User Status both Active and Inactive Content (required): Trying to put together a query that will tell which users and how many of those are e…Edwin Martinez 49 views 2 comments 0 points Most recent by Edwin Martinez Reporting and Analytics for HCM
-
Any BIP reports to pull Tax withholding details. Federal, State, Local tax dataSummary: Any BIP reports to pull Tax withholding details. Federal, State, Local tax data Content (required): Version (include the version you are using, if applicable): …Prabhu Krishnamoorthy 32 views 6 comments 0 points Most recent by Chelsea Holden Reporting and Analytics for HCM -
Dashboard with BI report linkContent Dear All, I have a requirement to create a dashboard with the direct links of BIP reports. Whenever user clicks on the link, it should directly generate the repo…JYOTI MAURYA 91 views 9 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP - Non Catalog Item Report (Learning)Does anyone know how to fetch creation date using BIP? Please see screenshot below:Hazel De Castro 37 views 5 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Function to replace accent characters with respective characterSummary: Function to replace accent characters with respective character ex: O'Brian to O Brian, Noël to be Noel I need something like ascii using which it will directly…
-
SQL query to see the dependents for an employee who have pending action items in benefitsHi Experts, Can anyone please share an SQL that can show me the list of all dependents for an employee who have a pending action in the benefit plans? Say for a dependen…Aloka Bhattacharya 24 views 2 comments 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Unable to resolve " ORA-01427: single-row subquery returns more than one row"Summary: Hi Experts, When I open a BI report, I am getting, "ORA-01427: single-row subquery returns more than one row" Error. I checked each subquery and all subquery re…
-
FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle CloudSummary: FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle Cloud Content (required): We got mail from Oracle Cloud Saying following : As par…
-
Using COUNT function in Excel Template in BI PublisherSummary Using COUNT function in Excel Template in BI PublisherContent Hi All, Can someone please provide an example of how to use the count function in BI Publisher Exce…Aloka Bhattacharya 36 views 2 comments 1 point Most recent by Valeriy Gorbunov Reporting and Analytics for HCM
-
Address Validation report for USSummary: Hi, Do you have sample address validation report for US? Thanks, Content (required): Version (include the version you are using, if applicable): Code Snippet (a…
-
How to create .txt files using burstingSummary: Requirement is to generate a .txt file with Job Posting description for Job Requisitions meeting certain criteria Content (required): We are having issue in gen…Arathi Devi H 17 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Link to the offer in the personalized notificationSummary: Content (required): Good morning everyone, we are developing a package of custom notifications on rtf templates and excel attachments to be provided to a custom…Gerardo Peluso 5 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM