BI Publisher
Discussion List
-
Payment File submission to Natwest Bankline using BI Publisher deemed now as non compliantSummary: Natwest Bankline contacted us late 2023 to state that the OracleCorp XML Publisher software that is used to SFTP the payment file across as being Non-Compliant … -
Is it feasible to customize print pick slip Report by adding new parameter?Summary: We have a requirement to add new parameter in the print pick slip Report. Is it possible to customize the data model and add the below parameter in the Report? …Abhiengine 72 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Need example for Bursting Query in case of Multiple data setsContent Hi, Can anyone explain how to write Bursting query in case of Multiple Data Sets? Thanks in advance. JyotiUser_2025-02-06-14-37-05-233 304 views 11 comments 0 points Most recent by Darshan K N Reporting and Analytics for HCM -
Where can we report on Employee's LDAP Manager?Summary: We need to write a report where we can pull the Employee Manager data stored in LDAP. Content (please ensure you mask any confidential information): We need to …Dianne_W 32 views 2 comments 0 points Most recent by Catalin Constantin-Support-Oracle Reporting and Analytics for HCM -
Report for PC log in vs Mobile log in on browser vs Mobile log in on the appHi there, Is there a report, or which tables could we use to build a report, that identifies whether a user log in to HCM is from a PC or mobile. We found "Device_Type" …
-
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 31 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 11 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 14 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 42 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 270 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…