BI Publisher
Discussion List
-
Week Number calculation for OTL Overtime report if week starts from saturday and end on fridaySummary: Hi Team, We need to calculate the weeknumber for a overtime card report. Week will start from saturday and end on friday We need to pass "from week" and "to wee… -
which table has the information of Legislative Categories for Manage legala AuthoritiesSummary: Hi Team, We need a table where the information of Legislative Categories stored for Manage legala Authorities. We have the table HZ_PARTIES to get Legal authori…Opkey PA 12 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
Base table - Email Notifications Workflow approvalsContent Hi, I am looking for a table that holds emails sent out of the workflow mailer. I am specifically looking for details such as Transaction/Task id along with an e…Sriharsha Devraj 613 views 2 comments 0 points Most recent by User_AOTJG Reporting and Analytics for HCM -
Job Requisition Audit report neededHi Team, We have a requirement to create a report to bring Requisition Audit report, The client is trying to fetch each transaction that occurs with a requisition , any …Sushant95-Oracle 6 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP HCM Payroll - Is there any alternative to pull the Payroll process statusBIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query /* ( SELECT meaning FROM hcm_lookups WHERE lookup_type = 'ORA_HWM_PA…BhaskarDondapati 271 views 10 comments 0 points Most recent by Sunil Makam Reporting and Analytics for HCM
-
Processing Bar Not Visible During Report Generation – Needs Left Alignment or Fixed PositionSummary: When running a wide report, the Processing bar appears centered on the report, making it not visible unless the user scrolls horizontally. This causes confusion…
-
Oracle Fusion BI Publisher - Excel Template - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …
-
Getting error after scheduling BI Report with Bursting definitionSummary: I have resignation report based on transaction console. I'm scheduling the report with Bursting definition and i'm getting below error. Job processor caused exc…KeerthanaBaskaran 447 views 4 comments 0 points Most recent by User_ICD6K Reporting and Analytics for HCM
-
Public Key for sharing with ADP Global View - same key across all environments?Summary: Can we generate the SAME set of public encryption keys across ALL our non-PROD environments? Content (please ensure you mask any confidential information): In t… -
HCM Alert Employment DFFHi Gurus, We have a termination Alert Configured using HCM Alerts where we send notification to all HRBPs for employee who got terminated one day prior. The alert is wor…Debasish Saha 21 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM
-
Is it possible to embed OTBI report and BIP report in one dashboard?Summary: Hello, I would like to confirm if it is possible to embed OTBI report and BIP report in one dashboard wherein both reports share with the same dashboard prompt?…Hazel De Castro 702 views 24 comments 0 points Most recent by Yves Chassein Reporting and Analytics for HCM
-
Why IRC_HTTP_REQUESTS is having blank when there is a data in Recruiting Messaging ConfigurationSummary: Hi Team, The SMS communication information is stored in IRC_COMM_ACCOUNTS but We are not getting anything in these tables IRC_HTTP_REQUESTS, IRC_HTTP_BODY_TOKEN…
-
BI Publisher – Is it Possible to Reposition the 'Processing' Notification for Wide Reports?Summary: In BI Publisher, when running a report that is horizontally wide, the "Processing" notification only appears near the center of the report layout. This requires…
-
Returing null while executing fnd_global.get_session_attribute('JOB_REQUEST_ID')Summary: select fnd_global.get_session_attribute('JOB_REQUEST_ID') from dual is returning null. Can you please how we can get the current job request idTejas Deshpande 12 views 2 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo…
-
How to connect to Oracle HCM Cloud to Power BI using CDataSummary: We are trying to connect to Oracle HCM Cloud to Power BI using CData ( https://www.cdata.com/drivers/oraclehcm/powerbi/ ) So, our PowerBI developers can utilize…
-
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…Sanduni Pathirathne 22 views 3 comments 6 points Most recent by Harikaran Ravikumar Reporting and Analytics for HCM
-
UI End-Date and Database Records for Bank AccountsSummary: Hi everyone, I recently inactivated a bank account using the checkbox, and now I see a mismatch with the end date. The UI shows it as 01/07/2025, but the tables…
-
How to attach custom layout in BPM Task for Workflow Notification for Document of RecordsSummary: We have created a Document of Record to submit Time Anomalies. When user submits Time anomaly request, it goes to the line manager. User is submitting the time …Priya J N Singh 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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…
-
How to get list of tables that stored a data in oracle fusion hcmSummary: I am looking for list of table name that stored a data in oracle fusion hcm. Content (please ensure you mask any confidential information): Version (include the…Anup Karmankar 25 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Required Table or SQL query to get Phase details for the ORC moduleSummary: Hi, Required Table or SQL query to get Phase details uder the task: Candidate Selection Process Configuration for the ORC module Content (please ensure you mask…
-
Group similar columns together in bip report either through report editor or rtf templateSummary: We have a requirement to build a performance report in BIP to bring all the similar worker and manager comments in single row instead of the rows being repeated…
-
Need SQL to extract Individual Compensation entries prior to approvalSummary: Need SQL to extract Individual Compensation entry values prior to Approval Content (please ensure you mask any confidential information): We need to report on I…SRIROU 80 views 5 comments 0 points Most recent by Prasad Singamaneni-Oracle Reporting and Analytics for HCM
-
Table names/SQL query for Individual Compensation details in HCMSummary: Hi All, Can you please share me the Table names/SQL query for Individual Compensation details in HCM. Thanks, Janardhana Content (required): Version (include th…Janardhana K 5.1K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…
-
Getting insufficent privledges error when executing SQL in Data ModelWe are trying to create a report that shows bursting queries scheduled in our system. The code was found here: Document 2210437.1 The SQL code we are trying to execute i…Christopher Hitchcock 22 views 4 comments 0 points Most recent by Christopher Hitchcock Reporting and Analytics for HCM
-
OTBI Report: Accrual Balance Based on Effective DateHello Experts, We have a requirement to extract accrual balance details using an OTBI report based on an effective date parameter. This effective date should be compared…Vasanthakumar Ravi 60 views 4 comments 1 point Most recent by Swapna Govind Reporting and Analytics for HCM -
In RTF Tag is not getting into BoldSummary: We are printing CTC - Salary amount in Offer letter all the amounts (Please refer to the table image from attachment) we need to make the Total Cost to company …