BI Publisher
Discussion List
-
oracle.xdo.XDORuntimeException: oracle.xdo12c.xpath.XPathException: Extension function error: ErrorSummary: Hi, am getting below error in BIP level. oracle.xdo.XDORuntimeException: oracle.xdo12c.xpath.XPathException: Extension function error: Error invoking round:java… -
Need SQL query to get the report category details based on the HCM Extract nameSummary: Need SQL query to get the report category details based on the Extract name Content (please ensure you mask any confidential information): We need SQL query to …
-
last update date not getting for Business unitSummary: Hi We have deactivated Business unit. i was looking for last update date in view#fun_all_business_units_v but i am not seeing any change last_update_date. May I…
-
I need a query which will fetch Cycle time in days for the formal performance review processSummary: I need a query which will fetch Cycle time in days for the formal performance review process from start to finish Content (please ensure you mask any confidenti…
-
I need a query to fetch top performing employees in talent managementSummary: I need a query to fetch top performing employees in talent management Content (please ensure you mask any confidential information): Version (include the versio…
-
Quick action menu created for BIP is not visible after 25DSummary: I have created Quick Action Menu item for BIP report course completion certificate. after 25D, its not appearing , when I checked in Sandbox , it shows message …Raghavendra M 6 views 1 comment 0 points Most recent by Yashaswi Sanjeev Kulkarni Reporting and Analytics for HCM -
How to pull Survey results from a Journey in OTBISummary: Cannot seem to pull any results in OTBI using 'Workforce Management - Survey Journey Responses Real Time. Specifically need to easily and cleanly see Questionna…CHolden 271 views 8 comments 1 point Most recent by Florencia Maletto Reporting and Analytics for HCM
-
Workforce Profiles - Person Profile Real TimeSummary: Hi Expert, I need your assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person'…
-
I need a query which will fetch Percentage of employees with succession plansSummary: I need a query which will fetch Percentage of employees with succession plans in fusion hcm talent management Content (please ensure you mask any confidential i…Pritha 7 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Career and Succession
-
HCM Audit Table Differences - Do the audit tables keep deleted rows and the regular table does not?I want to understand the difference of contents between a "regular" table and an "audit table" that has an "_" underscore at the end of the name. I am calling PER_ALL_AS…
-
Unable to see data in "VOIDED_BY" and "VOIDED_DATETIME" in ANC_PER_ACRL_ENTRY_DTLS tableSummary: Unable to see data in "VOIDED_BY" and "VOIDED_DATETIME" in ANC_PER_ACRL_ENTRY_DTLS table Content (please ensure you mask any confidential information): We are a…
-
Extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tablesSummary: We have a requirement to extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables since go live. We tried to build a BIP Report and running them …Phaneendra Vallapu 74 views 5 comments 0 points Most recent by Santhanakrishnan Muthukrishnan Reporting and Analytics for HCM
-
Changing Date format to 'DD/MON/YYYY' in SQL for BIP reportHi, Can you please suggest how to change the Date format to 'DD/MON/YYYY' in the SQL for BIP Reports. Thanks in advance. -
Work Email is visible but Personal Email is blank for specific usersHi, We are experiencing an issue in Oracle HCM where a report that includes both Work Email and Personal Email behaves differently depending on the user running it. When…
-
Help with Extracting L1/L2/L3 Managers in ReportsHi, We’re working on extracting L1/L2/L3 manager hierarchy using the standard logic (e.g., PER_MANAGER_HRCHY_DN). In most cases, the extraction works fine — but in speci…
-
How to identify the tables updated by transaction in Fusion HCM?Summary: Hi Team, Is there a way we can identify the backend tables affected by a transaction done in application. For example Hiring an employee, in this case how to id…
-
Required table for Quick move action for Candidate Selection Process Configuration in ORCSummary: Required a table or SQL query where the information of Quick move action stored for the HCM-ORC setup Candidate Selection Process Configuration. Attached screen…
-
Email Bursting Fails in Oracle Fusion UAT Instance – Missing SMTP ConfigurationHello Everyone, We are currently performing UAT testing for our Oracle Fusion HCM BI Publisher bursting reports, which send email notifications to users. The same report…
-
User Adoption ReportHi, Has anyone implemented "User Adoption Report" in Oracle Fusion using Doc ID "Security Reports in Fusion Application (Doc ID 2210883.1)". After enabling the profile, …pradeep chandrasekaran 21 views 1 comment 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
How to Associate RTF template with Data Model and configure E-Signature Validation.Summary: Hello All, Need support on below requirement. Kindly share if you have any reference. I am trying to the Fleet Safety acknowledgment document with an electronic…RamkumarKadhiravan 12 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
ytd payroll balance values using pay_run_balancesSummary: How to fetch the Ytd balance value of the Gross Pay,Net and Employee tax deductions using pay_run_balances table Content (please ensure you mask any confidentia…susmita 883 views 2 comments 0 points Most recent by Bhagya Kalla Payroll and Global Payroll Interface (GPI)
-
We Need a table for the Configure Worksheet Display -Detail Table in Workforce compensation planSummary: Hi, We Need a table for the below highlighted fields under the Configure Worksheet Display -Detail Table in Workforce compensation plan Content (please ensure y…
-
Bursting files by department code in .csv formatSummary: Bursting files by department code in .csv format is running into error. Content (required): I'm using this query to burst files by Bursting Key = department cod…Aloka Bhattacharya 721 views 8 comments 0 points Most recent by Hemanth Kumar Reddy Reporting and Analytics for HCM -
write a sql query to fetch average cycle time for each compensation planSummary: write a sql query to fetch average cycle time for each compensation plan Content (please ensure you mask any confidential information): write a sql query to fet…Pritha 5 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
write a sql query to fetch average percentage of budget utilizationSummary: write a sql query to fetch average percentage of budget utilization Content (please ensure you mask any confidential information): write a sql query to fetch av…Pritha 7 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Sql query to find the pending document of record detailsSummary: I am looking for query to find the pending document of record details. I can see the approved once in table hr_documents_of_record. Content (please ensure you m…Rahul K-Oracle 466 views 2 comments 0 points Most recent by Domenico P. Reporting and Analytics for HCM
-
BI Catalog change audit dataSummary: Is there a way to audit the changes done on BI catalogs in Oracle Fusion Cloud? Content (please ensure you mask any confidential information): Version (include …AnuradhaMupdathi 7 views 1 comment 1 point Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an…
-
Need to skip HTML tags while displaying in the outputContent Hi All, We are facing an issue in Performance Management in Fusion Cloud. In the back end database table in one of the column (HRA_EVAL_RATINGS -- COMMENTS) whic…
-
How can I ensure my BIP report for line managers only returns results of their reporting line?Summary: I've built a BIP report and made it available to managers as a link (static URL page entry in My Team) and it works perfectly except it returns results for all …