BI Publisher
Discussion List
-
Table name to query the Delegation Approval rule and categorySummary Table name to query the Delegation Approval rule and categoryContent I have a requirement to create a report for Delegation Approval Rule and category informatio…Sricharan Monigari 483 views 5 comments 0 points Most recent by Visu Reporting and Analytics for HCM -
Transaction (requisition and/or expense report) - approvers and actionsSummary Provide end-users with a report (or reports) that identifies approval status (and history) on requisitions and/or expense reports).Content Boise State has a requ…User_2025-01-28-03-18-28-504 80 views 8 comments 0 points Most recent by Mihaela Vlad Reporting and Analytics for ERP -
OTBI Filter CriteriaSummary: Need help to add a filter criteria in OTBI analysis. I am using the below filter criteria which is working in payroll subject area: "Balance Types"."Balance Nam…Mohan Murali 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Organization Audit ReportSummary BIP Audit Query to tract the mutations happened with respect to Departments.Content Hi All, We have a BIP requirement to tract down the mutations that are happen…User_2025-02-10-16-28-01-402 47 views 4 comments 1 point Most recent by Karen Long Reporting and Analytics for HCM
-
SQL to return all job roles where a particular duty role is usedSummary: SQL to return all job roles where a particular duty role is used Content (required): Hi Team, Please share SQL to return all job roles where a particular duty r… -
DFF value is not coming in the OTBI reportSummary: Content (required): Hi Expert, We have created a DFF in the document of record and when we are using the OTBI report to fetch the data for this specific dff the…Faizan Rashid 526 views 2 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
SQL-Applied ReceiptsSummary: Please share with me any SQL-Applied Receipts Content (required): Hello I was trying to do an SQL for applied receipts , however I always get duplicate records …martingabriel Kinovisques 81 views 1 comment 0 points Most recent by Dhruvjoshi23 Receivables & Collections
-
HCM reporting on hours and average hours workedSummary HCM reporting on hours and average hours workedContent Hello Does anyone have any ideas about tracking average hours worked for hourly associates, as it relates … -
Adding data element to a data model (Adding Full_Name to EEO-1 report)Summary: Assistance requested in adding Full_Name to a data model Content (required): We have some EEO-1 reports that were built by someone else prior to my arrival. One…
-
OTBI Report for a list of OTBI ReportsContent I'm looking for a way to report on our current OTBI reports in their respective folders. I'm not sure if BI Publisher is the only route, but I couldn't find any …
-
Not getting any data when opening the reportSummary: Content (required): Hi Expert, We have built a report and it is an Individual Compensation report, I have all the roles but when I am assigning payroll admin an…Faizan Rashid 42 views 11 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM
-
How to set default CONTEXT Value while updating descriptiveSummary How to set default CONTEXT Value while updating descriptiveContent How to set default CONTEXT Value while updating descriptive when I update descriptive informat…
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 21 views 1 comment 0 points Most recent by Kelly Cooper-Oracle Reporting and Analytics for SCM
-
Need inputs to get the Target Element Name under Status Processing RulesSummary: Need inputs to get the Target Element Name under Status Processing Rules in Element UI Content (required): We can have a link between Pay_Element_types_vl and P…
-
RTF TemplatesSummary: Hi, Can anyone please provide documents or sample RTF templates for learning or exploring purpose. Thanks. Content (required): Version (include the version you …Padamatinti Varsha 91 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Payables Invoice Notification: 'View Approval' sectionContent Hi, Since 20C release, the Payables Invoice Notifications are changed. You have the option to opt in to get a configurable approval notification (e-mail) as well…
-
Termination Report needed (workflow initiated date vs the actual termination date)Summary: We are in need of a report which will help us catch "late terminations". Report should have a date in which the workflow was initiated, and then the termination…
-
when i am using Calculated due date in the where condition Query is taking lot of timeSummary: when i am using Calculated due date in the where condition Query is taking lot of time (TO_CHAR(NVL(warf.CALCULATED_DUE_DATE,warf.EFFECTIVE_START_DATE),'RRRR/MM…
-
Denied the delete option from everywhere.Summary: Hi Team, I have created a custom role, and I want to denied the delete option from which function need to denied for my custom role and only the "BI Author Role…User_2025-02-12-18-16-01-181 41 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Manage Report Jobs screen shows owner as fusion_apps_prov_patch_appidSummary: Manage Report Jobs screen shows owner as fusion_apps_prov_patch_appid Content (required): Hi, The Manage Report Job screen shows the Owner as "fusion_apps_prov_…Christopher Jothi - HCM-Oracle 101 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Restructuring Oraganization - Restructuring HierarchiesSummary: We are restructuring the organization. Currently, we have the cost centre hierarchy based on business areas which would be demised going forward. New business a…Tousif A 51 views 3 comments 0 points Most recent by User_2025-02-10-18-44-43-184 General Ledger & Intercompany
-
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! Upda…