BI Publisher
Discussion List
-
AP Check print BIP report output to be printed from 2 different printers using PCL .Summary: Actually, we have a requirement on AP Check print report in which the page 1(contains the Cheque) which needs to be printed from printer 1 and other pages must … -
Is it possible to report on time worked?Summary: Is it possible to create a report that list the hours worked for an employee? Content (required): We are trying to create a report to show if an employee is eli…Brandon Roberts 313 views 13 comments 0 points Most recent by Scott Pisani Reporting and Analytics for HCM -
How to Generate XML and Modify the Payment Process Request Status ReportSummary: I am trying to customize the payment process request status report but am unable to generate an xml of the report in order to either make a new layout or edit t…Brian Burns 361 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
SQL Query to extract Skill and Qualification Attachment URL?Summary: Content (required): Hello experts, please, could you provide the SQL Query to extract the attachment URL loaded in Skill and Qualification page? Is it possible …Valerio Curzi 132 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
SQL query to extract Candidates ResumeSummary: Content (required): Hello experts, we need to recover candidates resume URL. Is it possible to retrieve this information? Which table store resume URLs. Is ther…Valerio Curzi 535 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
BIP Security - Need to restrict user from modify and deleting the reportsSummary: Hello Everyone, All the users in our environment have BI consumer role. So they are able to navigate to different folders and they have ability to modify and de…Oracletechnofunctional 241 views 4 comments 0 points Most recent by Vlad CONSTANTIN Reporting and Analytics for ERP -
Asset Transactions Real Time'. Which subject area can be joined to get the project informations.Summary: Hello Team, I am using this subject area to get the asset transactional details. I need project information. Which subject area can we join so that we can get t…Suhitha K-Oracle 22 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP -
Excel generated from RTF template is giving wrong valuesSummary: Excel generated from RTF template is giving wrong values Content (required): I have developed a query to get TransactionDr field from GL Lines table. For a spec…Jaeyshree K K 111 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Customer statement for ad hoc queryingSummary: I need a report (BIP or analysis), that gives me the possibility to create an ad hoc Customer Statement. Content (required): The seeded report "Generate Custome…Anders W. Langholm 51 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Requires to create a role to create reports onlySummary: We have a requirement to create a role that have access to create reports only. Where any Financials or SCM or any other modules are not given access to create …Janitha Perera 182 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 71 views 2 comments 4 points Most recent by Tom Strudley Reporting and Analytics for HCM -
Position details with transaction summarySummary: Hello Everyone, I have a requirement to create a position report with a real-time transactional summary. Columns are: I could fetch all the above eleven columns…Saher 61 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Upgraded from Version 1 to 3. PER_SENIORITY_DATES_F - How is it Populated?Summary: New table PER_SENIORITY_DATES_F created as part of upgrade to version 3. Can any one share the details of the data migration to this table? Content (required): …ChicagoConsultant 12 views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Payslip Reprinting Report flow does not Produce Output and cannot be opened because it has no pagesSummary: Payslip Reprinting Report flow is completed successfully and does not Produce Output and cannot be opened because it has no PDF (Blank) pages ####[2023-07-11T16…Janardhan ACS-Oracle 42 views 3 comments 0 points Most recent by Janardhan ACS-Oracle Reporting and Analytics for HCM -
Timeout while using ESS to manage BI submissionSummary: Our ESS job keeps failing with an odd error but if we manually submit the BI it succeeds Content (required): We have a long-running BI query which has been gran…Scott Paulin 371 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM -
Analysis/SQL Query behind Standard Purchase Order InfotilesVersion (include the version you are using, if applicable): Oracle Fusion Cloud Applications: 22D (11.13.22.10.0) Summary: How to Get the actual OTBI Analysis behind sta…Donald 404 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP -
"Null" token value in alert composerSummary: Content (required): Hello, We are experiencing a problem within the Alert Composer configuration. In particular, we note that when a field (token) is not valued… -
SQL Query for Territory BIP ReportSummary: Actually I trying to create a Territory Report includes the Territory Name,Parent Territory,Status , Dimension and Converge details . Can somebody helps with th…Tinu 231 views 4 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Hierarchy not availble in BIWe have created an Organzaiotn Hierachy as per 1th of january 2023. The tree version is active, but noy (yet) avaliable in BI. Same for a Department Hierarchy. Is there …Wouter.Schaap 21 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Custom Performance Management Audit BI ReportSummary: Build a custom BI report that contains audit for performance document Content (required): Would like to know if there's an oracle hcm table to capture the previ… -
Can Anyone Please help me on Mapping between two subject areasSummary: Hi Team, I'm building a report on OTBI using below subject areas in Oracle Learning Cloud: Workforce Learning - Learning Management Real Time Workforce Learning… -
Standard OTBI report displaySummary: Content (required): Hello everyone, We are experiencing problems with the visualization of a standard OTBI made available by Oracle that allows the 'department …Gerardo Peluso 42 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle HCM: How to change existing Host Key Fingerprint in BI AdministrationHi Team, We have a requirement to change the Host Key Fingerprint because of change in SFTP hostkey due to recent changes within SFTP application. Are we able to change …Chaitra Lakshmi Krishna 448 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Is there a seeded skills and qualifications report?Summary: Content (required): Is there a standard qualifications report? Version (include the version you are using, if applicable): 23A Code Snippet (add any code snippe…Stella Kaszab 91 views 3 comments 1 point Most recent by Stella Kaszab Reporting and Analytics for HCM -
Form output created in BI PublisherI prepared a absence form using BI Publisher, when I add the relevant fields, it does not change according to the person, the only date is fixed. What could be the cause…Cansel Karasoy 61 views 15 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
California Meal Break ReportCalifornia Meal Break Report Could you please help us getting a meal break report for the California Employees? Thanks Mansur -
Executing seeded data model to display report - TalentProfileDMSummary: How can I run the seeded data model, TalentProfileDM, to review the data that I have input into the talent profile? Content (required): This is a massive data m…User_2025-02-05-22-55-58-511 31 views 1 comment 0 points Most recent by Welsey Reporting and Analytics for HCM -
Table for security console audit?Summary: We have auditing enabled. Specifically, the "Oracle platform security services" option. We need the table names where audit tracking takes place with respect to…Shant Sarkissian_NES 53 views 5 comments 1 point Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
Replace special characters with standard onesSummary: Hello, we need to build an integration with a BI report where the recipient cannot accept special characters. In person names we have a lot of special character…Nicola Petri 61 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM