OTBI
Discussion List
-
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.1K views 198 comments 129 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 23 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 664 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 7 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 3 views 0 comments 0 points Started by sunil_bhatt comcast Subledger Accounting & Accounting Hub -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 91 views 16 comments 0 points Most recent by Jayanthi Shetty Reporting and Analytics for HCM -
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 34 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 15 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 23 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Question on Oracle Fusion User Activity AnalyticsHi Oracle Team, We wanted to check whether Oracle Fusion provides any user behavior analytics capabilities similar to Google Analytics. Specifically, are there any repor…SiddharthGupta 16 views 1 comment 0 points Most recent by SiddharthGupta Reporting & Analytics for Fusion Service -
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 25 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… -
OTBI - Retired Fixed Asset with Source Line DetailSummary: In Asset Transactions Real Time we would like analyze retired assets with the source line details (project number, invoice number,etc.). The source line detail … -
value set values exportSummary: Hi Team, We have defined a Asset key flexfield and would be loading 100 values on a daily basis, we would want to have a report to view the value set values add… -
Getting an error when trying to view standard Cost Management ReportSummary: Hi Team, While trying to view the Standard GRNI, Good Received Not Invoiced Report under the Navigation:- Shared Folder>Supply Chain Management>Cost Management>… -
how to get supplier tax country in OTBI reportwe would like to create an OTBI report to get supplier tax country and tax registration number, where can we find the supplier tax country? -
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 1 view 3 comments 0 points Most recent by lkratzberg Payables, Payments & Cash Management -
Report - Taxpayer IdentifiersSummary: I need to extract a report with the data from the Taxpayer ID field (Controls and Defaults) from both the Profile tab and the Addresses tab. I tried creating an… -
WIP Supply record error for WIP Component demand fileWhen loading WIP Component demand, getting this error - "You must provide a valid value for the WIP Supply record attribute." Attaching log file and loaded zip file for …Adish CA 32 views 8 comments 0 points Most recent by Yann Consolin-Oracle Supply Chain Planning and Collaboration -
Cant use the Oracle Analytics Publisher error "menu2007.logon"Hi installed in my machine the Oracle Analytics Publisher for word, but after install showing in tab "Publisher" in login "Menu2007.logon". I used this link to download …Felipe S. Rocha 230 views 4 comments 0 points Most recent by Yen Qualls Reporting & Analytics for Fusion Service -
Subject Area for Exit interview survey Responses --> Which Subject area to use ?Subject Area for Exit interview survey Responses --> Which Subject area to use ? -
Area of Responsibility subject area does not return latest changeSummary: We created a simple analysis to return AOR but do not get the latest change. Does the subject area return the same values as what's seen in the UI Content (plea…David Boudreau 1 view 4 comments 0 points Most recent by Nikhil Dugad Reporting and Analytics for HCM