OTBI
Discussion List
-
OTBI error - Error during query processingSummary: We have an OTBI report, pulling from 2 subject areas — Workforce Management - Work Relationship Real Time and Workforce Management - Person Real Time. Our HR us… -
How to remove the restriction preventing a user from accessing data within an OTBI report.Summary: I have a dashboard containing multiple reports. While the user can access some of these reports, others display errors such as "view error" or "error getting dr…Omran Zeaiter 61 views 4 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for SCM
-
What is the link between Sales order and Discount list through SQL in oracle fusion?Hi All, In my project we have done a customization on Discount lists setup which will apply on the sales order based on Attribute Matrix rules. Ex: so we have added a co…
-
How to disable Export -> Data in selected OTBI reports?Summary: Hello, Do you know how to disable Export -> Data in selected OTBI reports? When user clicks Export -> Formatted -> Excel, the report contains only columns that … -
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 312 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 32 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 22 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 421 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 61 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 12 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…