BI Publisher
Discussion List
-
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every… -
How do we pass multiple input values for a parameter from Payroll flow to a Bi report.Summary: We have a requirement where in we want to pass multiple input values for a parameter from payroll flow to a bi report. How do we achieve it. We have created a B…User_ANH3E 81 views 9 comments 0 points Most recent by Eknath Kayasri Reporting and Analytics for HCM
-
Question Mark is appearing after each row in etext outputContent Hi, Question Mark is appearing after each row in etext output. How to remove? Thanks in advance. Regards, NivyaNivya Mathire 111 views 4 comments 2 points Most recent by Eyan Shahrin Reporting and Analytics for HCM -
BIP Scheduled report with date appended to filename.Summary: Hi, We want the BIP scheduled output Excel file to include the date in its filename. In the extract process, we can use %d%m%y in the output name to automatical…
-
Does anyone know what table does the Absence Management Type time attribute belong to?Summary: We currently have Payroll Time Type and Absence Management Type configured for the Time Entry Layout Components in our system. We already found that the HWM_TM_…
-
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …Saurabh_Mharolkar 48 views 8 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM
-
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example: -
unable to load competencies due to QualifierId2Summary: I've tried to load Talent Profile Competencies multiple times, but no luck. First time around I tried with no QualifierId2/QualifierCode2 column and then second…
-
BIP attachment Query not accepting the parameterSummary: Hi, When I try to use attachment query with dynamic parameter(:P_DID) , i am not getting the UCM outputs. If I hardcode any UCM(DID) from revisions table then I…
-
We Need a table for the Default Values Configure Worksheet Display -Detail TableSummary: Hi We need a table for the below fields under Configure Worksheet Display -Detail Table in workforce compensation plan Content (please ensure you mask any confi…Opkey PA 10 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP Bursting to Email:Output sent as URL:Ability to Change the Position of the URL in the Email BodySummary: BIP Bursting to Email: Output sent as URL: Ability to Change the Position of the URL within the Email Body Content (please ensure you mask any confidential info…
-
Is it possible to display contents of CLOB column in OTBI analysis?Content Is it possible to display contents of CLOB column in OTBI analysis? I am adding a CLOB column to an OTBI analysis but it comes up with blank. When I query the sa…User_2025-02-11-06-57-37-559 156 views 7 comments 0 points Most recent by Alex Cardenas 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…Malak 13 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…JainSamyak 52 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Table for Payroll Transfer Status and Payroll Processing StatusWe need to get Payroll Transfer Status and Payroll Processing Status. Where are these information gets stored? Please share if you have any inputs. We have tried using p…Manoharan 402 views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
What is the functional difference b/w fusion_ora_ess.request_history and fusion.ess_request_historySummary: What is the functional difference between fusion_ora_ess.request_history and fusion.ess_request_history and please explain ErrorType codes present in fusion.ess…
-
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…
-
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont…Bhavna-Civeo 6 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Feedback center manager email and BPM notification content mismatchHad an issue in Notifications content display - We have enabled and customized the template - /Shared Folders/Human Capital Management/Workflow Notifications/NoteSentToM…Challa Ramya-Oracle 5 views 0 comments 0 points Started by Challa Ramya-Oracle Reporting and Analytics for HCM
-
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…
-
Adding additional column to get headcount for each month in OTBISummary: How to add additional column or calculated item to get the head count for every month? Content (required): I am using 'Workforce Trend Real time Subject Area' a…Raghavendra M 320 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…JSAHOO1988 4 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
Unable to send bcc in bursting.In the bursting query i have added parameter 8 for BCC mails. However, 'to' mails are going and the employees are receiving the mails. BCC is not being received. Can any…Reshma Eldho 14 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Tables for Worker Time Processing profiles in HCMSummary Tables for Worker Time Processing profiles in HCMContent Hi Team, I am looking for a query to find Worker time processing profiles(HCM Groups) based on assignmen…Harish Kumar Kovi 289 views 7 comments 1 point Most recent by Anusha Bhat-Oracle 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…Swati U 3.4K views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Multiple pdf outputs to be sent to single emailSummary: Hi We are looking for sending multiple pdf's from a report, to a single email using bursting query or to be zipped and sent to a single email Content (please en…
-
USOnline Payslip Report CustomisationHi Team, We are looking for detailed steps for customising the USOnline Payslip report, with the output format in XML. Report output should be delivered to FTP. Please s…Swapnil Kashid 16 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How can Canadian French characters be displayed correctly when using ANSI encoding?We have a requirement to send a demographic file to a Canadian RRSP vendor using ANSI encoding that supports ASCII characters. However, when we use encodings such as ASC…
-
BI/OTBI Report to identify list of all users who have access to a specific employeeSummary: We have a requirement to fetch all users who have access to view/modify employment data for a given user. We explored options and we can see such information is…