BI Publisher
Discussion List
-
How to Output a Table Entered in HTML Format in a Document Using BIPSummary: I am creating a document using BIP. I want to output table data entered in HTML format. I would like to confirm the following two points: What kind of SQL state… -
Need a report which can provide details if any scheduled job runs and BI report run got missed.Hi Team, We have a requirement in place that if any report schedule and job schedule got skipped due to any reason then we need a BI or OTBI report by which we can track…Sanchit_Jauhari_2211 29 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to customize seeded Payment Register ReportSummary: How to customize seeded Payment Register Report Content (please ensure you mask any confidential information): Hi All, We got a requirement to add new columns i…Venkatesan 99 views 6 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Query to get Statement of Earnings (Payroll -> Person Results -> Calculate Payroll)Team, It would be helpful if you can guide me on how to fetch Earnings Value. (Highlighted one).Manoharan 91 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo…Parag Hiremath 479 views 10 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How to join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES)Summary: If we have a person with 2 timesheet rows on the same day, each representing half day of absence, and we have 2 absence rows each of a different absence type - …
-
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…Monica Fundak 42 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
how to get the organization and customer hierarchy data from tables in oracle fusion planningSummary: Hi Team, What all are the table to extract the organization and customer hierarchy data from tables/BI report in oracle supply chain planning cloud? Content (pl…Nitin Aavasarmol 182 views 1 comment 0 points Most recent by gclampitt Supply Chain Planning and Collaboration
-
disable_date not populated in HR_ALL_ORGANIZATION_UNITS_X after inventory org is disabledHi Team, We have disabled the inventory org and we are checking below condition but org.disable_date is not populated. Can you please help how we can populate org.disabl…vikram khengare 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …Sharmava 23 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Supplier Management
-
BI Reports are failing with error as Could not connect to OBI Presentation ServiceSummary: BI Reports are failing with error as Could not connect to OBI Presentation Service Content (please ensure you mask any confidential information): Hi Team, Greet…Parag Hiremath 45 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How can we create a distribution list in Oracle fusion Bi publisher?I need to share a custom report with multiple users through the following steps: Schedule → Output → Destination Does anyone have any idea about configuring a distributi…
-
How to display Active employees count month wiseSummary How to display Active employees count month wiseContent Is there any way on calculating employee count by month in OAC. The starting point is an Employees table …Saptadip 387 views 6 comments 1 point Most recent by Lakshmi Devi Bathala Reporting and Analytics for HCM
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin…Nivya Mathire 95 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
HDL - DeleteSummary We are trying to remove Matrix Managers via HDL; but DELETE removes all historyContent Hello! We are implementing Matrix Managers and I've been tasked with updat…User_2025-01-23-21-24-21-434 113 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Convert numbers to Arabic in wordsContent Hi, We have a requirement to convert salary numbers to Arabic. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, Nivya Version …Nivya Mathire 794 views 12 comments 1 point Most recent by User_FVSCP Reporting and Analytics for HCM
-
unable to load competencies due to QualifierId2Summary: I've tried to load Talent Profile Competencies multiple times, but no luck. First time around I tried with no QualifierId2/QualifierCode2 column and then second…User_H77SF 1 view 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Data Loader (HDL)
-
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…MadhuLekkala 59 views 2 comments 0 points Most recent by MadhuLekkala Reporting and Analytics for HCM
-
I need to retrieve a list of all data roles and job roles associated with a given privilege.When querying by privilege name, I want to capture all the corresponding data roles and job roles linked to it. I attempted using the tables ASE_PRIVILEGE_VL and ASE_PRI… -
Some Employee missing of the Reports on certain dateSummary: I want to explain the issue we encountered. On December 10, the HR team uploaded a change affecting all employees in a specific department, effective December 1…Lucas B Maciel 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Query Regarding Adding a Secured List Table to Oracle BI Data ModelSummary: Query Regarding Adding a Secured List Table to Oracle BI Data Model Content (please ensure you mask any confidential information): Hello, I am working on a BI d…
-
Is it possible to find deleted checklist details?Summary: Is it possible to find deleted checklist details? Content (required): Hi All, For one employee, one check list has been assigned and deleted by someone. I verif…
-
Actual Termination Key Date?Client is saying The ActualTerminationKeyedDate is a column in the "per_periods_of_service" table. We don’t see from our side the termination_key_date from "per_periods_…Ronel M 3 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Subject Area for Personal Payment Method DetailsSummary Subject Area for Personal Payment Method DetailsContent Hi All, Can any one please help me to find OTBI Subject area for personal payment method details. I have …nitin Sharma 203 views 13 comments 1 point Most recent by GopiKAutomus Reporting and Analytics for HCM
-
BIP Query to get only base elementsSummary BIP Query to get only base elementsContent While creating elements, there will be shadow elements that will get created automatically. Is there anyway to get onl…Sowdha Murugan 505 views 4 comments 0 points Most recent by Rakesh Kanukanti Reporting and Analytics for HCM -
how long data can store fa_fusion_soainfra.wftask this tableSummary: Need information about this table how long data will be store Content (please ensure you mask any confidential information): Version (include the version you ar…Nagendra Chitra-Oracle 45 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
HCM Workflow ReportSummary All HCM transactions current status of the workflow and approval detailsContent Hi, I'm trying to create a report to display all HCM transactions Current status … -
Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time"Summary: Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time" subject area Content (please ensure you mask any confidential …
-
Is there a way we can use embedded reports for custom error messagesWe have a requirement to have an error message to validate entries in a standard field in Learning module. As far as we have checked, there are no autocomplete rules ava…
-
Passing the parameter at run time from the URLI am creating a BIP report and want to pass parameters from the URL. For example, I have a report with a parameter for Assignment ID. When I open the report, it should l…