BI Publisher
Discussion List
-
Data Persistency in Oracle Cloud - how long will Request Ids, Output/log files be available?Summary: is there any time period for which the request ids, output/log files of Oracle ERP Cloud Process/Job/ESS requests are made available? Or Will these be available… -
Can we get the dynamic url in BI Publisher email notifications?Summary: When we schedule a custom BIP report, and once it is completed then system is sending an email notification with the status. In the email notification there is … -
Creating Asset Cost Summary Report in OTBISummary: Creating Asset Cost Summary Report in OTBI Content (required): I created "Asset Cost Summary Report" in OTBI, however, I am not getting back the balances as the… -
Standard Oracle depreciation report.Summary: Hi All, Thank you in advance for your help and time. I am just wondering if there is a standard Depreciation report that we can use in the Asset module (Oracle … -
DRILL DOWN TO EXPENSE REPORTS AND EXPENSE ITEMS FROM OTBISummary DRILL DOWN TO EXPENSE REPORTS AND EXPENSE ITEMS FROM OTBIContent Do we have a deep link which we will use in OTBI Report, this is new feature in 20C https://www.… -
Fetch large volume of data in BI publisher reportSummary Fetch large volume of data in BI publisher reportContent HI We have a requirement to extract data for GL code combinations using BI publisher and burst the outpu…ashishgupta0212 724 views 10 comments 2 points Most recent by Alok K Gupta Reporting and Analytics for ERP -
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 82 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 432 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 144 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.1K 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 71 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 847 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…Subhasish-OC 51 views 5 comments 2 points Most recent by Varun Jain-Oracle Reporting and Analytics for ERP