-
Ability to limit Export options
We have a need for being able to limit the Export As options from a Report. We would like to have Export → Formatted → , but not have Export →Data. I can see other variations of uses for limiting the type of file you would allow, such as PDF only vs. Excel.
-
Handling deletes when Using BICC to extract PVOs
We are currently using BICC to extract FSCM, CRM, etc. data to build a data warehouse for analytics. Noticed that BICC Application Data Extracts only captures updated and new records, but doesn't capture deletes. Full table loads is not a sustainable solution as the data continues to grow. We figured that Active Primary…
-
Functionality to Populate Blank Fields on the Item Operation on Workorder via EAM OFS Accelerator
Ability to populate all "blank" fields on the Item Operation line. The Item Operation field should be populated based on the VMRS in the Item master. Item Operation Field: Repair Transaction Code Attached screenshot from EAM Note - this field is not included in the accelerator as of today
-
How to add custom objects From CRM module into OTBI
An custom object(custom api) was build in cloud Solicitation modules, we want to extract the data from the custom object into on prem data warehouse and also add this column into existing OTBI subject area. This custom api stores the data into hz_ref_entities table. Is there an View object for this table?
-
Pricing VOs missing in BICC & OTBI - QP Pricing tables mapping not avail
Organization Name Archrock Services LP Description Looks like the pricing tables do not have the related VOs mapping in OTBI. It really helps for creating pricing reports with VOs. QP_CHARGE_DEFINITIONS_TL QP_CUST_PRICING_PROFILES QP_DENORM_MATRIX_RULES_VL QP_DISCOUNT_LIST_ITEMS QP_DISCOUNT_LISTS_ALL_B QP_DISCOUNT_LISTS_TL…
-
Enable OBIEE location-alias with Action Navigate to a Web Page
Organization Name Gibson, Cohu, many others Description Cloud OBIEE - OTBI - requires hard coding the URL for Action Navigate to a Web Page. This means that when we create a report with deep links to Objects in Cloud SAAS, the URL for the POD is hardcoded. When moving reports from DEV to TEST or PROD, or when cloning Prod…
-
Possibility to freeze column on BI Publisher Interactive report
We would like to have a way to freeze the first few columns. On many reports screen is not sufficient to show all the data. So user need to scroll to the right (left) to see all the columns. We would like to freeze first few columns so user will not loose the context while viewing the data.
-
Allow for Custom Transaction Sub Types in Budgetary Control
We would like to have the ability to have custom Sub Types in the Budgetary Control Module. Documentation provided showed that via an API you could populate the Sub Types with Custom Values (Temp vs Perm) and while you are able to do it, the reporting in FDI and OTBI doesn't allow for custom sub types to come through via…
-
Making Business Unit as a secured Dimension so that users can see only those BUs to which he has acc
Organization Name G4S PLC Description Hi, Right now, if we create a prompt for Business Unit in OTBI report, the user who runs the report can see all the available BUs in the system in the LOV, regardless of whether he has access to them or not. We want to restrict the values to only those BUs to which the user has data…
-
Maximum Total Amount Hold is not working incase of PO Invoice in Functional Currency.
Hi Team, As oracle confirm that Maximum Total Amount Hold is not working incase of PO Invoice in Functional Currency and Po line type is "Fixed Price Service" Oracle does not provide any justification that why it not part of standard functionality. Oracle note stated that as confirm by Product Manager but does not has any…
-
Custom fast formula based start date and end date for Individual Compensation Plan (ICP)
Currently ICP supports only few payment start date and end date options. One common requirement we see is to derive the automatic payment start date and end date based on other attributes so we requesting to add capabilities to derive the custom fast formula based payment start date and end date. We have savings plans…
-
Ensure Hidden Columns stay Hidden in all Report Formats
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Mary Kay Description (Required): When building a report in OTBI, you have the option to hide columns or exclude them from a table altogether. This removes the columns from the 'Formatted'…
-
Department Name is missing in Run Periodic Payroll Register Report
Before Oracle 24A patch, Run Payroll Register Report was having department information in the XML. But the new seeded Run Periodic Payroll Register Report does not have department information in the Data XML. This information is needed for department wise data validation.
-
How to make DFF mandatory based on Invoice Distribution segment
Business Requirement Three DFF fields are mandatory from a business perspective for any SCA transaction IF Fund code 12000) used at Invoice distribution. ULO Agency Acct no/project code Agency reference These data are currently captured in DFF fields, which are not mandatory in the system. Therefore, the business…
-
Need Attribute fields (DFF) for table PO_HEADERS_ALL in PO Header Level BICC PVOs
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Ville de Montréal (City of Montréal) Description (Required): Need ATTRIBUTE columns, or Descriptive FlexFields (DFF), added to the following BI Cloud Connector View Objects :…
-
Archival of ESS_REQUEST_HISTORY needed before purge
Description Our client Titan International has a requirement to archive the records of ESS request history before purging them. Titan has more than 150 custom and seeded jobs and want to retain the request history (irrespective of status) to some alternate table. Critical programs such as program to send out EDI ASN is…
-
Mail settings / SMTP Set Up
Organization Name Nexinfo Solutions Description Hello All, I believe we should be having an additional set up in the Fusion application for SMTP. Which allows the client to set up their IP address, so when an email is sent, it should be sent from Client domain instead of Oracle Fusion Cloud. Thanks Shiva Use Case and…
-
Need functionality to schedule BI reports with Bi-weekly or every 2 weeks option
Description Current functionality does not allow bi-weekly option. Use Case and Business Need Currently we can only schedule any BI reports with daily, hourly, weekly, monthly, Annually and specific dates. There is no way to schedule biweekly. We are using custom dates for bi-weekly option but it would simplify if we can…
-
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
-
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.
-
OTBI Subject Area for Lease Accounting Revenue and Expense Lease
Hi Client has reporting requirement around Revenue leases. There is just one relevant seeded report available for Revenue lease.
-
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…
-
Column wise BIP report with colors - Vertical format
Requirement: Develop a BIP report in fusion ERP to display all month’s data in Columns (Vertical) format for the selected year in excel/rtf template. Highlight the data in different colors based on specific criteria. Approach: Report Layout: Develop data sets for each month in BIP Report, prepare Excel/rtf template in BI…
-
Ability to create multiple static cubes of different dimensional structure in single pod
We have a requirement to save a copy of every year Archive cubes and the structure should be static. Since we have static archive cubes from FY12 to Current and it grows each year, it is hard to maintain each archive cubes in each POD instead we are looking for EAS kind of setup where users can access archive static cubes…
-
Move the ability to modify current subscriptions for Agents to BI Author
Currently the ability to create agents, publish agents for subscription, and chain agents are all set at the BI Author level. This is great as it allows the users access to work with the agents without needing access to the BI Administrator role. The BI Administrator role is not a role you want to give access to many…
-
Ability to create multiple static cubes of different dimensional structure in single pod
We have a requirement to save a copy of every year Archive cubes and the structure should be static. Since we have static archive cubes from FY12 to Current and it grows each year, it is hard to maintain each archive cubes in each POD instead we are looking for EAS kind of setup where users can access archive static cubes…
-
Call Attachment From UCM server by passing document ID in BIP Report
We have requirement to print an Image in PO PDF for which we have stored the images in UCM server. The document ID's are stored in FND_ATTACHMENTS table in Fusion and by passing that document ID we need to get the attachment and display in RTF Template.
-
CKHH-CK Hutchison Holdings Ltd-Send Notification to Approver when Spend Authorization is Withdrawn
Hi, We want to request that the Spend Authorization Approver (expense module) receives a notification whenever a submitted Spend Authorization is Withdrawn/Closed. Currently, the Approver does not receive a withdrawal/close notification. This requested feature lets the Approver know that a Spend Authorization has been…
-
Workforce Profiles - Model Profile Real Time - Add Additional Sections to Subject Area
The 'Workforce Profiles - Model Profile Real Time' Subject Area is lacking in expected areas that are found on the Job/Position Model Profile Pages. Request - Add the additional sections below so we are able to pull all data in OTBI reports: Workforce Structures Job Description Job Responsibility Job Qualifications etc…
-
Support Narrative Report / Management Report Snapshots (PDF formatted files) in EPM Navigation Flows
There is currently no support for Report / Book snapshots (PDF formatted files) in Management Reports (MR) and Narrative Reports (NR) in EPM Navigation Flows and the only option is to add them as Web URLs in Navigation Flows. It is most desirable to be able to navigate and select PDFs from MR/NR folders (local or remote…
