-
OTBI: Strikethrough font format needed in the report
-
Need status filter in OTBI subject area Under dimension.
Customer account number shows 1 relationship (1 billing account) in Oracle Account Receivables but in Customer Validation Report shows 2 relationship (2 billing accounts) for same one account where one account is in inactive status and the other one is active. we want the report should show only one account which is active…
-
Audit Report/Functionality Needed for tracking Report Run History
In current system we don't have audit on who had run a particular report . If we want to track the usage of report that how many users running daily we dont have that logging available . It will be good if we have a report with date parameter for detail log as to when this report is run . This report should not hang or…
-
User and Service Account Login Attempt Audit History Report
Apart from the user login attempt information, we need to trace the login attempt of a user using a service account in Fusion. The service account syncs data from one system to another (Fusion), and password rotation is automated. An authorized administrator in the organization also maintains the service account for the…
-
How to extract User Activity Logs (Password Notifications)
The request is to extract the following information from oracle fusion through BIP, OTBI or Webservice. ORA Administration Activity Request Notifies the user when an administrator initiates an administration activity ORA Forgot User Name Sends the user name to a user who requested the reminder ORA New Account Notifies a…
-
How to show XSD data in readable format in BIP xlsx output?
I am getting xml tag value of a column in XSD format in BIP xlsx report output and there is requirement to show this column data in more readable format and not in XSD format. Kindly looking for your input on the same. Note - I am using RTF template to design this report. Below is the sample column value in XSD format:…
-
Conditional region functionality in BIP report
Many of the times customers wants to duplicate some of the excel reports just with some columns being excluded. can we get functionality like conditional region to hide some columns in excel report.
-
In an RFQ, formatting Line Column to Number
In an Rfq, when sorting by the LINE column, the application sorts as if it were text and not as a numeric field. This makes it difficult to query RFQ analysis with many lines. I want to suggest formatting Line column to Number. Actually: 1 10 100 101 102 Suggested: 1 2 3 …. 10 11 12 … 100 101 102
-
Ability to burst output file from BIP Report to OCI object storage
We have a requirement to burst output files of BIP reports to the OCI object storage buckets. Currently we have only Email, FTP, Content Server etc., delivery options supported in bursting logic, but don't have any delivery option that supports delivery to Object Storage bucket. We need a direct Object storage delivery…
-
Item/Document/Change Attachment Size
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Roche Description (Required): Oracle Fusion Engagement Cloud Service - Version 11.13.20.01.0 and later Implement the ability to retrieve the file size of attachments directly from the Oracle…
-
Is it possible to schedule a BICC job to run twice in a day? If yes, how can this be achieved?
Summary: My goal is to schedule a BICC job to run twice in a day but turns out its not possible to have 2 active schedules for a job Content (please ensure you mask any confidential information): Is this possible to achieve? Version (include the version you are using, if applicable): Code Snippet (add any code snippets…
-
Is it possible to schedule a BICC job to run twice in a day? If yes, how can this be achieved?
Summary: My goal is to schedule a BICC job to run twice in a day but turns out its not possible to have 2 active schedules for a job Content (please ensure you mask any confidential information): Is this possible to achieve? Version (include the version you are using, if applicable): Code Snippet (add any code snippets…
-
Moved: OWASP Standards compatibility for OAS and Siebel application
This discussion has been moved.
-
Show Analysis Prompt values in scheduled reports (agents)
Description Show the prompt values in scheduled reports (agents) Use Case and Business Need I have a few reports with variable prompts at the top of the analysis to show the user which prompts were chosen. When the report is scheduled through an agent the prompts do not show up on the report when the user receives the…
-
Reviewed - Show complete run history of an agent
Description I'd like to see all history of an agent as recipients come to me at times saying they did not receive their scheduled reports. I can only see last run. I like to look at history to troubleshoot. I'd like to see where the report agent was used to run automatically and where the report was run manually by…
-
Ability to have a multiple selections within a table prompt in otbi report
Use Case and Business Need Hello, We really need a way to have a multiple selections within a table prompt in otbi report (not a dashboard) thanks a lot Original Idea Number: b02ccfc077
-
Ability to connect to Fusion OTBI Subject Area's from Oracle Analytics Cloud.
Description Direct access to Oracle Fusion cloud OTBI subject areas, Financial Reporting Studio from OAC to create Transactional reports as well and make OAC as a consolidated reporting store. Use Case and Business Need At present users have to connect to different application’s to access BI Reports, especially while…
-
Form Factor Monitoring (Analytics with respect to PC based traffic vis-a-vis Mobile based traffic)
Organization Name OYO Description We need information from which device (Laptop, Mobile or Tablet) the user has logged in to the Oracle HCM application. If the application login was via Mobile or Tablet, was it through web browser (m-web) or mobile app? From which table can we track/fetch this information? Use Case and…
-
How to fetch Audit log reports for standard entities in OTBI
Organization Name LandMark Description How to fetch Audit log reports for standard entities in OTBI Use Case and Business Need Replicating the Siebel Audit Log report for any change in Email address and Mobile number in Contact entity and Status, Owner and assigned date in Service request entity More details Unable to find…
-
Provide Innovation Management Security Views to support role based data access within custom query B
Organization Name Williams Description Customer needs the ability to support role based data access with BI Publisher reports that contain custom SQL queries. This is usually provided through special security access tables that are joined to the custom reporting SQL. Should behave similarly to MOAC security views for…
-
Allow Turnover Reporting by Actual Termination Date in Workforce Management - Workforce Trend Subjec
Organization Name Alkermes, Inc Description Currently, the Workforce Trend subject area aggregates turnover reporting by the assignment effective date of the termination date and not the actual termination date. On the last day of the month or year, this causes the terminations to be counted in the wrong measurement…
-
We need the capability to print a single chart built in data visualization (DV) from an OAS/OBIEE da
Organization Name United States Sentencing Commission Description Currently we can print/export OBIEE/OAS chart build in Analysis from OAS/OBIEE dashboard. But we can't print/export chart build in Data Visualization (DV) from OAS/OBIEE Dashboard. Use Case and Business Need Our users require the capability to print a chart…
-
Enhance BIP Content Server Data Source to pull XML Files
Organization Name Ceridian Description The newly added, and Oracle configured & support BI Publisher ‘Content Server’ Data Source type can only pull text files from the Fusion Application Content Server. The ‘HTTP Connection’ Data Source type can be used to pull XML files from the Fusion Application Content Server. The…
-
Enable Evaluate Functionality in OTBI
Organization Name Hitachi Vantara Description Hi Team, There are many business requirement based on grouping where Evaluate is the only db function to achieve them. Because of many limitation we are bound to use BI Publisher report. Request you to kindly enable Evaluate db functions in OTBI Analysis. Regards, Kalyani Use…
-
Add Customer Account Number to OTBI Financials Subledger Accounting Journals Real Time subject area
Organization Name Northumbria Healthcare NHS Foundation Trust Description The OTBI subject area 'Subledger Accounting - Journals Real Time' currently has no field for the bill to customer account number for receivable transactions (it is available for receivable receipts), I would like a mapping from this subject area to…
-
Ability for joins beyond inner for excel data set to SQL data set
Organization Name University of Kansas Description Reporting users are finding the limited ability for inner joins only from the UI when creating a link between imported excel file data set and SQL data set to be problematic. Use Case and Business Need Outer join for excel to SQL data models. More details Records are…
-
Proxy / Impersonator login using SSO
Organization Name Deloitte Description Currently the issue, is that if any user wants to login to another user with Proxy, then the user is required to login with credentials only. It does not support SSO. So if user logs into application with SSO, switches to the proxy user, the screen forces for confirn password. However…
-
Automate the entire configuration required for sending e-invoice for a customer in collaboration mes
Description Need REST API or webservice to assign the B2B trading partner to a customer account in Manage Customer Account Collaboration. This is one of the required setup to send e-invoice (xml format). With this step we can automate the entire configuration required for sending e-invoice for a customer in collaboration…
-
TabDescription ColDescription ColPos not populated in BICC Metadata (MDCSV) file
Organization Name Ricoh Europe PLC Description We have populated Matadata for a set of PVOs. We have found below column information are not populated in the MDCSV file. Column List are below- TabDescription ColDescription ColPos We need this 3 columns to be populated to carry forward further processing and push the data…
-
'Signer Address' column in Checklist Real Time Subject Area
Organization Name Schneider Electric Description We are trying to leverage Checklist Real Time subject area to develop reports on the onboarding checklists. Is it possible to get the signer address (IP address of the employee signing the native electronic signature type task)? Use Case and Business Need We need to develop…