OTBI
Discussion List
-
How do I source: profile item id for spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…Tina T 51 views 3 comments 0 points Most recent by Aditya Jena Reporting & Analytics for Fusion Service -
Link between WLF_ASSIGNMENT_RECORDS_F and HRC_TXN_HEADER tablesSummary: Link between WLF_ASSIGNMENT_RECORDS_F and HRC_TXN_HEADER tables. Content (please ensure you mask any confidential information): We have established a link betwe…ViswanadhK 41 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Top Employee Missing from HierarchySummary: Our top employee is not appearing in reporting when the organisation hierarchy is included in a report. Content (required): The head of our organisation current… -
OTBI - how to get the payables invoice details from General Ledger Journals Real Time Subject areaSummary: I am creating an OTBI using General Ledger Journals Real Time Subject area but I want to show payables invoice line description. I tried to add Payables Invoice…
-
Unable to load content into a self-paced activity via HDL .Summary: We are trying to load a self-paced activity using content that was previously created through the front end. However, an error occurs when we pass the content n…
-
How to extract course branding images?Summary: Client requirement is to migrate course branding images from one oracle instance to another. As far as i know, WLF_LI_IMAGES_F stores content id's for the brand… -
OTBI HCM Workforce Profiles and Counts (counts returning O's only)I thought this would be simple OTBI report, but am stuck on getting an accurate count (returns only zeroes). It should output active Profiles, their associated Job Codes…
-
Requirement for HR users to modify copies of reports for their useSummary: We have a client requirement for HR users with certain roles to be able to copy existing reports and then modify them for their own use cases. Content (please e…Alona Aronov-Oracle 12 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Getting Blank Data When Combining Multiple Subject Areas in ReportSummary: Hi everyone, I’m trying to create a report by combining fields from three or more subject areas. However, whenever I add columns from different subject areas in…Vaibhav Shingare 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Learner email within Workforce Learning - Learning Records Real Time subject areaSummary: Dear all, We have developed an OTBI report using the Workforce Learning - Learning Records Real Time subject area to monitor the progress of specializations. Wi… -
Report for Line managers to see proposed end of year ratings for all of their direct reportsSummary: We would like to know whether Line Managers can download a report that shows them the proposed end of year ratings for all of their direct reports so that they …VP Veena 11 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Remove Null value from Dependent LOV prompt in OTBISummary: When we creating dependent prompt using "limit by" option in the OTBI prompt, NULL value gets appended in the list of values. If user is running with NULL param…Sharmava 482 views 16 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Error While Grouping Requisition Lines During PR to PO Conversion via APIDear Experts, I am creating the PR from postman and submit for approval and approved that PR manually however I am create the PO heaeder as well after that when I am try…
-
Unable to identify the Pick slip status and quantity exception values in the backend tablesSummary: Hi CCC, I was trying to identify the Pick slip status - Open / Confirmed and quantity exception reason in case of short pick from the backend tables. I couldn't…VishnupriyaSelvakumar 11 views 2 comments 0 points Most recent by VishnupriyaSelvakumar Supply Chain Planning and Collaboration
-
Unable to get the price after made the revision of the Sales order.Summary: Dear, By using a revision option, we are trying to add the new line to a sales order that currently contains several closed or awaiting shipping lines, but syst… -
Areas of Responsibility - No Results when including Worker DataSummary: No Results is being returned when including any Worker data into an analysis for Areas of Responsibiltiy Content (required): We are creating an analysis using t…David Bean-259734 514 views 15 comments 0 points Most recent by Surendar Reporting and Analytics for HCM
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
Ways to securely send OTBI reports through agents?Summary What are the ways to securely send OTBI reports through agents?Content I think this has been asked a few times in the past, but just wondering what are the ways …
-
View Journal via Deep Link in OTBISummary: Is it possible to view a journal using a deep link in OTBI? Content (required): I was able to find the Journal Entry deep link (Journal Entry (XLA_SUBLEDGER_VIE…Njeri Macharia 391 views 2 comments 0 points Most recent by Aashik Datta General Ledger & Intercompany
-
DFF UniqIDSummary: Hi Team, tESTInstance/hcmRestApi/resources/11.13.18.05/recruitingUICreateOrUpdateJobOffers/{OfferId}/child/additionalInformationDetails/{additionalInformationDe…
-
Fusion procurement yearend process for POs with multi-year services. Other than manual change ordersSummary: Topic: Procurement year end activities for POs with multi year services Content (please ensure you mask any confidential information): Version (include the vers…
-
Download sample issue for the PVO in BICC consoleSummary: Below are the list of PVO's which are having the download issue for sample file 1.FscmTopModelAM.FosOrchestrationProcessAM.TransactionEventPVO 2.FscmTopModelAM.…Soare Oldrich Alexandru-Oracle 101 views 2 comments 0 points Most recent by Scott Leong Reporting and Analytics for SCM
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Lalit Sinkar 317 views 6 comments 0 points Most recent by Dairy Land Reporting and Analytics for ERP
-
Aggregate function in OTBI AnalysisSummary: Please share some documentation on using various aggregate functions on any column of an OTBI analysis Content (required): Need to use aggregate functions acros…Hem 421 views 2 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for HCM
-
Work Order Header Descriptive Flexfield not appearing in the OTBI Subject AreaThe descriptive flexfield segment is BI enabled , But after deploying the flexfield and running ESS: Import Oracle Fusion Data Extensions for Transactional Business Inte…