OTBI
Discussion List
-
Sample Oracle BI Reports for Spend Authorization RequestsSummary Dashboard for Spend Authorization RequestsContent This dashboard will allow you to view the following key details: * Number of spend authorization requests by St…Aishwarya Pawar-Oracle 64 views 2 comments 2 points Most recent by Conor Pewterbaugh Supplier Management -
Query to fetch Cost Center Details which are not mapped at Department LevelSummary: i need a query to fetch all cost center which are not mapped to the department. If anyone have SQL query please help me. Version (include the version you are us…
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
Missing Overall Feedback and Max Questionnaire Score in OTBIwe have a business requirement to report the Overall Feedback Score for each feedback provided in Oracle Recruiting Cloud using OTBI. We explored the available subject a…
-
Not able to view entire employees details in Subject area only able to view own recordSummary: i was able to extract employee details using Assignment subject area but now when I am using the subject area it is only displaying my data. I have all the role…
-
Supplier Portal Dashboard Not Working – Error: “The specified criteria didn’t result in any data”Hi, We are facing an issue where the Supplier Portal standard dashboard is not working and is not displaying any data in our instance. I have attached screenshots for yo… -
Need to display employee records transferred from Payroll to GLContent Hi All, We transferred the data from Payroll to GL. Now we need to display those records either in OTBI/BIP. Can you suggest do we have any subject area/BIP tabl…
-
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 183 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Enable Procurement Dashboard under Procurement tab in Oracle Fusion Cloud instanceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Security for OTBI Subject Area "Projects - Labor Distribution Costs Analysis Real Time"Summary: We need to expose OTBI queries written against the subject area "Projects - Labor Distribution Costs Analysis Real Time" to a larger population. Right now, it i…Jonathan Ruth 21 views 2 comments 0 points Most recent by Jonathan Ruth Reporting and Analytics for ERP
-
Does segment value security applicable to OTBI ?Summary: Hello, Recently i have enabled the Segment Value Security(SVS) for one of the segment and created roles and assigned to the specific users, now all other users …Dinesh Krishna Mamilla 21 views 1 comment 0 points Most recent by SankarBalu General Ledger & Intercompany
-
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma…
-
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma…
-
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 504 views 3 comments 0 points Most recent by User_B5NVV Reporting and Analytics for ERP
-
How to price Sales Order Lines in different UOMSummary: How to price Sales Order Lines in a UOM other than the Primary UOM (Each) Content (please ensure you mask any confidential information): We have a requirement t…
-
Need to get referrer Job Title and Referrer assignment status in OTBISummary: We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker p…Rama123-Oracle 11 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Date changes by1 day while formattingSummary: Hi, I am using Oracle template builder for one of my reports which has date column, when I apply date formatting date changes by one day (example: 4712-12-31 ch…Eshwar Kappala 1 view 1 comment 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Anytime Feedback Report template - need helpSummary: Need help on this: When I use the Subject Are: Work Profiles - Feedback Notes by Recipient Real Time, the report is fetching all data from feedback and meeting …
-
Report on Anytime FeedbackContent Hi All, Is there a delivered report for anytime feedback that we can leverage? If not, has anyone built one and how? Please share any information you might have.…PriyaPenugonda-SC 102 views 2 comments 0 points Most recent by Marilyn O Reporting and Analytics for HCM -
Need to add the PO number and related information in the Account analysis reportSummary: As stated in the subject that we need to add the Po number and its relevant information in the Account analysis report therefore we have customized the standard…
-
Separate Remittance Advice based on custom data modelSummary: Is there a way of customising the disbursement extract associated with the Separate Remittance Advice for cloud customers. Our requirement is to add details to …Tim2021 563 views 5 comments 0 points Most recent by Sai Revanth Payables, Payments & Cash Management
-
How to report on the due date for Journey tasks in OTBI?Summary: We are looking to create an analysis in OTBI to pull a list of individuals who have overdue tasks from their onboarding journey. We are using the Workforce Mana…Aurora Dobson 1 view 0 comments 0 points Most recent by Aurora Dobson Reporting and Analytics for HCM -
Element Entries Real Time - Retroactive Payement DateSummary Within Element Entries Real Time - I have Retroactive payements made to employees however in OTBI i cannot locate 'Orginal Date Earned'Content Overview: For Empl…User_2025-02-04-23-40-44-792 53 views 6 comments 0 points Most recent by Pijush Biswas Reporting and Analytics for HCM -
Location data present in HR_LOCATIONS_ALL table does not have a reference/corresponding OrganizationSummary: Location data present in HR_LOCATIONS_ALL table does not have a reference/corresponding Organization detail in HR_ALL_ORGANIZATION_UNITS We need the detail of t…Raju Thadakala_1234 144 views 3 comments 0 points Most recent by BogdanFarcasanu-Oracle Payables, Payments & Cash Management
-
Sending of analysis to managers via agentsSummary Sending of analysis to managers via agentsContent Hi - We have set up a number of Analysis which are currently being sent to different business units / locations…Roy Paolo Paunlagui 74 views 10 comments 0 points Most recent by Vivek Balchandani Reporting and Analytics for HCM
-
How to get Branding Image URL for Course created in Oracle Fusion HCMHello Everyone, We are developing a custom report to list courses, and one of the requirements is to display or extract the URL of the uploaded branding image for each c…Sammeta Srividya 13 views 3 comments 0 points Most recent by ShahzaibShaukat Reporting and Analytics for ERP
-
OTBI report is generating single row output when language preference is changedSummary: OTBI report is generating single row output when language preference is changed and when language preference is set to English, then output looks good and otbi …Paramesh Kurva 1 view 0 comments 0 points Most recent by Paramesh Kurva Reporting and Analytics for HCM