OTBI
Discussion List
-
Emedded dashboard (through Page Integration) without granting access to CatalogSummary: I need to make a report available to a group of HR users. These users are not HR Specialists per se, meaning they should not be allowed to make changes to perso… -
How to expose the Context Segment in the OTBI report ?We are using the Descriptive Flexfield "Person Allocated Task Attributes" (Flexfield Code: PER_PERSON_ALLOCATED_TASKS_DFF). This flexfield has Context Sensitive Segments…Irfaan Camaloodeen 31 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Busting OTBI Myths - Using Agents to BurstContentMyth: OTBI doesn't support bursting, this is only possible in BI Publisher OTBI provides bursting via agents. Create an analysis that includes the lowercase compa…Julian Challenger-Oracle 586 views 19 comments 10 points Most recent by RajGuru66 Reporting and Analytics for HCM -
Query to fetch Approvals Groups Across Workflow ModulesSummary: We need to update a workflow approval group. I’d like a query that shows, by module, every workflow rule that will be affected by this change. Exemple: Approval…
-
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
PER_EXTRACT_UTILITY performance in reportingSummary: Hi experts, quick question, is PER_EXTRACT_UTILITY faster than querying the actual table in BIP? e.g. we can use get_decoded_lookup to get the Meaning of the lo…
-
Where does the payment acknowledgement email come from and how to customize it?Summary: We recently set up a payment acknowledgment with the bank and have the payment file register with document detail email once the disbursement and acknowledgment…Nikki Reich 16 views 4 comments 0 points Most recent by Nikki Reich Payables, Payments & Cash Management
-
Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is ZeroSummary: Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is Zero , and notification was already sent in previous bursting ru…
-
Question marks appearing in custom eText outputSummary: Custom eText payment format in BI Publisher has question marks inserted into output. Content (please ensure you mask any confidential information): I have creat…
-
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …Sheetal VBCS 34 views 4 comments 1 point Most recent by Janitha Perera Reporting and Analytics for SCM
-
How can we migrate FRS reports in MYFOLDERSummary: How can we migrate FRS reports in MYFOLDER from one user to Shared folders by other user? As user 1 does not have access to paste the FRS reports to Shared Fold…SwapnilSurange1 61 views 6 comments 0 points Most recent by SwapnilSurange1 Reporting and Analytics for ERP
-
Combining Multiple Manufacturing Subject Areas in OTBISummary: We need to create a single OTBI report by combining data from the Manufacturing – Work Order Performance Real Time and Manufacturing – Work Order Definitions Re…
-
BIP Bursting LimitHi all, Hopefully a very quick one. Is there a limit at all to how many emails can be bursted out of BIP? I can't seem to find any documentation online so wanted to ask …
-
Requisition Creation Date and Requested Delivery Date in OTBISummary: We are creating an OTBI report using the Procurement – Requisitions Real Time subject area. We need to include the following columns in the report: Requisition …Sudheer Vidiyala 40 views 1 comment 0 points Most recent by Porfirio Benjamin Rodriguez Miguens Purchasing
-
BICC Deprecated PVOs for 26CCould you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test en… -
Current Date Agent Set UpSummary: I am using Workforce Assignment Real Time and Workforce Relationship Real Time. An agent provides the data. Because the agent exports rather than pulling the cu…
-
Folder permission in OTBI "Resetting?" - "Enterprise Scheduler Job Application Identity for HCM"Summary: Good Day, We have a number of Custom Folders within Shared Folders - Custom where for some reason the "Accounts" "Permission" on specific user on each folder ke…Clifford Trett 597 views 1 comment 0 points Most recent by Lydia Jayasingh Reporting and Analytics for HCM -
How to get a data secured Job Requisition report in ORC?Summary: We need an Oracle Recruiting Job Requisition report with Job Offer status/progressing information if the Requisition started the offer process, which will publi…Meme 0101 164 views 4 comments 0 points Most recent by Shashi Kant Kumar Reporting and Analytics for HCM
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26CSummary: Hi, Can anyone please share R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26C release Thanks, Content (please ensure you …
-
bulk Update/Creation of Customer Contact Points (Emails) - FBDI, API, or Spreadsheet?Hello Community, My client requires a way to update customer contact points in bulk, specifically by creating new email addresses for their existing customers. I need to…Patrick Chrabieh 240 views 2 comments 0 points Most recent by David Wright - More4apps Receivables & Collections -
Redwood Purchasing Landing Page - Seeded KPIs and OTBI Analyses AvailabilityHi All, I'm implementing the new Redwood Purchasing Landing Page feature and trying to add KPIs to the Visualization Configurations page. When I access the configuration… -
How to create custom filters and infolets in redwood screenSummary: How to create custom filters and dashboard in redwood Content (please ensure you mask any confidential information): We are looking to create several other filt…Abhishek Kumar Ranjan 175 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Maintenance
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 672 views 7 comments 0 points Most recent by Kamalnath V Reporting and Analytics for HCM -
Printing the XML for Purchase Agreement Report PdfSummary: I need to print the XML for the Purchase Agreement Report PDF. I have created a custom folder, ensures that this report is in the correct directory, changed the…
-
How to get the details of action items which are denied?Summary: Need details of the action items which are denied along with their denied date Content (please ensure you mask any confidential information): We have a requirem…anirbanchatterj7 35 views 0 comments 0 points Started by anirbanchatterj7 Reporting and Analytics for HCM
-
What Subject Area provides access to Contract Billing Controls (Soft/Hard Limits)?Summary: OTBI Reporting of Contract Billing Controls Content (please ensure you mask any confidential information): Looking to create an OTBI report that includes Contra…
-
OTBI - Need filter on from date to To date as sysdateSummary: Hi Team, we have requiremnt in OTBI to apply the filter(Completion Date) as From date is 1-04-2023 to TO Date is sysdate. thi is the the is colums of fomula : "…Maddipati Ajay Kumar 673 views 11 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How can we define. aba format file for payments?We have a third-party vendor who validates the payment file in ABA format before a payment file is shared with the bank. So, our request is how do we generate an. aba fo…Veera_CPS 144 views 5 comments 1 point Most recent by NayanajithG Payables, Payments & Cash Management