OTBI
Discussion List
-
How to know whhat are the data access and role needed for consulting a BI report with project tablesSummary: Hello, can some one help me with this? The business wishes to know if it's possible for anyone within the organization to view a report made with project tables… -
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli98 1.1K views 12 comments 1 point Most recent by Nareshbabu Mallela Reporting and Analytics for ERP
-
Query returns values but when passed as a pram trucates other prams in OTBI PPM custom report.Summary: Query returns values but when passed as a parameter trucates others in OTBI PPM custom report. Content (please ensure you mask any confidential information): We… -
Segment related PVOs not visible in BICCSummary: There are segments created in Fusion (GL#) and all the required jobs to extend the OTBI are executed. However after the execution it is visible in OTBI for repo…Vedasubramanian Muthuswamy 51 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Payroll Transfer statusContent Hi All, We are trying to display "Payroll Transfer Status" in OTBI and we are referring "Workforce Management - processed Time Cards Real Time" "Processed Time E…
-
Calendar Quarter column formatSummary: Hello, Could you please let me know how to change the format of column "Time"."Calendar Quarter" in OTBI subject area "Workforce Management - Workforce Trend Re… -
Learning records report for a Line Manager including not only Direct but also Indirect subordinatesSummary: Content (required): Hi there, i cannot find an answer to the above question. We have line managers who want to see the learning completions of the direct report… -
Sale order PDFSummary: Hi Experts, We need to create custom layout for Sale order PDF. for that i done see the option to copy or duplicate the XML file. how have the custom layout for…
-
Column Formula to get bi-weekly salarySummary: I need to get the bi-weekly salary of the employees, dividing the annual salary by 26 ( pay periods). Content (please ensure you mask any confidential informati…Ayesha Iroshani 31 views 2 comments 0 points Most recent by Anna-MariaP Reporting and Analytics for HCM
-
Comment Attribute within the Report a Course Report (OTBI)Summary: Content (please ensure you mask any confidential information): When a learner goes into learn and reports a learning item, a report is generated in OTBI and sen… -
Restrict otbi for manager to get only reportees details when logged in as ManagerSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
How do you compare columns in a formula when the columns are in two different subject areas?Summary: Specifically, we are trying to compare the resident state (from Person Real Time) to the Worked State (from Calculation Cards Real Time - Location). I'm able to…
-
SQL Report Filter for Previous_MonthSummary: I am trying to create a filter in my OTBI report that will return Pay Date results from the Previous month. Any suggestions? Content (please ensure you mask any…
-
Privileges/Roles to access the Reports and Analytics Work areaSummary: Content (please ensure you mask any confidential information): Hi experts, I'm working with a custom job role that should be able to access the Reports and Anal…Elena_Panniello98 246 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM
-
Error: EL expression isn't correctCreated one custom role for the purpose of quote creation. Need to change Create Order to Create Quote in sales Order, but EL Expression is Not working. -
Learning Evaluations CommentsSummary: We have an OTBI Report developed using Learning Records Real Time subject area to show questions and employee responses. We are unable to show the comments ente…
-
How to archive entire catalog (Shared and Users)?Summary: With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T o… -
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe…Mansur Khalil 332 views 4 comments 0 points Most recent by Alon Hadar Tamir Reporting and Analytics for HCM -
ORC:Date of Probity, Date of Interview, Date of review fields in Subject AreaSummary: Currently there is no any subject area available in ORC to get details directly against Date of Probity, Date of Review, Date of Interview and other phases. can…Siddhesh Nisal 21 views 4 comments 0 points Most recent by Siddhesh Nisal Reporting and Analytics for HCM -
Extract completion percentage of a video/scormContent Hello, We want to extract the completion percentage of a video or a scorm. In particular, we want to extract the number of minutes for which a video/scorm is see… -
table to get self service links for LMS courses in oracle hcmHi Team, We need a table name to get the LMS course and offering links in BI reports Thank you
-
We are facing issue on Manager Hierarchy. In the system it's fine but in outlook and teams wrongSummary: We are facing issue on Manager Hierarchy. In the system it's fine but in outlook and teams wrong manager showing Content (required): Wrong manager showing in ou…
-
Reporting feasibility in Learn for skill gap and user activityHi all, Client has a requirement where they would want to have a report in Learn module on- Skill gap report - This report should have skill assessment scores and identi…
-
R23 ERP OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 ERP OTBI subject areas to database tables mapping spreadsheets, R23 SCM OTBI subject areas to database tables mapping spreadsheets and …Mike.Myers.CDIPRODUCTS.COM 276 views 1 comment 0 points Most recent by Mike.Myers.CDIPRODUCTS.COM Reporting and Analytics for ERP
-
Effects of having high character length value set associated to an EFF attributeSummary: The value set of maximum character length needs to be associated to an EFF attribute. Would like to understand if this can have any negative impacts on the repo…
-
How to link transaction adminstration Real time with worker assigenment Subject area ?Summary: HI Team, We have need to track the all transactions in hcm of : Change Location, Change Manager, DeleteAssignment Promotions ResignationTransfers. with worker d…AjayKumar Maddipati 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SQL Query Tax Rate of purchase Order At line levelDear All, I'm currently encountering an issue while attempting to query the tax of a purchase order at the line level. Upon inspection, I've noticed that the fields "tax…
-
How to: Translate BI Publisher Report Parameters at 24ASummary: How to: Translate BI Publisher Report Parameters at 24A Content (please ensure you mask any confidential information): Version (include the version you are usin…Ishtiaque AHmed 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM