BI Publisher
Discussion List
-
Table name for pending workerSummary Table name where pending worker details are storedContent Hi Oracle experts, I have created a Pending worker from Taleo to Fusion using the delivered integration… -
Need a query that combines both termination transaction details with the employee details.Hi I need to create a custom query that combines both the transaction console details for terminations with the employee details (i.e. job name, department and pay) for … -
Timecard Layout ReportTeam, We have a requirement to build many timecard reports and would like to understand the table structure to develop the same. We are using hwm_tm_rpt_entry_v view to …
-
Positions report with no open requisitions or current incumbentsHello, Currently we are looking for a report regarding Position details where there is no Open requisition linked or no current incumbents mapped. Many thanks,Bala Krishna B 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 32 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
How to confirm the normal transmission of the bursting.Summary: How to check if a bursting has been successfully sent. Content (please ensure you mask any confidential information): Nice to meet you. My name is Keishi. Now I…
-
SQL query for linking between life event and benefits plansSummary: Need sql query or back end table for the linking of add life event(BEN_LER_F) and benefits plans(BEN_PL_F) Content (please ensure you mask any confidential info…
-
Number of active/Inactive users in Oracle HCMSummary: Hi All, Do we have any standard report to see the number of active/inactive users in the system? If someone has this report please share. Thank you.Saher 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Behavior in PO_HEADERS_ARCHIVE_ALL recordsSummary: Behavior in PO_HEADERS_ARCHIVE_ALL records Content (please ensure you mask any confidential information): I am looking for an explanation of PO_HEADERS_ARCHIVE_…KDR 31 views 8 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Documentation for SFTP protocolSummary: Documentation for SFTP protocol Content (please ensure you mask any confidential information): I'm looking for a document that explains how to export a file in … -
Need query to get Job details oracle fusionHi Team, Please correct me if i am wrong, once we have submitted Job from schedule jobs then we can see the data in the below tables fusion.ess_request_history fusion.es…VENU GOPAL REDDY ADINA-Oracle 1.6K views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle Reporting and Analytics for ERP
-
Query to retrieve the employee seniority dateSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve Seniority Date for employee person number 1775. In case of Rehir…Valerio Curzi 21 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
state unemployment wages by jurisdiction reportSummary: I am trying to create a report that shows state unemployment wages by state jurisdictions. I created one in OTBI using the Payroll - Payroll balances real time …JDCal 13 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
not able to fetch latest date even after using MAX functionHi team i am trying to fetch latest last update date record in below query but unable to do it.i am looking for 2022 as a latest date record but when i use max function …Chetana Pawar 12 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
BIP Letter Templates and ImagesHi all, I've created a simple data model that allows an end user to run a self service report where they input the employee number and it generates a semi complete lette…
-
How do i access "Procurement Audit Details Report" in Oracle Fusion?Summary: How do i access "Procurement Audit Details Report" in Oracle Fusion? Content (required): How do i access "Procurement Audit Details Report" in Oracle Fusion? Is…AkashAgarwal 41 views 2 comments 1 point Most recent by SrikrishnaKarnatapu Payables, Payments & Cash Management
-
Where can I find Talent Review Columns of Task Subject, Task Status, Task Owner and Task Due Date?Summary: In what table can I find Talent Review Columns of Task Subject, Task Status, Task Owner, and Task Due Date? Content (required): Here is a brief description of t…Basti 11 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Looking for Department column which contain value of PSSR Requisition DFFSummary: I am looking for Department column which is populated with new value using DFF. Please find attached doc for reference. Content (please ensure you mask any conf…Pooja_123 21 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
How to include attachments from the main transaction page into a custom reportHello team, greetings for the day!! I was asked to develop 'AR Payment Plan' bursting report which triggers an email consists of 3 PDF pages. out of those pages one is t…Gurupreet S 21 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Payment Status: Pending action to address payment validation errors.Summary Payment Status: Pending action to address payment validation errors.Content Hi All, Payment Status: Pending action to address payment validation errors. Thanks, …Devendra Thota 273 views 2 comments 3 points Most recent by Senthil Mohanraj Payables, Payments & Cash Management
-
Query that fetch Grade Rate Value for a certain personSummary: Hello! I need help to get a query that passing the assignment_number of an employee I can get the value field of a Rate Value inside the Grade of a person. Exam…Matheus Roberto 131 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
SQL Query Timeout is greyed outSummary: SQL Query Timeout is greyed out. I have logged into xmlpserver but is still unable to change the SQL Query Timeout. Is this field no longer updatable? Content (…Consultant Ian 111 views 8 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Restricting BI Publisher folder not workingSummary: We are trying to restrict folders in BIPublisher using the roles. However it seems , this is not working. like Folder /shared/Custom/Human Capital Management/Be…
-
Compensation Zones and Grade Differentials of an employee in BISummary: How can I get the Compensation Zone and Grade Differential an employee is assigned to? I saw from previous posts that the details are in the CMP_ADDRESS_ZONES t…Tom John Bontoyan 43 views 5 comments 0 points Most recent by Rajesh Jupudi -Oracle Reporting and Analytics for HCM
-
is there any rest api to get all rejected ap invoices?Summar Summary: Is there a REST API available for fetching all rejected AP invoices? If yes, how can it be utilized? Content: [Please provide any relevant information] V…Nikhil Pande 11 views 1 comment 0 points Most recent by Purvi -Oracle Payables, Payments & Cash Management
-
Reports in Case ManagementSummary: Case Management has been introduced as part of Next Gen Help Desk. Could anyone please share your inputs if there are any subject areas available to build repor…
-
Hide Diagram tab in Data Model for the BIP report for users with particular fusion HCM roleSummary: Hide 'Diagram' tab in the Data model for users with particular fusion HCM role Content (please ensure you mask any confidential information): There is a require…Girish_Kulkarni_123 11 views 2 comments 0 points Most recent by Girish_Kulkarni_123 Reporting and Analytics for HCM
-
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal…
-
Modified payslip Data model bursting is not workingSummary: We are trying to achieve the requirement to send payslip for ex-employees over personal email address, Below is the custom bursting data model that we modified.…Rama123-Oracle 11 views 1 comment 0 points Most recent by Faithe Chu-Oracle Reporting and Analytics for HCM