-
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…
-
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:…
-
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…
-
Query or report on ESS request scheduling information
Description Database views FUSION.ESS_REQUEST_HISTORY as well FUSION.ESS_REQUEST_PROPERTY do not seem to include actual request scheduling information (eg every 2 hours) Use Case and Business Need We have so many scheduled ESS processes that we need a way to report a listing of all scheduled ESS processes including…
-
Name format HR - CX prefix not in datatable
We noticed that the prefix is not filled in the data tables, see below example: HR FIRST_ NAME PREFIX LAST_NAME KNOWN_AS (Roepnaam) TITLE MIDDLE_NAME SUFFIX Wilhelmus van Nassouwe Willem In HR the name is build as: KNOWN_AS PREFIX LAST_NAME > Willem van Nassouwe CX TITLE FIRST_ NAME MIDDLE_NAME LAST_NAME SUFFIX Wilhelmus…
-
OTBI analyses on shipping Real Time Subject Area does not display correct Fulfillment line
For split lines Fulfillment details are not cauputed correctly. Currently only Shipment lines are captured based on the Shipment Id. On the SR raised SR 3-36563504801, I was informed that it was verified during OWC, It's kind of requirement. Summary: ======== 1.Customer using OTBI reports for shipping Real Time Subject…
-
RESTRICT ApplicationDB_HCM data source in BI data model creation
Use Case and Business NeedSecurity concerns if developers can query the HCM base tables and get sensitive information out of BI reports. Set of Users to be restricted to query the Base tables.
-
BICC - View Only role
I need your help regarding BIACM Admin role. So far this is the only role which provides access on BICC Console. This is a very powerful role and provide access to make changes. We are looking for a “view only” role to access BICC console. This role would be assigned to developers in test and prod instance. I had opened an…
-
Security concern due to visible password while calling "PublicReportService"
Organization Name King County Description OIC interface is calling the OTBI public report service SOAP wsdl "https://serverURL.oraclecloud.com/xmlpserver/services/PublicReportService?wsdl" OTBI is requiring the password as cleartext in the request payload and there is not going to be a secure solution for this use case.…
-
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…
-
OTBI Reports Cannot Be Restricted by Data Access
Organization Name Prospect Medial Group Description OTBI reports do not take into account data access when displaying results. We need data security to extend into OTBI reports. Referenced previously in :Bug.: Bug 30046426 - PAYABLES INVOICES - TRANSACTIONS REAL TIME NOT RESTRICTING BUSINESS UNIT Use Case and Business Need…
-
Ability to "select all" participants in recruiting booster event audience
Currently Oracle only allows users to check one box at a time to take action on each event attendee. For the purposes of Recruiting Booster events, the list of event attendees is extensive, making moving candidates into a candidate pool a tedious task (having to check one by one). It would be great if Oracle added a "check…
-
Report that provides notification details for archived transactions
I'd like a report the will provide notifications details for employee actions that have been archived similar to the reports found in the Human Capital Management>Workflow Notifications folder in OTBI. Being able to retrieve notification details for archived transactions in this way will assist with yearly auditing…
-
Target Incentive not working properly for students conversions
When we hire students in ORC, they are initially hired without being eligible for incentive. Later, if we want to convert the students to full time employees, even if we activate the target incentive in the offer, in ORC, Target Incentive still show as 0 instead of a percentage. Solution: Target Incentive in ORC should…
-
Not able to find the free text Characteristic details in Quality Action Rule Notification message.
Not able to find the free text Characteristic details in Quality Action Rule Notification message.
-
BI Cloud Connector - Missing Source data and EFFs not available in existing PVO
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Darigold Inc., Description (Required): We are currently implementing ERP, Supply Chain, OTM and WMS Cloud foot print at Darigold and building various integrations with EBS and other third…
-
View Adjustment from Receipts screen
In EBS we have an option to view all adjustment made on the respective invoice directly from the Receipt screen. In Fusion do we have such feasibility to check all the adjustment made on the invoice from the receipts screen? Attached a document contains detail of requirement along with comparison of EBS & Fusion. We…
-
JournalBatchPVO is coded incorrectly
Organization Williams the following Oracle PVO "FscmTopModelAM.FinGlJrnlEntriesAM.JournalBatchPVO" is missing an outer join between GL_JE_BATCHES.CREATED_BY and PER_USERS .USERNAME this outer join is coded correctly when joining to get last_updated_by if you review the attached code "AND V26406376.LAST_UPDATED_BY =…
