OTBI
Discussion List
-
OTBI Leave Learner on Report with Empty Completion Date?Summary: I have a OTBI report with a list of team members. All team members are required to complete Course A. Some have completed it and some have not, nor have they be… -
HCM secured views - listHi, Can you please suggest where can I get all the list of secured views for HCM? Thanks in advance. Version (include the version you are using, if applicable): 24C -
OTBI BIP - Secured List Views for ERP and SCMSummary: With reference to the Fusion BI Publisher - Fusion Security in BI Publisher Data Models - Secured List Views SLV (Doc ID 2708546.1) - (Refer the document sectio…Kumar.Eswaran 333 views 2 comments 3 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Is there a way in BIP PL SQL to retrieve where the transaction has been done?Hello Experts, for example, the transaction was done in Me Tab, then PL SQL will tell that this is Me tab page, or in a My Team page. I am currently creating a transacti…Joliver Caangay 1 view 1 comment 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM -
My approved invoices OTBI reportHow do I default in an OTBI report invoice approver to be the User running the report? Or at least have in the drop down list only value available my name (the name of t…Julia Kang 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Create OTBI Report for Project with it's Expenditure Type and costSummary: Title: How to Create an OTBI Report in below Table Format for Projects Hello Oracle Community, I’m looking to create an OTBI (Oracle Transactional Business Inte…Karthik Selvaraj 31 views 1 comment 0 points Most recent by sambasivarao kosuri-Oracle Project Management -
Report that show what OBTI Analysis is being used with each initiative?Summary: We need to audit our initiative and OBTI analysis. Is there a report or can someone provide the criteria for a report that will show all the initiatives that ar… -
Change OTBI Analysis PathSummary: Change OTBI Analysis Path Content (please ensure you mask any confidential information): We are planning to change the learning analysis folder path in the foll… -
BI query as list of values for a dashboard promptHello, We have a request to create a prompt with the names of employees based on a given job title. To access the data in the subject area "Security - Roles and Privileg…Varun Dhondea 51 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
24D OTBI Skills CentreSummary: In 24D is there a way to pull out the full list of skills in the dynamic skills centre in OTBI? Including statuses and grouping? Content (please ensure you mask… -
IP address when an employee completes a courseSummary: Please let us know if there is a way to capture the IP address when an employee completes a course or any where in table the IP address is captured when employe… -
Can anyone please share the best practice to create BIP Report template having more than 50 columnsSummary: Can anyone please share the best practice to create BIP Report having more than 50 columns I have a requirement to develop a BIP report having 54 columns and he…Kundan Kumar17 21 views 0 comments 0 points Started by Kundan Kumar17 Reporting and Analytics for HCM -
What is the Subject Area to fetch Item Additional Attributes (Descriptive Flexfield)Summary: I am developing OTBI report to validate Item Impot - post Item Import validation. Able to get all Item attributes except Additional attributes (DFF) Could Anyon…Jayaharan Krishnamurthy 42 views 3 comments 0 points Most recent by Sam Bandara Product Master Data Management -
report for tax rates by jurisdictionWe are looking for a report for tax rates by jurisdictionCindy Souvagis 31 views 2 comments 0 points Most recent by Cindy Souvagis Reporting and Analytics for ERP -
Difference between Fixed Asset Descriptive Flexfield and Asset Key FlexfieldSummary: As per my understanding, both asset key and descriptive flexfield can be used for storing any additional information. I would like to understand the major diffe… -
Is it possible to report on Alert History?Summary: Need to see alert history in easy to read format Content (required): We have quite a few alerts running and would like visibility to what is sent and when to he…Janine Brown 422 views 10 comments 4 points Most recent by Murali Togaru Reporting and Analytics for HCM -
Report ParametersSummary: Facing 2 Issue in OTM Parameters 1-How to insert Fixed List as I tried to insert text value, but report didn't run and showed up error. 2-When inserting query i…Tag Ahmed Elsharkawy 62 views 10 comments 0 points Most recent by AkshayThakur Transportation Management -
How to link a parameterized BIP report into the OTM screenSummary: How to link a parameterized BIP report into the OTM screen Content (please ensure you mask any confidential information): we would like to link a parameterized …BALAJI K 11 views 1 comment 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
Merge Two OTBI Subject AreaSummary Develop a OTBI report by Merging two OTBI Subject AreaContent I have a requirement to develop OTBI report using two OTBI subject areas. Following OTBI subject ar… -
Asset Transaction Real time is not showing dataSummary: when I select Asset number and invoice number just these two columns from several folders of the above Asset subject area, report is not fetching any data, howe… -
Group Project Tasks by Task NameSummary Group Project Tasks by Task NameContent We have a standardized work breakdown structure and would like to compare costs for the same task across projects, right …Prasanna Reka-OC 38 views 1 comment 0 points Most recent by Cindi Jacobsen Reporting and Analytics for ERP -
Error using 'Upload Customers' FBDI, using OIC processthe error is: Processing Data File: ArUploadCustomers.csv Data files cannot be processed due to incorrect file name prefix. You must provide the Data Files having valid … -
Payables Trial Balance Report ESS Job Template changeSummary: Hi, User requested to create a template change for Payables Trial Balance Report, the ESS job. As this is an oracle developed report you cant make a template ch…aireyevan 51 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management -
How to use ASCII Values in OTBISummary: We are using this statement REPLACE(REPLACE("Document and Rating Details"."Rating Comments", CHAR(13), ''), CHAR(10), '') in BIP Report.How can i use the same s…Narendar-Oracle 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM