BI Publisher
Discussion List
-
SQL query to retrieve compensation plan status at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, I need to track for all employees the status of their line managers compensation p…Valerio Curzi 402 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to display the filters in a BI Report, in multiple rowsSummary: How to display the filters in a BI Report, in multiple rows Content (please ensure you mask any confidential information): Hi, we built a BI Report, entering se…Barile Alberto 21 views 1 comment 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM -
How to add Business Title from Worker Assignment Realtime in User System Usage subject area?I have created an analysis under User System Usage subject area. However, upon adding Business Title column from Worker Assignment Realtime subject area, data became emp…Welsey 26 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to add SQL query in where statement for creating parameters and the list of valuesSummary: Hi I need to create parameter for country can anyone help me how to write the line in where statement and list of values , Select PAPF.PERSON_NUMBER, per_extrac…
-
How to add Cust Account and Cust Site Info to 'Receivables Aging by General Ledger Account Report.Summary: How to add Cust Account and Cust Site Info to 'Receivables Aging by General Ledger Account Report. Content (required): Problem Description ---------------------…
-
How to trigger notifications to the Mobile Numbers instead of Email IdSummary: Hi Team, We know that the notifications will be triggered to Email IDs through bursting and the customer asks to trigger the notifications to the employee's mob…Dasari Dileep 1 view 2 comments 0 points Most recent by Dasari Dileep Reporting and Analytics for HCM
-
bip query is very slowSummary: I have written a BIP query which runs fast in SQL Connect using one bind variable. When placing the query into a BIP report there are no issues but the query so…JDCal 85 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Issue on value set retrieving custom field in person profileSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom value set retrieving a custom attribute in person profile. At …Valerio Curzi 1 view 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Cannot retrieve Manager IDSummary: Content (please ensure you mask any confidential information): Hello experts, I've created the attached value sets retrieving the employee Manager ID. If I laun…Valerio Curzi 11 views 3 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Extracting the "Write to person profile on completion" of a course "Skills and Qualifications" pageSummary: Hi We are currently trying to determine te perimeter of the courses that do not have correctly set the flag option "Write to person profile on completion" due t…
-
Help on manager hierarchy fast formulaSummary: Content (please ensure you mask any confidential information): Hello experts, I need to replicate the line manager hierarchy in compensation plan. However, we s…Valerio Curzi 36 views 0 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Query retrieving manager job nameSummary: Content (please ensure you mask any confidential information): Hello experts, how can I retrieve the line manager job name? I've used the following query but th…Valerio Curzi 102 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Query to retrieve employee Job nameSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample SQL query retrieving the employee Job name visible in the ass…Valerio Curzi 718 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
sql to use in custom BIP report to restrict data dynamically based on the users data security&accessWe are trying to build an custom BIP report/sql script to restrict data dynamically based on the users roles and their data access in fusion (for example, to query AP in…daniel4u2uk 624 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Termination Approval Process ReportHi… does someone have a report, either an OTBI or BIP, that captures the full termination process with comments, who it is/was assigned to, and status. We are having iss… -
Report a Course - Comment Attribute within OTBISummary: When a learner goes into learn and reports a learning item, a report is generated in OTBI and sent out to the recipients. This report does not include the comme… -
SQL query to retrieve a common lookup description at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom common lookup. We need to extract at the employee level the lo…Valerio Curzi 293 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Multiple Assignment ReportSummary: Does anyone have an XML or data model that captures employees with two (or multiple) active work assignments; showing job, department and manager details. Conte…
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
Participant Feedback - Questionnaire Responses duplicationSummary: Dear Team, We have a Performance template which has the Participant feedback included and would like to capture the responses provided by the Participants in th…Arun Kumar Krishnan [AK] 72 views 4 comments 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM -
Extract a list of custom reports in HCM from OTBI and BI PublisherSummary: Is it possible to extract a list of custom reports created in OTBI and BI Publisher, including: The subject areas and folders used, and the fields in them and o…Paul Morrissey 93 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
SQL query of Fast Formula retrieving manager+1 and manager+2Summary: Content (please ensure you mask any confidential information): Hello experts, do you have an SQL query or fast formula to retrieve the employee manager+1 and ma…
-
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…Sudheer YN 201 views 8 comments 0 points Most recent by Dianne Barnhouse Reporting and Analytics for SCM
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…GauravGupta39 21 views 4 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
HCM Reporting/Extracts usage recommendationsSummary Out of plane vanilla sustainable reporting ideas for HCMContent Disclaimer: following post expresses personal opinion of author based on many years and many rele…Valeriy Gorbunov-80491 76 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Where can I find release notes regarding OTBI and BI Publisher for HCM?Hello, I am looking for Release Notes or What's New regarding OTBI and BI Publisher for HCM Cloud. Could you please help me find where they are? Kind regards AliceAlice Gouzy 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fast Formula or query retrieving the number of working daysSummary: Content (please ensure you mask any confidential information): Hello experts, it is possible to build an SQL query or Fast Formula retrieving the number of work…Valerio Curzi 427 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Table to see RA_INTERFACE_LINES attributesI popoluted the DFF in RA_INTERFACE_LINES, and I need to view them in a query, in join with ra_customer_trx_all. Which tables stored information about interface_line_att…ACNROMA2023 11 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Roles and Privilege required for ExternalReportWSSService creation using SOAP WebservicesWe created a call for a report using Soap Webservice, but we need to add the role or privilegies to our User. Someone knows them? Thank you so muchACNROMA2023 171 views 2 comments 0 points Most recent by Humberto Martín-Oracle Reporting and Analytics for ERP
-
ORACLE FUSION HCM QUERY TO GET USER ACCOUNT LOCKEDSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Daniel Paul-183648 792 views 6 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM