BI Publisher
Discussion List
-
REST API learningContentItems ContentIdSummary REST API learningContentItems ContentIdContent Hi, I want to get a report for the learning item contentid with item title. Because of contentid to use in REST ap… -
Line Manager Hierarchy with Active/Inactive employeesContent I am looking for a BIP report which shows all the active/inactive employees to a Line Manager Hierarchy. When Manager run the report then they can see all the ac…User_2025-02-10-21-21-05-328 205 views 19 comments 0 points Most recent by Revathi Thangaraj Reporting and Analytics for HCM -
Aor QuerySummary: Hi Expert, I have to add an AoR query in my almost five different BI reports. As of now, it shows all data, however, we need to reduce the results based on the …
-
Add New Pay Rate and Old Pay Rate to existing reportSummary: I've been working on making an adjustment to a report (linked below) to add columns for current pay rate and old pay rate. Right now, the sql in the report is r…Henry Imgrund 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Multiple School Districts and Multiple Cities per GeocodeSummary: When trying to build an OTBI Data Model for Tax Withholding, we are finding multiple cities in a Geocode (HZ_GEOGRAPHIES, HZ_GEOGRAPHY_IDENTIFIERS), and multipl…ChicagoConsultant 22 views 2 comments 0 points Most recent by ChicagoConsultant Reporting and Analytics for HCM
-
what is the diffrence between reports and extracts where we can we the extractsSummary: Hi Team, what is the diffrence between reports and extracts where we can we the extracts ? How can we learn, i'm new to extracts. Thanks, Ajay Content (please e…AjayKumar Maddipati 31 views 6 comments 0 points Most recent by VijayKumar R Reporting and Analytics for HCM -
Which tables stores the information for Manage Benefit ProvidersSummary: Which tables stores the information for Manage Benefits Provider Content (please ensure you mask any confidential information): Which tables stores the informat…
-
How to automate the distribution of reports weekly to specific roles within the specific department?We need an automated system to distribute reports on a weekly basis to all users holding the Line Manager role within the Head Office department. How would I do that? Th… -
Need help on Payroll Pension Summary BI reportSummary: These are the columns that I am not able to find the exact table name from Oracle fusion Plan Annual Pension Pension Date Pension Year % Vested Fiscal YTD Conte…Deepak Bhatt 21 views 1 comment 0 points Most recent by Asmita Barman Reporting and Analytics for HCM -
Query to extract employee grade ladder in the assignment pageSummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query to retrieve the employee current grade ladder. Howeve…Valerio Curzi 532 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
HCM Extracts vs BICCWhat tool is recommended to do bulk extract of Oracle fusion data (HCM, ERP and CX)? Couple of advantages I see with BICC is it supports Blob/Clob data with low or no cu…
-
Need help with SQL query for Time and LaborI have a query which times out with a single view, even after creating a report with it and scheduling it. When I raised this with Oracle support, https://us.v-cdn.net/6…
-
Disable and Migrating BI Publisher JobsGood Day, For OTBI Agents, we can set it to disable if we do not want it to run. How about for BI Publisher Jobs? Is there a way to disable it? I cannot find any option …
-
Printing the check number at the bottom of the physical AP Check reportSummary: We have created a custom AP Check RTF template based on the client's requirements. The custom RTF template is used in the Disbursement Payment File Formats repo…shrikardixit 31 views 1 comment 0 points Most recent by Trang Tran UCD Payables, Payments & Cash Management
-
Not able to see parameters in job "Asset Cost and Reserve Report" definitionWhen I am trying to schedule the above job( using a oracle seeded report ), parameters are visible and I can select form LOV. But I am not able to see any parameters def…
-
OTBI agent monitoringSummary: We have scheduled OTBI agents, We cannot able to find a way to monitor the agent status - whether its active? - Whether its still running? - how long its runnin…Prabhu Krishnamoorthy 121 views 7 comments 5 points Most recent by Louis K.Emezina Reporting and Analytics for HCM -
Customer wanted to automate the process to send payslip over personal email for terminated employeesSummary: Hi Team, Would you please help us to get the steps how to achieve the requirement "automate the process to send payslip over personal email for terminated emplo…Rama123-Oracle 103 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Receivable Invoice Report returns nullHi, When I ran the query it returns no rows -
report about changes the employee has madeSummary: Content (required): Good morning, Is it possible to have a report about changes the employee has made to Personal details, Additional personal details, and Bank…
-
Is there any seeded report for Payroll Analytics Initiative?Summary: Is there already Oracle seeded report for this? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Cherry Carpo 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
need a query to fetch negotiation response details with price break informationSummary: Need a sql query to pull negotiation response details with price break information Content (please ensure you mask any confidential information): Version (inclu…SoumyaMukherjee03 428 views 1 comment 0 points Most recent by SoumyaMukherjee03 Reporting and Analytics for SCM
-
How to get asset register report in a single Excel spreadsheet?Summary: Currently assets are reported in Asset Register in separate Excel spreadsheets in one workbook. We have million of assets and this format is not usable for us. …Sohail M.-Oracle 71 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
Auditor is unable to view Preauthorized ExpenseSummary: We currently have two templates set up for expenses for our employees (1) PreApproval expense template — which a V.P. must approve; and (2) Actual Expense Reimb…
-
Is it possible get a output in text format from bip report oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 201 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
SQL query needed to fetch "Calculate Payroll", "Make EFT Payments" process and employee detailsSummary: We want to create a BIP report in Oracle Fusion cloud to get the "Payroll Flow" name for "Calculate Payroll" and "Make EFT Payments" i.e. to get the payroll flo…
-
Record more than 150 Character in DFF fusion CloudSummary Need to store QR code string in DFF which is greater than 150 CharactersContent We are using Oracle Fusion Cloud Update 20D. We need to store QR code string in a…Manish Asawa 976 views 2 comments 2 points Most recent by Timeer Lagade Payables, Payments & Cash Management