BI Publisher
Discussion List
-
Candidate Profile Print out ReportSummary Candidate Profile Print out Report BuildContent Hi All, I have a new requirement to build Candidate Profile Print out Report HCM--> My Client Group --> Hiring --…Iann hick 86 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to link locations with geographySummary: Content (required): Hello Guys, We would load the city present in the locations inside the Geography of the recruiting. How could we perform it? Where could we …Giuseppe Iacono 41 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Scheduling BIP Report in Fusion Financials (Cloud) - Conditional SendSummary: Is a trigger necessary on a data model to conditionally send or not send a report in BI Publisher or will a data model that returns rows or doesn't suffice? Con…User_2025-02-10-15-12-48-631 21 views 2 comments 1 point Most recent by User_2025-02-10-15-12-48-631 Reporting and Analytics for ERP -
What table contains the Receipt Amount in Contract Billing Details screenSummary: Hi - what is the underlying table(s) that contain the Receipt amount in the contract billing screen Content (required): Where is the table containing this data … -
Payroll Costing and BalancesSummary: Has anyone ever used these two subject areas in an OTBI analysis correctly? : Payroll - Payroll Costing Setup Details Real Time & Payroll - Payroll Balances Rea…Andrew_Schmitz 41 views 7 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
how to sum two condition in e-text template on oracle fusion hcmSummary: When we add all 4 fields the output of the report comes blank. I am able to add Shift Pay+Incentive+Current Salary the output appears but when i add Lead Pay (w… -
Error Receive when View ReportSummary: Error Receive when View Report Content (required): User receive the error message below when generating dashboard Version (include the version you are using, if…CraigX 11 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Not able to add dashboards objects and OTBI contents on Dashboard pagesSummary: I am trying to create one dashboards using analysis but when I created one dashboard and trying to add column sections and other dashboards options on dashboard…Kamini Kaushik-Oracle 21 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Unable to get the BIP DataModel With DataCache References in Diagnostics ResultsContent Hello All, As per the oracle KM note 'Fusion Global HR: BIP DataModel With DataCache References Diagnostics Resulting Failure: null (Doc ID 2754842.1)', i tried …Janardhana Kondaveeti 33 views 12 comments 2 points Most recent by Peng Yang Reporting and Analytics for HCM -
Employee Phone Numbers Comparision ReportHi Experts We have client requirement for design a report which pulls up Employee details along with their work and home phone numbers. The inputs are Start Date and End… -
How can we print an encrypted alphanumeric code on the face of each cheque?Summary: The banking sector has made changes in respect to cheque production, this change requires a UCN (Unique Cheque Number) to be applied to each cheque produced. Ma…Sohesh Patel-Oracle 71 views 1 comment 0 points Most recent by Andy Hayes Payables, Payments & Cash Management -
Show OTBI Graph with no values rather than No Results messageSummary: There are instances when the OTBI bar graphs result in no data results. Instead of showing a "No Results" message, is it possible to show the graph instead? We …User0901 42 views 1 comment 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
How to check/download the BI report output submitted by usersSummary: Content (required): This is from Support User perspective. If a user opens a report from BI Catalog, runs it, and downloads the output, then how can we check/do…Vinay Gharge 32 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
HCM Transaction Status DashboardSummary HCM Transaction Status DashboardContent Hi Team, Do we any dashboard to monitor all HCM transactions? Thanks. Version 20B -
CUSTOM BIP NOTIFICATIONS NOT TRIGGERINGContent Hi, After adding BIP_CLIENT_REFRESH_TIME in Manage Administrator Profile Value, we are observing that many transactions aren't triggering custom BIP notification…Mohit Sinha-Oracle 101 views 9 comments 2 points Most recent by A.JOSH Reporting and Analytics for HCM -
Schedule Event Trigger in Data Model Errors immediately when ScheduledSummary: I have created an event trigger in a data model, which I have done before without issue, but for this one as soon as I schedule the report that uses this data m… -
Query to get account numberSummary: Query to get account number present in below screenshot Content (required):Navigation - Payroll>Statement of earnings>Costing Results>Account number. Can anyone…Jaeyshree Kumaran 41 views 1 comment 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
workforce structure change reporttrying to build a report that captures changes on the department table. We maintain history on our departments, but would like to be able to report on it. If we do the r…Mike Borghoff 81 views 4 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Mismatch in ZX_LINES and Manage Tax Details in Invoice PageSummary: Hi All, We are trying to create a report to fetch invoices with tax point basis as "ACCOUNTING". When we try to open the invoice result in front end it shows th…Siva Kumar-Oracle 42 views 0 comments 0 points Started by Siva Kumar-Oracle Reporting and Analytics for ERP -
View Formatted CLOB Text in BI Report Excel TemplateSummary: We are trying to fetch a formatted CLOB Data in an Excel template. However, the report is fetching HTML tags in the Excel cell . We tried the solution given in …Tanu Shri Patel 306 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BI Publisher RTF Template AR Invoice : Grouping rowsContent I am required to create an AR Invoice report, where services are needed to be grouped based on what kind of service they are within a report. To be more clear, f… -
How to use one or the other parameter in a SQL querySummary: I have a query that I built that is supposed to either pull in the list of terminated employees based on the date range entered OR a list of terminated employee…User_2025-02-04-08-51-08-912 51 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Can we Hide Exporting options from user while running BI Publisher Reports ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Kaustubh Deshmukh 31 views 7 comments 1 point Most recent by Kaustubh Deshmukh Reporting and Analytics for HCM -
Combining two analysisHi Team, Can we combine two or more analysis (columns are same for all analysis) results in a single report? Thanks. -
Report With the FileURL (Download Link) of an Employee DocumentSummary: We need a BIP report with a download link to an employee's document (DocumentRecords) Content (required): Hi, Is it possible to generate a BIP report with the d…Yaniv 31 views 5 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Default Revenue account for Credit Memo lines not defaulting correctlyContent Hi Would like to kindly seek help as when we are creating a credit memo, the default revenue account combination is not exactly defaulting as some of its segment…User_2025-02-11-12-30-38-982 41 views 2 comments 0 points Most recent by User_2025-02-05-00-10-05-674 Receivables & Collections -
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…