BI Publisher
Discussion List
-
For Disbursement Positive Pay File Formats Report; below ETEXT format is requirement.Summary: In the Disbursement Positive Pay File Formats Report output file, we want a single payment header 'A' type record and single payment trailer 'Z' record even tho…MANI SATYA SAI CHERUKURI 11 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
Need SQL to extract the amount and periodicity of worker element entriesSummary: Hi Experts, Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement. Written thi…Hiba Ghoualmia 132 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to create report for pending Process Requisitions that not assigned yet to Purchase order.Summary: How to create report for pending Process Requisitions that not assigned yet to Purchase order. Content (required): Version (include the version you are using, i…Mohamed Haamdy 31 views 4 comments 0 points Most recent by Goopikrishnan Jayaraman-Oracle Reporting and Analytics for SCM
-
General Ledger Journal and Subledger Transaction Mapping ReportIt looks like Oracle has provided this report for China localization only, we have a similar requirement for US operations, is it possible to run this report for Non Chi…
-
RTF template doing sorting by name is there any data restrictWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 11 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
How to Retrieve Deleted By and Activated By in HCM Learning Module for Reports?Summary: We have a requirement that needs to display the Deleted By and Activated By fields using a BIP Report / SQL Query. We have tried looking for these in fields HCM…
-
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 63 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 277 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 31 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 23 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 22 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 32 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.5K 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 11 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…