BI Publisher
Discussion List
-
Oracle Fusion Application - Usage StatisticsSummary Oracle Fusion Application - Usage StatisticsContent Hello, Can anyone please help me to capture usage statistics on Oracle Fusion Applications? I was using one o…SantoshKumarBhairi 138 views 11 comments 1 point Most recent by Shannon_Johnson Reporting and Analytics for HCM -
FIlter on Excel BI Publisher TemplateSummary: FIlter on Excel BI Publisher Template Content (required): We want to apply a filter on a column in the excel template. We have a report showing all employee of …A.Ferraro 354 views 3 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Performance Document Changes Audit ReportHello, We have a need to audit our Performance Documents to understand who all made changes on a performance document. Each time a rating is changed we want to generate …Nick Dorfner 338 views 7 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Is there a way to bulk enabling DFFs instead of one by oneSummary:We have many DFF that will need to enable for BI. Looking for a faster way to enable all at once instead of doing it one by one. Content (please ensure you mask … -
For impact analysis on BIP data models which meta data table is used in Fusion HCMSummary: As a part of impact analysis how can we find particular field is getting used in which BIP data models. Content (please ensure you mask any confidential informa…Siddhesh Nisal 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BIP Report Tagged to OTBI Dashboard is taking long time and error outSummary: BIP Report is developed and tagged to OTBI Dashboard. Taking longtime more than 10 minutesand then error out Content (please ensure you mask any confidential in…Anjan Polimera 41 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Extract text data from "SuccessCriteriaText" in "XML_DATA_CACHE" column "HRC_TXN_HEADER" tableSummary: Does anyone know how to extract text data from "SuccessCriteriaText" column in "HRC_TXN_HEADER" table? Although I could extract some text data such as GoalName,…S.Watanabe0110-Oracle 163 views 1 comment 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
BI report - rejected by in Job RequisitionWe are building a report to check the rejected job requisitions and we can't find the field for who rejected the requisition. The field IRC_REQUISITIONS_VL.LAST_UPDATED_…Marta Martinho 11 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Query to get assessment questionnaire responses for an employee from learn moduleSummary: Query to get assessment questionnaire responses for an employee from learn module Content (please ensure you mask any confidential information): Hello, I'm tryi…Manisha Rajupeta 417 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Courses Link table name for LMS reportFrom which table we can get the course link in bi reports. Can anyone help me with the table name. Thanks, Dara NagasaiDara Nagasai 1 view 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Person details are coming as blank in the reportHi Team, We have a requirement to build a query with Card program name,Transaction Amount,Transaction Date, Employee Name and Employee Number. We used below in the query…
-
Audit of BIP Report ChangesSummary: Audit of BIP Report Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there any available feature to track or audit …Parag Hiremath 43 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
do you know which table store the records of attached Contracts page Details in fusion?Summary: do you know which table store the records of attached Screen Details in fusion. Content (please ensure you mask any confidential information): Version (include …B.Anil 11 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
SQL to pull Number of Days between two dates (one is a Parameter Date)?I'm currently using BIP Report. This sequel works on me if I'd like to use SYSDATE: TO_NUMBER(TRUNC(SYSDATE) - TO_DATE(TO_CHAR(SEN.SENIORITY_DATE, 'YYYY-MM-DD'),'YYYY-MM… -
Has anyone been able to set up bursting to get the AP remittance pdf file sent to the FTP server?Summary: Send remittance pdf file to the FTP server for bar coding and printing Content (please ensure you mask any confidential information): We are producing our AP re…Sarah_Ward 46 views 2 comments 0 points Most recent by Sarah_Ward Payables, Payments & Cash Management
-
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Report Access Issue - User Unable to Open and Access Report.Hello Community, I'm facing an issue with a BI Publisher HCM user information report. A specific user is unable to open and access the report, and I'm hoping someone can…Omran Zeaiter 281 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Japanese Addition or All Asset Detail by Asset Type Report 132 Characters - Role required to run esswhat is the role required to run the report ess job - Japanese Addition or All Asset Detail by Asset Type Report 132 Characters.PL Karthick Ramanathan 11 views 1 comment 0 points Most recent by Shawna Green-Support-Oracle Assets
-
Is there any way to create bulk users and assign them bulk roles. Also any limitations involved?Summary: Is there any way to create bulk users and assign them bulk roles. Also any limitations involved? Content (required): Is there any way to create bulk users and a…Lucky Sharma 91 views 7 comments 1 point Most recent by CHANDRESHWAR DWIVEDI Reporting and Analytics for HCM -
Looking for sql script to get Salesperson Account ReferencesWe need sql query Salesperson Account References. Anybody can help to provide the sql or related table?Guocheng-Oracle 131 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to have payment amount in a cheque be in a different language other than englishSummary: I would like to know if we can have the payment amount for an invoice cheque be written in french depending on the language of the supplier site or depending on…Marina Girgis 31 views 2 comments 0 points Most recent by Marina Girgis Payables, Payments & Cash Management -
Options for logo in email body invoice (other then HTML link)Hi, We are looking for a way to put a logo in the email body of emails for receivables invoices. I started looking for options and often came across the method in which …MennovD 72 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
XML Publisher/BI Publisher make text bold in XDOFX IF condictionSummary: Content (required): Hi I have this field COMPONENT_NAME from my data model. I've created a table wizard with a repeating group for all the values in COMPONENT_N…Nicolas Vahman 281 views 4 comments 0 points Most recent by Prameesha Reporting and Analytics for HCM
-
How to generate SAT compliant XML AR invoices for Mexico?Summary: We are doing Mexico implementation and need to know if there is any seeded way to generate compliant XML for AR invoices Content (please ensure you mask any con…
-
How do I pull the exact same timecard data that appears on the Oracle Team Time Cards screen?Summary: I need to create a data model that pulls the exact same data that appears on the Team Time Cards screen. We have OTBI reports that use the "Workforce Management…BeachDreamer 91 views 1 comment 0 points Most recent by Mohamed Mahrir Reporting and Analytics for HCM -
How to update US 1099 Report for custom Format layoutSummary: My team has a requirement to add some custom updates to the Oracle generated US 1099 report. The need is to have multiple sections. The top 1/3 of the page bein…Tim Smith99 331 views 2 comments 0 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management
-
"SQL or ORA exceptions caused due to invalid sql" Error MessageSummary: "SQL or ORA exceptions caused due to invalid sql" Error Message Content (please ensure you mask any confidential information): Hi, we built a report based on th…