-
Added/ deleted/ modified PVOs/ PVO columns/PVO keys for 21c version for FSCM and CX documentation re
Description Hi, We are in a process of implementing data extraction from Oracle Fusion (FSCM and CX). We have below observation in every version release of fusion - 1> few of the new PVO added with every version. 2> Few of the already exiting PVOs definition get changes. 3> Few of the PVO's primary key definition gets…
-
Added/ deleted/ modified PVOs/ PVO columns/PVO keys for 21c version for FSCM and CX documentation re
Description Hi, We are in a process of implementing data extraction from Oracle Fusion (FSCM and CX). We have below observation in every version release of fusion - 1> few of the new PVO added with every version. 2> Few of the already exiting PVOs definition get changes. 3> Few of the PVO's primary key definition gets…
-
Unable to perform multiple delivery option using Bursting
Organization Name Accenture Description We have added Email Notification and SFTP/UCM in the bursting. But at the template level its allowed to choose only 1 delivery option. We are unable to perform multiple delivery option using bursting. Use Case and Business Need As we have a requirement to send the file to SPFT and…
-
Exclude parameter tags based on file format
Organization Name Macquarie Global Services Description We are trying to generate Excel and CSV file using rtf template. Excel file needs to display parameters. When we enable to include parameter tags on datamodel. It also gets included on the csv output. Due to this the csv file size increases as the parameter on csv is…
-
Automatic Backup of HCM OTBI Custom folders
Description Hello, We want to take backup of OTBI custom folders on a regular basis to avoid getting deleted by mistake. Is there a way to automate periodic backup of custom reports/OTBI folders in HCM cloud? Please let us know. Use Case and Business Need We want to take backup of OTBI custom folders on a regular basis to…
-
Exclude prompts while printing Dashboard Output
Organization Name IRB Description Currently we have set of properties that can be defined when we want to Print the Dashboard Output. We would like to have an option to Include / Exclude the prompt Section as well if possible. Attaching the list of option currently provided to help under Dashboard --> Edit --> Setting -->…
-
Need BIccExtractPVO's for below Finance Tables in Oracle Fusion
Organization Name Dropbox Description Need BICCExtractPVO's for below Finance Tables in Oracle Fusion, ZX_ACCOUNTS AR_LOCKBOXES_ALL HZ_PARTIES HZ_CUST_ACCOUNTS HZ_CUST_ACCT_SITES_ALL HZ_CUST_SITE_USES_ALL HZ_CONTACT_POINTS HZ_RELATIONSHIPS These are key tables and we are using Bicc via ODI to extract data from Oracle…
-
Need BICC PVO to extract data for billing reports
Organization Name KPMG Belgium Description Please provide PVO's for following tables : PJF_RATE_SCHEDULE_LINES (not only RateScheduleID and RateScheduleName, but columns like RATE, START_DATE_ACTIVE, END_DATE_ACTIVE, PRVDR_ORGANIZATION_ID, RECVR_ORGANIZATION_ID, NL_PERCENTAGE _APPLIED, TP_AMT_TYPE_CODE,...)…
-
Ability to report on email address changes
Description Tracking email address changes, showing the previous value. Use Case and Business Need Some reports from external training providers are based on the email address of the employee as the unique identifier, making it difficult to look for the employee if email address is changed. Original Idea Number: f49d44203f
-
There should be compression and Republishing options defined for scheduling BI report from Schedule
Organization Name GE Description There is a need to submit/schedule BI reports with compression and Republishing options through Webservices using ScheduleReportWSSService. Use Case and Business Need To submit /schedule BI reports we are using ScheduleReportWSSService webservice, scheduleReport operation .But we need to…
-
Fields not available under Workforce Learning - Learning Records Real Time Subject Area
Description Hello Team, I was using the Subject are Workforce Learning - Learning Management Real Time time to create OTBI reports. Now I came to know that the same subject area will not be taken further and we have to use Subject Area- Workforce Learning - Learning Records Real Time to create the OTBI reports. But…
-
Ability to extract BI report from ESS output without assigning BI Administrator role
Description Hi, We have a requirement where user needs to extract BI report from ESS output without assigning BI Admin role. As BI Admin role has BI Author role inherited, it gives away too much access to users who only need to see report outputs. But as per Oracle to extract BI report from ESS, BI admin role is compulsory…
-
Include Enterprise Scheduler Job Display Name in REQUEST_HISTORY table
Organization Name Northumbria Healthcare NHS Foundation Trust Description We have a requirement to build a report to replicate the 'Schedules Processes' UI page in fusion to allow clients to view all ESS jobs ran by users in thier organisation. The REQUEST_HISTORY looks to be the only table that contains this data, however…
-
A Enterprise Contract Dashboard Report that will list all the contracts where the user is the owner
Description A Enterprise Contract Dashboard Report that will list all the contracts where the user is the owner or assignee. In Enterprise Contracts- Contract Real Time subject area not able to find out the created_by field to default data where the user is the owner. Use Case and Business Need When user login to Contract…
-
Add Missing Business Classification within Procurement - Spend Real Time subject area
Description Within the Procurement - Spend Real Time subject area - the only SA that I can attach spend and time to - does not have all of the business classifications accessible. You are missing two (small disadvantaged and LBTG). This makes it difficult to report spend on suppliers which have those two classifications.…
-
Restrict OTBI access to HCM Application DB
Organization Name Inspirage LLC Description Client is live on HCM and they are now implementing planning. They want to restrict access to HCM application tables/objects from OTBI. Use Case and Business Need Can you please let us know how to achieve the same. Please find below the screenshot from OTBI > New > Data Model.…
-
Include the field "Entered by" in the Procurement Analysis Subject Areas
Description Include the procurement requisition "Entered by" field in all Procurement analysis subject areas. Use Case and Business Need Our organization has many requesters that enter purchasing requisitions on behalf of others. It is important to have the field "Entered by" available in all Procurement analysis subject…
-
Add back in: DFF's into 'Procurement - Procure to Pay Real Time' Subject Area
Organization Name AWE Plc Description The DFF's have been removed from the 'Procurement - Procure to Pay Real Time' Subject Area since the 21A upgrade. We're very surprised that this has been pulled by Oracle. This is pivotal to some of our key reports. Please can this be re-instated? DFFs Missing From Procurement -…
-
Secured views for Performance and Talent Management
Description At present we are having the secured views for Core HR data (Position/Department/Assignment) only. Can we get the secured views for Performance and Talent data as well? We have a scenario, where employee is having Core HR and Talent roles. The application security is working as expected where as in the report…
-
Inbuilt functionality to display error messages based on date validations.
Organization Name Petronas Digital Sdn Bhd Description Steps;1. Go to URL https;//epuc-dev1.fa.ap1.oraclecloud.com/ 2. Login as Employee3. Go to Tools Tab4. Click on Reports and Analytics5. Click on Browse Catalog button on the top right corner6. Click or Expand the Shared Folder7. Click or Expand the Custom Folder8. Click…
-
Receivables-Transactions Real Time :Field is not available transaction header creation , update date
Organization Name Greenergygroup Description Receivables-Transactions Real Time :Field is not available transaction header creation , update date in line level "Line Last Update Date" , "Line Creation Date" Receivables-Transactions Real Time, for report "sales invoice change " I could not find "Line Last Update Date" ,…
-
Receivables-Transactions Real Time :Field is not available transaction header creation , update date
Organization Name Greenergygroup Description Receivables-Transactions Real Time :Field is not available transaction header creation , update date in line level "Line Last Update Date" , "Line Creation Date" Receivables-Transactions Real Time, for report "sales invoice change " I could not find "Line Last Update Date" ,…
-
Edit Report: No execution of query before edit it
Description hi, we would like to request an enanchment regarding the "Edit Report" functionality. In ticket SR # 3-24371241531: OBIEE 11 Edit Report we asked if it was possible to avoid the query being executed before editing the fields of a report. You answred to us that this is normal behavior but that the request can be…
-
OTBI Direct Agent Recipient based off of Analysis
Description In the reporting portion of Oracle (OTBI) we can set up agents based off of columns within the result of the analysis. Currently, there are only two columns available to utilize. Would we be able to add a third field (recipients)? Use Case and Business Need In several organizations, there are multiple levels of…
-
Edit Report: No execution of query before edit it
Description hi, we would like to request an enanchment regarding the "Edit Report" functionality. In ticket SR # 3-24371241531: OBIEE 11 Edit Report we asked if it was possible to avoid the query being executed before editing the fields of a report. You answred to us that this is normal behavior but that the request can be…
-
OTBI query timeout should be increased
Organization Name Persistent Systems Limited Description Currently as we are developing Learn reports for all reports if data is large in OTBI as well as BI report it gives timeout error. The timeout time is 10 minutes , but in OTBI if we require more columns then it internally create query and gives timeout error. Use…
-
Support SFTP for BICC External Storage
Organization Name AEP Description Hi, We'd like to have SFTP supported in BICC. One use case we have is we export high-volume data from BICC to SFTP then Eloqua can consume the file on SFTP with its scheduled import feature. Thanks, Adam Use Case and Business Need as above Original Idea Number: ab668b6f25
-
Ability to view both scheduled and unscheduled report job history in BI Catalog Report Job History
Organization Name Hutchison International Limited Description Currently only Scheduled report in available in Report Job History. Please extend this functionality to unscheduled reports as well Use Case and Business Need User need to keep track of the parameters of each report submitted, both scheduled and unscheduled…
-
Ability to view both scheduled and unscheduled report job history in BI Catalog Report Job History
Organization Name Hutchison International Limited Description Currently only Scheduled report in available in Report Job History. Please extend this functionality to unscheduled reports as well Use Case and Business Need User need to keep track of the parameters of each report submitted, both scheduled and unscheduled…
-
OTBI Subject Area for Manage Mass Updates Module
Organization Name Willis Towers Watson US LLC Description Please create an OTBI Subject Area for the Manage Mass Updates module in HCM. We are unable to access the backend tables to create BI Publisher reports as well, so an OTBI Subject Area would be ideal. Use Case and Business Need Create reporting from the data in the…
