BI Publisher
Discussion List
-
Seeking Performance Management tables for specific data fieldsSummary Seeking Performance Management tables for specific data fieldsContent Hi. My team is building a Performance Management BIP report and is seeking to include the f… -
Query taking more time to split,compare using regexp_substr() functionSummary Query taking more time to split,compare using regexp_substr() functionContent Hi , i have a report to get goal approvers names w.r.t. goal if pending with approv… -
Base table for Compensation Component ColumnsSummary Not able to find the base table which holds data for Compensation component columnsContent I am writing a BI Publisher report to fetch Compensation worksheet dat…Mohammed Shameem-Oracle 116 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Show blob image in OTBI report.Summary Blob image in OTBI report.Content Hi I have a requirement in which I must show an image in a report found in the per_images table. When I am building my .rtf fil…Cesar Tepetla Corte 84 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
InfoletSummary The duplicate column is appering once click on the one of the column in the Trigger Report ( Expanded View)Content Hi All, I am facing the below issue can any on…Swaroopa Chenagarapu-130214 58 views 7 comments 1 point Most recent by Thiru Ch Reporting and Analytics for HCM -
Custom Report Running Error After Release 18CSummary Custom Report Running Error After Release 18CContent Hi Team, After Release 18C custom report we created is giving below Error. oracle.xdo.servlet.data.DataExcep…User_2025-01-31-20-01-00-954 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Print Dashboard vs Print AnalysesContent Hi all - I have seen a few posts about this but have not seen a solution and am hoping you can assist. Our users access reporting by signing into Fusion and then… -
"Approval Delegate to others" table nameSummary "Approval Delegate to others" table nameContent Hi All, i have an requirement to get report of all the "Approval delegate to others" in oracle fusion .i am unabl…nitin Sharma 69 views 2 comments 0 points Most recent by nitin Sharma Reporting and Analytics for HCM
-
Report for fields using in systemSummary Report for fields using in systemContent Hi Everyone , Do we have any standard report or SQL query ,which will identify all the fields in table which is linked w…nitin Sharma 41 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to display current year as default value of a date parameter in BI publisher data modelSummary Need to display current year as default value of a date parameter in BI publisher data modelContent Hi, We need to display current year as default value of a dat…User_MC37Q 846 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
BIP report generating JAVA exception "java.lang.NullPointerException"Summary BIP report running into errorContent I am trying to run a BIP report but its generating an error.On running the data model for over 200 rows it generates the fol…User_2025-01-31-02-27-22-166 87 views 1 comment 0 points Most recent by Thiru Ch Reporting and Analytics for HCM
-
BI Publisher and Person FTESummary Having issues with FTE in work measures and UNITContent Hi All, I am writing a report and i need to bring back person FTE so i am bring back value and unit from …User_2025-01-29-21-02-12-466 88 views 4 comments 0 points Most recent by Rob F Reporting and Analytics for HCM
-
Unable to query data in PER_ACCRUAL_PLANS_B and PER_ACCRUAL_PLANS_TL tablesContent Hi All, We entered Accrual data in the application. When we tries to query in BIP side we are not getting data from the tables (PER_ACCRUAL_PLANS_B and PER_ACCRU…Visu 32 views 4 comments 0 points Most recent by User_2025-02-04-06-33-06-582 Reporting and Analytics for HCM
-
Absences ReportSummary get the working dates between start_date and end_dateContent we have requiremnet to generate absences report, need help on sql query, If any empployee having abs… -
BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a singlSummary BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a single email idContent Hi, In BI Publisher bursting, we usually bu…User_MC37Q 106 views 6 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Link BIP Report to InfoletSummary Can we Link BIP Report to InfoletContent Hi All, Can we Create BIpublisher Report and link to Infolet, and how we can give access to particular user these infole…
-
Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesSummary Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesContent Hello! We are a team of OTBI and BI Publisher users, new to Oracle HCM. I…
-
OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Summary OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Content Hi, I need to know the difference between 'Keep Timestamps' and 'Ke…User_MC37Q 61 views 2 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
BI Publisher: Can we FTP the individual bursted emails onto the Web content serverSummary BI Publisher: Can we FTP the individual bursted emails onto the Web content serverContent HI, We are aware that we can FTP or put to Web content server, a BIP re…
-
Sql query is not workinkgContent Hi, trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1 Select * from per_assignment_supervisors_f sup, per_all_people_f p…Gal Shani 69 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to create a report to pick address fields which have invalid charactersSummary How to create a report to pick address fields which have invalid charactersContent Hi I am working on a requirement to create a report which would pick invalid c…User_2025-01-30-21-52-52-008 41 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Hide Catalog and New based on RoleContent Hi All, Is there a way to hide Catalog and New based on User Role? I have a requirement to share reports with other Oracle HCM cloud users, but i want to restric…User_2025-01-30-00-14-06-021 74 views 3 comments 1 point Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM
-
save a BI Publisher Output pdf or OTBI Output pdf in Documents of recordsSummary save a BI Publisher Output pdf or OTBI Output pdf in Documents of recordsContent Hello, It is a possible to save a BI Publisher Output pdf or OTBI Output pdf in …Giuseppe 1234 32 views 4 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsSummary Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsContent Hi, We need information about how to capture the evalua…User_MC37Q 356 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
CASE WHEN in BI PublisherSummary Using CASE WHEN in BI Publisher SQL and not getting resultsContent Hi all, I have been writing a BI Publisher data model with SQL to bring back employees along w…User_2025-01-29-21-02-12-466 570 views 10 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM
-
Table per_national_identifiers is blank however there are data in the screenSummary per_national_identifiers table no dataContent Hi, I have a problem with person national identifier table is shown no data but the application screen shows data c…
-
OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaSummary OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaContent Hi, We are creating a Dashboard for plotting the average …User_MC37Q 75 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
how to get seniority date of a person from Oracle Fusion HCM tablesSummary how to get seniority date of a person from Oracle Fusion HCM tablesContent Hi, We are creating a BIP report to fetch seniority date of a person onto a Terminatio…User_MC37Q 1.1K views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Need inputs to fetch PBL batch start time and End timeContent Hi All, Please suggest in which table holds the when the PBL process started and end dated (i.e. completion time). Ex: If we submit PBL batch, we need to know co…
-
Workflow table Fusion HCMSummary Need to extract notification historyContent Hi, Being saas customer do i have option to extract workflow data from Fusion HCM Br Azfar.Azfar.128 98 views 2 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM