BI Publisher
Discussion List
-
Annual Leave Buy / Sell - ReportSummary: A Report to identify those Employees who Bought / Sold Annual Leaves Content (required): Hi, Can you please help me to develop a report which will give details … -
Deeplinks in OTBI and BI ReportsContent Is there a way we can use the Deeplinks in the OTBI and BI reports dynamically. Suppose I have a column for 'Person Number' and I click on a particular person nu…Amrit 121 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Is there a way to join these 2 subject areas?Summary: Is there a way to join these 2 subject areas: Human Capital Management – Approval Notification and Archive Real Time & Workforce Management – Person Real Time. … -
Bursting Report outputSummary: Bursting Email Contains the Sql Query output in the Message Body. How to Remove the Sql Query Output line from the Message Body Content (required): Version (inc…MilanMohanty 81 views 9 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Team Time Card BIP Query for Team information and approval status and Overtime Information.Summary: Need SQL Query for the Manager can view his team information of time and overtime information. Content (required): Version (include the version you are using, i…Ketan Prajapati 431 views 2 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
How to report the use periods of the learning activitiesSummary: How to report the use periods of the learning activities Content (required): Hi, we would like to build a report which allows to have the information about the …
-
How to Customize Dispute Approval Workflow NotificationSummary: Need to display more data / attributes on dispute approval workflow notification. Content (required): Need to know the data model and template that is being use…
-
Query to extract employee Salary SourceSystemId and SourceSystemOwnerSummary: Content (required): Hello experts, please could you share the SQL query to extract employee Salary SourceSystemId and SourceSystemOwner? Thanks in advance for y…Valerio Curzi 141 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
List of All Tables for Oracle Fusion ERP in PDF FormSummary: We need to have a List of All Tables for Oracle Fusion ERP in PDF Form along with its corresponding descriptions Content (required): We need to have a List of A…Gene Garcia 2.2K views 13 comments 0 points Most recent by Agnes.Ramos Reporting and Analytics for ERP
-
Unable to create a new Application Page Entry for a BI ReportSummary: Unable to create a new Application Page Entry for a BI Report Content (required): We are trying to create a page entry to open a BI Report. Used the Application…Bhargava Varma G 51 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Table name which stores start date and end date in individual compensation planSummary: Hi Everyone! I am looking for the table name which stores start date and end date in the individual compensation plan. I tried - cmp_plans_vl, cmp_components_vl…
-
Seeing Data Across Different EnvironmentsSummary: Viewing data across different environments inconsistent. Content (required): When I run a report, we created in Dev11, there some data that I don't see in our U… -
How to invoke a BIP report with parameters from Oracle cloud ERPSummary: Can we invoke a custom BIP report with parameters from the items application page. Content (required): We want to call the report in the same way as how the Gen…Neela.Voduguru 72 views 1 comment 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
How to sort by timestamp in BIP TemplateSummary: Is it possible to sort all the four tiles (Initiated By, Assigned To, Approved By and FYI) by timestamp? Attached is the screenshot (Workflow transaction detail…Angelica Tayactac 1 view 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
how do I define datesSummary: I am trying to fun an agent weekly and want to have it select a date range Content (required): the job will run every Friday morning and needs to include employ…
-
Need source information - Invoice Validation Status Funds RelatedSummary: Need source information (DB Table, View and/or Other) for Invoice Validation Status Funds related. Navigation - Manage Invoices > Query Invoice Number > Click o…Ravi Shinde 51 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
AR - Is it possible to print the invoices with Portal upload invoicing Delivery method?Summary: We need to print the invoices when we setup the invoicing delivery method as Portal Upload Content (required): The Print Receivables Transactions process exclud…SathyaKannan 111 views 1 comment 0 points Most recent by Vitalie Rusanovschi-Oracle Receivables & Collections
-
How to join AP_INVOICES_ALL with FND_ATTACHED_DOCUMENTSSummary: We need to be able to join AP_INVOICES_ALL with FND_ATTACHED_DOCUMENTS Content (required): Hi team, We currently have a report to extract Paid Invoices where we…Nikash 844 views 1 comment 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Any Suggestions of how to improve Web Clock Custom Dashboard data reflection earlier.Summary: We are facing a time-lapse on Custom Dashboard which has reflected the data in delay some time especially in web clock in and out table records. we need a worka…
-
can we send .ics/calendar attachment for instructor-led offering through bursting reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
Show timestamp in human readable format while respecting time zoneSummary: Display the date and time from the last_connect column in the fnd_sessions table in a human readable format. The time should also respect British Summer Time / …
-
Custom BI report for ESS job historySummary: Hello All, I would like to know if there is a way to create a custom BI report for monitoring ESS job submitted by specific users. I have the below tables, howe…SubhasishRay 51 views 5 comments 2 points Most recent by Varun Jain-Oracle Reporting and Analytics for ERP
-
Need help - Need a payroll report for Element vs BalancesSummary: We need to create a report to include Element names which are feeding a particular Payroll Balance. We tried to do it using Payroll Subject Areas but it did not… -
Audit course access and executionAudit course access and execution Hi, for legal reasons we need a way to know: when did the workers connect to perform the learning activities? what is the progress on t…
-
SQL query to see the dependents for an employee who have pending action items in benefitsHi Experts, Can anyone please share an SQL that can show me the list of all dependents for an employee who have a pending action in the benefit plans? Say for a dependen…Aloka Bhattacharya 3.1K views 3 comments 1 point Most recent by SachinP21 Reporting and Analytics for HCM -
How to sum a variable in XSL template?Summary: I'm unable to a sum a variable data in XSL template. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code…SireeshaJaladi 121 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP
-
Is there a size limit for email attachment for BI reports?Summary BIP - Report size is 15MB, job succeeds but never sends email.Content My report generates 15MB excel file but fails to email the report every time. I limited my …
-
Mask/Hide OTBI File Path Location on Browser Address BarSummary: Trying to find a way to hide/mask the OTBI file path location shown on browser address bar to minimize unexpected attack from anyone. Content (required): We jus…Karen Benita 51 views 3 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Sales