BI Publisher
Discussion List
-
Report to reflect latest asset locationSummary: Report pulling through a line per location, even if it was updated Content (please ensure you mask any confidential information): We currently have an OTBI repo… -
Reporting on a Managers Direct Reporting LineHiya, I went on a workshop recently in Reading and Julian kindly told me how I should be able to report on direct employees under a manager instead of direct and indirec…MikeW 337 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Payables Matching Detail report blankSummary: Hi Gurus, Payable Matching Detail report is not returning any data inspite of nominating BU & PO# parameter. I do have 'Accounts Payables Manager' role assigned…Amrish_Amradkar 12 views 3 comments 0 points Most recent by Amrish_Amradkar Payables, Payments & Cash Management
-
Can a Vanity URL be setup for the OTBI or BIP ReportsSummary: One of the requirements is to have a Vanity URL setup for accessing the OTBI/BIP reports from external source. Content (please ensure you mask any confidential …SSN-Oracle 42 views 9 comments 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales
-
How to Specify Multiple People in Cc While Bursting in Custom BI AlertsSummary: Content (required): There is a requirement of having multiple people in Cc while bursting. How to configure PARAMETER 2 for multiple recipients? Version (includ…Shashank Singh 1.1K views 3 comments 0 points Most recent by jahanavi metta Reporting and Analytics for HCM
-
Customization of AR Invoices XML Outbound message not working when launching job for several invoiceSummary: Customization of AR Invoices XML Outbound message not working when launching job for several invoices Content (required): We are using UBL2.1 PEPPOL standard me…
-
Way to fetch Value By Criteria Definitions in custom payroll fast formulaSummary: Way to fetch Value By Criteria Definitions in custom payroll fast formula select * from PAY_VBC_VALUE_IDENTS? I'm not seeing my records in HCM BI query Thank yo…jtwhit_hcm 71 views 0 comments 0 points Most recent by jtwhit_hcm Payroll and Global Payroll Interface (GPI)
-
Need Standard Report or Table details for AP approver and each approver limit detailsSummary: Need Standard Report or Table details for AP approver and each approver limit details Content (please ensure you mask any confidential information): Hi, We want…CHIR 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
XML file Required for Positive Pay etext template customizationSummary XML file Required for Positive Pay etext template customizationContent please let me know how to fetch the positive pay xml file required for etext template Vers…Smandanak 787 views 9 comments 1 point Most recent by ShrutiSood Payables, Payments & Cash Management
-
How to pass current ESS Process ID as a Parameter in custom BIP reportSummary: How to pass current ESS Process ID as a Parameter in custom BIP report Content (please ensure you mask any confidential information): Hi Everyone, We have a cus…Gurujothi D 526 views 4 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Vinay Prasad 31 views 3 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Assignment Status in BI ReportSummary Assignment Status in BI ReportContent Hi, I want to find out table field in BI Report which hold value Assignment Status = "Active Payroll Eligible" or "Inactive…User_2025-02-07-19-03-14-525 245 views 12 comments 1 point Most recent by Aurobindo Ghosh Reporting and Analytics for HCM -
Custom Font on OTBI Dashboard?Is it possible to use a custom font with OTBI Dashboards/Analyses? We would like to develop a "theme" for our Dashboards and use our company's font. The only information…
-
Payroll Flow Pattern ReportSummary: Payroll Flow Pattern Report Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to find out the programs which are…Parag Hiremath 51 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Calculated Eligibility fieldSummary: Hello, We're trying to extract the Calculated Eligibilty column in SQL, as we need to know the value if it's Forced Eligible or Eligible. However, we cannot fin…
-
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 12 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 142 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 71 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 295 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 33 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" …