Reports
Discussion List
-
Getting error while bursting BIP report output to sFTP serverSummary: Getting below error while bursting BIP report output to sFTP server- Below is my SFTP bursting query- *with hash_q as query* select distinct HASH "KEY", 'MicroS…Neha Aishwarya 124 views 1 comment 1 point Most recent by Lucy Garding Reporting and Analytics for ERP -
Transaction console approvals reportThe user is asking for a BI report that shows all the approvals for a transaction in HCM, right now I'm able to find the current and historical approvals but I can't fin…RODOLFO GARCIA SOTELO 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Download older version of snapshot in Oracle NRIs there a way to download daily maintenance snapshot in Oracle Narrative Reporting for an old specific date (For example - I want a 10 days old snapshot). Currently I a…
-
How we can password protected a bursting BIP report?Summary I want to burst person Information and i want the output file should be password protected with person DOB(MM-DD-YYYY). How we can achieve this using burstingCon…Ashish Mangal 817 views 9 comments 0 points Most recent by Bhanuja Batra-Oracle Reporting and Analytics for HCM
-
How to bring HCM UDT Columns into Fusion OTBI subject areaSummary: Need to access the UDT columns (HCM) in OTBI standard subject area's instead of using the "Payroll - User Defined Tables Real Time" as a separate subject area. …
-
How to identify who made changes to the DFFs we used in our OTBI reports?Summary: There are few OTBI reports in Dev env which resulted in error because of missing DFFs. we got the DFFs back by running the schedule process. but we want to know…Hitachi ServiceDesk 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to filter a column?Summary: Hello, I need help on how could I filter to show only the last row. Thank you in advance! Content (please ensure you mask any confidential information): Version…
-
How to write a query to get accurate "when is the employee start date?" from the OfferSummary: Hi Team, We are trying to add value for "When is the employee start date?" in one of ours Offer accepted report. However when the employee start date is changin…
-
Multiple Templates - BI Publisher BurstingSummary Multiple Templates - BI Publisher BurstingContent Hi Experts I have a BI bursting report where we need to send an attachment as well as the bursting email notifi…Mansur Khalil 210 views 7 comments 0 points Most recent by Yahya Khan Reporting and Analytics for HCM -
Use of PAYROLL_CHG_FLAG in ANC_PER_ABSENCE_ENTRIES TableSummary: Use of PAYROLL_CHG_FLAG in ANC_PER_ABSENCE_ENTRIES Table Content (required): Hi All, Can anyone please let me know the use of the column PAYROLL_CHG_FLAG in ANC…
-
Are Named Ranges in excel report output generated by FCCS MR referenced anywhere?Summary: Getting an error message to repair the excel report due to named ranges generated by the application. Need suggestions to deal with it. Content (please ensure y…SanjanaRR 51 views 7 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Run large BIP reports using ScheduleReportWSSServiceSummary: In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes. Fusion Application BI Publi…Pradeep Moganti 409 views 2 comments 1 point Most recent by User_0P0CT Reporting and Analytics for ERP
-
DFFs missing from few OTBI Subject areasWe have Multiple OTBI reports in which the DFF columns are missing from the subject areas. after running the “Import Oracle Fusion Data Extensions for Transactional Busi…Hitachi ServiceDesk 26 views 4 comments 0 points Most recent by Hitachi ServiceDesk Reporting and Analytics for HCM
-
How to check user access statistics for artifacts?Hi, How can we check how many times and which user has accessed a form or report in PBCS application for the past 90 days? Is there some way to get the statistics? We ne…
-
Custom attribute in oracle delivered / seeded HCM extractSummary: Hi experts, Working on Payroll Interface for ADP Global Payroll V2, requiring a pay group field. Pay group field is a DFF stored in attribute 12 of the "per_all…
-
Deep link for Journals to view Journal Entry ScreenSummary: Hi Team, Need some details about the Deep link for Journals to view the Journal. In BIP report on Journal Batch Name column , respective journals can be opened …
-
Extract Invoice attachment with Rest API Fusion ERP CloudSummary usingContent The following help page documents how to use the Get an attachment for an invoice Rest API. Running the codes gives me a similar response as per the…
-
How can I retain the drill down selection from the previous run in my narrative reporting?We have a report that requires the user to perform multiple drill-down actions. The user finds it tedious to have to repeat these drill-down steps each time they want to…
-
How to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (required): There is an existing OTBI report created thru …Winky Chan 81 views 4 comments 0 points Most recent by Sudhir Behera Reporting and Analytics for ERP
-
How to embed/display the DOR attachments/images (blob data) in BIP reportWe have a requirement where employees signature needs to be captured in BIP template/report. So we are thinking of loading the employee signatures as an image via DOR ag…
-
Can you help me with an example of how to use DFF in a query??I am building a query to extract invoice details as well as the line level Entity, Category and Actual month details as well from ap_invoice_lines_all table. Attribute3,…Jahnavi Konduru 31 views 4 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for ERP
-
Need API for User module name , Module key and module type under manage value setsSummary: Hi Team, We need a API to get User module name , Module key and module type under create value set as shown in below screenshot. Content (please ensure you mask…
-
How to use the or in if clause together in RTF correctly?In RTF template How to use OR in the IF condition ?MayuriMMote 13 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
SQL tables that store invoice and journal approval data like tasks & related rules etc.?Summary: What are the SQL tables with invoice and journal approval data like tasks and related rules like we have for procurement where we have the table POR_AMX_TASKS, …Gurvinder Singh Gill 901 views 3 comments 0 points Most recent by Sravani Budde Reporting and Analytics for ERP
-
How to merge rows in OTBI?Summary: Hello, how can I merge these rows below? There seem to be an extra row under Role/Assignee and Due Date. Thank you Content (please ensure you mask any confident…
-
How to attach custom bi report to document of recordsSummary: How to attach custom bi report to document of records Content (please ensure you mask any confidential information): Hi All, We got a requirement to attach bi r…
-
Leases pending in version status 'report generation in progress'Summary: Hi, We have converted > 12000 leases in February. Now when closing the first month it looks like most of the are pending in version status 'report generation in… -
How to display in a Report a Document of Records (DoR) Image AttachmentSummary: is it possible to achieve the following requirement? 1. Update an image to a DoR as attachment 2. In a report enter a DoR ID as a parameter and then print/displ…
-
User Entities used in the seeded Extracts are not available to use in newly custom created extractsI am creating a Payroll Costing related HCM Extract. I referred the oracle seeded HCM extracts, there is one named 'Payroll Costing Report', this extract has all my requ…