BI Publisher
Discussion List
-
Need to add column in FAH application line level with 250+ characters and get to GL line level dffSummary: Need to have a character lengeth 250+ column in FAH application line level and flow to GL line level Content (please ensure you mask any confidential informatio…Dian Minshan 1 view 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub -
How to see from front end or fetch data through query for schedule information of hcm extractSummary: How can we see from front end or fetch data through query for schedule information of hcm extract like the schedule date, frequency etc. -
Is it possible to report on what learning content is attached to learning courses?Summary: My organization needs to audit the learning content (videos, PDFs, etc.) associated with our courses and offerings. I am exploring the Workforce Learning Conten…
-
New/Pending approval/requires approval goals in the tableContent Hi Team, We were able to get the details of the new/pending approval/requires approval from the table HRG_GOALS . In 20B we are not able to find the same. Is the…Nivya Mathire 143 views 8 comments 0 points Most recent by HasnatHRT Reporting and Analytics for HCM -
How To Join XLA_AE_HEADERS and RCV_TRANSACTIONS in Fusion/ERP Cloud?Summary How To Join XLA_AE_HEADERS and RCV_TRANSACTIONS in Fusion/ERP Cloud?Content How To Join XLA_AE_HEADERS and RCV_TRANSACTIONS in fusion? I could link XLA_TRANSACTI…User_B9AX9 856 views 4 comments 0 points Most recent by Varun Dhondea Reporting and Analytics for ERP
-
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 21 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 33 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 531 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 101 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 421 views 1 comment 0 points Most recent by SoumyaMukherjee03 Reporting and Analytics for SCM