BI Publisher
Discussion List
-
Insufficient Privileges fa_fusion_soainfra.wftaskmetadataSummary Insufficient Privileges for running fa_fusion_soainfra.wftaskmetadataContent Hi All, Trying to run a query given on Fusion Global HR: Approvals Delegated To Othe…Meet Bhavsar. 160 views 4 comments 2 points Most recent by Ashok Sriniva-Oracle Reporting and Analytics for HCM -
Getting duplicate record in OTBI reportSummary: Content (required): Hi Expert, We have built an OTBI report for talent meetings and when we are running the report there is a record that is coming multiple tim…Faizan Rashid 766 views 3 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
Need a sample SQL Data model using DFF and EFF Flex FieldsSummary Need a sample SQL Data model using DFF and EFF Flex FieldsContent We have several EFF and DFF fields were created in Oracle HCM. Can someone share a sample data …Prabhu Krishnamoorthy 624 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Connect to HCM Database through MiddlewareSummary: Just curious if I can connect to the HCM database through anything other than the cloud url Content (required): Hello, I am creating an integration using middle… -
Annual Leave Buy / Sell - ReportSummary: A Report to identify those Employees who Bought / Sold Annual Leaves Content (required): Hi, Can you please help me to develop a report which will give details … -
Deeplinks in OTBI and BI ReportsContent Is there a way we can use the Deeplinks in the OTBI and BI reports dynamically. Suppose I have a column for 'Person Number' and I click on a particular person nu…Amrit 123 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Is there a way to join these 2 subject areas?Summary: Is there a way to join these 2 subject areas: Human Capital Management – Approval Notification and Archive Real Time & Workforce Management – Person Real Time. …
-
Bursting Report outputSummary: Bursting Email Contains the Sql Query output in the Message Body. How to Remove the Sql Query Output line from the Message Body Content (required): Version (inc…MilanMohanty 82 views 9 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Team Time Card BIP Query for Team information and approval status and Overtime Information.Summary: Need SQL Query for the Manager can view his team information of time and overtime information. Content (required): Version (include the version you are using, i…Ketan Prajapati 377 views 2 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Query to extract employee Salary SourceSystemId and SourceSystemOwnerSummary: Content (required): Hello experts, please could you share the SQL query to extract employee Salary SourceSystemId and SourceSystemOwner? Thanks in advance for y…Valerio Curzi 121 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Unable to create a new Application Page Entry for a BI ReportSummary: Unable to create a new Application Page Entry for a BI Report Content (required): We are trying to create a page entry to open a BI Report. Used the Application…Bhargava Varma G 53 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Table name which stores start date and end date in individual compensation planSummary: Hi Everyone! I am looking for the table name which stores start date and end date in the individual compensation plan. I tried - cmp_plans_vl, cmp_components_vl…
-
Seeing Data Across Different EnvironmentsSummary: Viewing data across different environments inconsistent. Content (required): When I run a report, we created in Dev11, there some data that I don't see in our U… -
How to sort by timestamp in BIP TemplateSummary: Is it possible to sort all the four tiles (Initiated By, Assigned To, Approved By and FYI) by timestamp? Attached is the screenshot (Workflow transaction detail…Angelica Tayactac 3 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
how do I define datesSummary: I am trying to fun an agent weekly and want to have it select a date range Content (required): the job will run every Friday morning and needs to include employ…
-
Any Suggestions of how to improve Web Clock Custom Dashboard data reflection earlier.Summary: We are facing a time-lapse on Custom Dashboard which has reflected the data in delay some time especially in web clock in and out table records. we need a worka…
-
Show timestamp in human readable format while respecting time zoneSummary: Display the date and time from the last_connect column in the fnd_sessions table in a human readable format. The time should also respect British Summer Time / …
-
Need help - Need a payroll report for Element vs BalancesSummary: We need to create a report to include Element names which are feeding a particular Payroll Balance. We tried to do it using Payroll Subject Areas but it did not… -
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 2.7K views 3 comments 1 point Most recent by SachinP21 Reporting and Analytics for HCM -
In BI Report we getting dupilcate records as per ui but we need only one recordSummary: HI Team, We have exist interview survey status report but we getting dupliacte reocrds nearly 700plus. due to report takes as per ui but in ui some of employees…AjayKumar Maddipati 32 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to migrate BPM workflow notification customization to another instance?Summary: How to migrate BPM workflow notification customization to another instance? Content (required): Hi All, I have customized the BPM termination approval email not…Venkatesan 55 views 5 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for HCM
-
Query to extract the last effective start date record for payroll elementSummary: Content (required): Hello experts, Please, could you share the SQL query to extract the effective start date loaded for a specific element in the employee compe…Valerio Curzi 489 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Joining the Time Card Entry view hwm_tm_rpt_entry_v to wftask & wftaskhistory tablesSummary: I have a requirement to display the Rejected by,Rejected Comment & rejected date columns in my Time Card Status report. It is a BIP report. I am trying to join …Dharmendra Jha 329 views 2 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
How to show and hide BIP parameters dynamically based on the login UserSummary: How to show and hide BIP parameters dynamically based on the login User Content (required): We have different parameters and few parameters need to display base…Visu 552 views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
How to take Department head and Business Leader information from AOR?Summary: How to take Department head and Business Leader information from AOR? Content (required): Hi All, From which tables we can get Dept head and Business leader inf…
-
OTBI:I need to pull the carryover limit of persons enrolled in an absence planSummary: I need to pull the carryover limit of persons enrolled in an absence plan Content (required): I need to create a BI Publisher report that pulls the carryover li…Jose Lorenzo Amarado 41 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
How to create an As of Date field into a Dashboard to sort the Effective Employee at a specific dateSummary: Hi Community! Hope to find you well. Our client ask us to add into a Dashboard's Page an As of Date field that can make possible to extract all the effective em…Luca9797 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report not fetching data while using columns from Comp manager / Comp worksheet manager foldersOTBI report built using "Workforce Compensation Budget Real Time Details " subject area is not fetching any results. Hello there, We have a requirement to build a Countr…Gudupu, Jaswanth Sai 295 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can we restrict the creation of OTBI Report only the BI AdministratorSummary: Can we restrict the creation of OTBI Report only the BI Administrator Content (required): Currently any user with BI Author role can able to create the OTBI Rep…Harish Vummidi 82 views 5 comments 1 point Most recent by Harish Vummidi Reporting and Analytics for HCM -
Annualized Salary for terminated employeesSummary: I wanted to create an analysis to get terminated employees annualized salary. Content (required): I used compensation salary history details real time object an…Ayesha Iroshani 44 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM