OTBI
Discussion List
-
[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 162 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Different vision in OTBI than in UISummary: Hello We have moved to a Redwood theme in our UI but then our OTBI report look at change. It now looks very old school. Also please note that when we open it in…LucieWS 6 views 1 comment 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
delete value set valuesSummary: Good Morning Can I delete value set values (account values ) in the account segment took the wrong hierarchy by mistakeEsraa Yousef 4 views 1 comment 0 points Most recent by Gaurav Kumar-100036 General Ledger & Intercompany -
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… -
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… -
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 23 views 2 comments 0 points Most recent by Jonathan Ruth Reporting and Analytics for ERP -
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 '… -
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 7 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 407 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… -
OTBI issue issue,Workforce Management – Absence Real Time subject area.Summary: Hi , OTBI issue issue, calculated absence duration when using the Workforce Management – Absence Real Time subject area. Example: Employee submitted three conse…Anil.ar.kumar-Oracle 6 views 0 comments 0 points Started by Anil.ar.kumar-Oracle Reporting and Analytics for HCM -
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 10 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 4 views 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 103 views 2 comments 0 points Most recent by Marilyn O Reporting and Analytics for HCM -
Redirection link to a report using environment variableSummary: #{header["host"]} variable in page entry Static URL no longer valid Content (please ensure you mask any confidential information): Hello, I used to use #{header… -
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 534 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… -
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 56 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 112 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 77 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 5 views 3 comments 0 points Most recent by ShahzaibShaukat Reporting and Analytics for ERP -
Is it possible to change the account sign convention at the system level in Oracle ERP Cloud?Summary: Hello Experts, I would like to confirm whether it is possible to change the default sign convention (natural balance for each account type, e.g., Revenue and Li…Yuyeon KIM-Oracle 10 views 1 comment 0 points Most recent by ShahzaibShaukat General Ledger & Intercompany -
We are unable to create OTBI report for "Physical Inventory Adjustments" Pending Adjustment statusSummary: As per the user’s request, they require a report for “Approve Physical Inventory Adjustments” that identifies the items that were rejected. User reviewed OTBI (…