OTBI
Discussion List
-
How to join Procurement - Procure To Pay Real Time and Enterprise Contracts - Contracts Real TimeHi Team, I am currently working on joining the below two OTBI subject areas, but I am unable to establish a proper join between them: Procurement - Procure To Pay Real T… -
OTBI Dashboard Prompt Default TimeHi, I am trying to set a dynamic value for Calendar Year in an OTBI Dashboard Prompt. I am using the "Recruiting - Recruiting Events Real Time"."Time"."Calendar Year" co… -
We need to map segment labels to the existing Chart of Accounts Segments for OTBI reportingCurrently, a few GL segments in the Chart of Accounts are not available in the OTBI reports. We have already gone live and started using these chart of accounts segments…Venkata Gadiraju 11 views 2 comments 0 points Most recent by Venkata Gadiraju General Ledger & Intercompany -
Unbale to see Context DFF in OTBI Procurement -Purchasing real time Subject areaSummary: Hi All, We have created below context DFF at PO Line level But we are Unbale to see Context DFF in OTBI Procurement -Purchasing real time Subject area,adter dep… -
How to report when a pay batch was approved in Incentive CompensationSummary: I need to create a report for a weekly integration that only will pass data for pay batches that were approved during current week. "Last updated date" is too u…Justine Klemetson 1 view 0 comments 0 points Started by Justine Klemetson Reporting and Analytics for ERP -
What reporting options are available for Role Guides beyond the standard UI views?Summary: What reporting options are available for Role Guides beyond the standard UI views? Specifically looking for OTBI subject areas or delivered reports that support…Career and Skills Product Manager 2 views 0 comments 0 points Started by Career and Skills Product Manager Learning -
HR Help Desk Infolets "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no dataSummary: Hi, I have a question about HR Help Desk Infolets. "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no data and I am trying to understand wh…Viktoria Priona-Oracle 41 views 2 comments 0 points Most recent by Shelleyyo Reporting & Analytics for Fusion Service -
OTBI Report Issue - "Compensation - Workforce Compensation Real Time"I am currently building a report using the “Workforce Compensation – Real Time” subject area in OTBI. My objective is to retrieve basic employee details along with their…Abdul Raqueeb 31 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea…notautomni9 1 view 1 comment 0 points Most recent by Julia Kiszelewska1234 Reporting and Analytics for HCM -
How to get order details from the charts on OM Redwood page?Summary: We have created a visualization chart on the Order management Redwood page. Now when we click on the charts on the classic page, we are able to see the details … -
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include … -
Any ideas why a previously working OTBI report would now be showing this error?Summary: I have a report that is supposed to return the start date and expiration date of a validity period that was previously working. However upon logging in, the rep… -
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development…Raghavendra Raghunath-Oracle 48.5K views 198 comments 130 points Most recent by MazCham Reporting and Analytics for HCM -
Is there a filter/prompt/SQL or a report for a daily dashboard for HR Helpdesk for new/close SRis there a dashboard available or report, or any sql/filter/prompt I can use for OTBI in order to get a daily dashboard for HR Helpdesk queries specifically looking for … -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…Roohi Syed 4.1K views 6 comments 0 points Most recent by SUDERSHAN PRASAD TIWARI Reporting and Analytics for ERP -
How to keep my oracle account active after changing companies?Summary: Hi Team, How to keep my oracle account active after changing companies? Thank You, Ajay Content (please ensure you mask any confidential information): Version (…AjayKumar Maddipati 21 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Report for Current Invoice ApproverSummary: I am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver. For the most part, I have been ab…Neal Foley 661 views 13 comments 1 point Most recent by Sridhar_Rejeti_1423 Payables, Payments & Cash Management -
in the account analysis report when the category payroll the line description is blankedSummary: in the account analysis report when the category payroll the line description is blanked, from where we can fill the data for Line description Content (please e…Mohammad Merie 4 views 0 comments 0 points Started by Mohammad Merie Reporting and Analytics for ERP -
Inventory transaction number in Inventory Transactions real time Subject areaSummary: Please suggest how to get the Inventory transaction number in Inventory Transactions real time Subject area Content (please ensure you mask any confidential inf… -
How to search/ filter two columns with single Table Prompt in OTBI analysisProblem: There is a business requirement to search Bank Account Number (which can be set up either at Customer Account level or Customer Site level) using single Table P…CA Nirmal Choudhary 11 views 1 comment 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP -
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries… -
I need to understand how to monitor and audit user access to subledger journal transactionI need to understand how to monitor and audit user access to Financial Accounting Hub (FAH) subledger journal transaction details. Track and report who has accessed or v…sunil_bhatt comcast 2 views 0 comments 0 points Started by sunil_bhatt comcast Subledger Accounting & Accounting Hub -
Unable to pull the pull the complete parent hierarchy chain through OTBI reportUnable to pull the pull the complete parent hierarchy chain (Parent Manager 01 to Parent Manager 05) for terminated cases through OTBI report Subject Area > Workforce Ma…Harpreet Kohli 32 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Employee Rating not fetchingSummary: I have issue with my performance rating analysis. I was able to get the Overall Manager Rating but it's not fetching the Employee Rating, Rating Level Name, Sta…Marilyn O 11 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
How to report on questionnaires attached to candidate in job application flow folderSummary: We have a questionnaire created (Candidate Survey) Subscriber: Recruiting; Questionnaire Library: Job application flow Content (please ensure you mask any confi…Clare Murtagh 22 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Scheduled agent is failedHi Experts, I’m hoping someone can assist me here. We have several agents scheduled that were running successfully. However, one of the scheduled agents has suddenly sto…Angela Nietes 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…