OTBI
Discussion List
-
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 416 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 12 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 101 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 533 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 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 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 78 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 1 view 3 comments 0 points Most recent by ShahzaibShaukat Reporting and Analytics for ERP
-
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 (…
-
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 …
-
what is the subject area that retrieve learning initiative informationSummary: Hi, I need to retrieve Learning initiative details from OTBI analysis, but I am not able to find it. Please suggest which subject are will be used. Content (req… -
How to download attachments in bulk from suppliers, contracts, purchase agreements, SRHello, Summary: As part of the implementation of a single ERP system for both Chile and Peru, users need to download the attachments found within the supplier files, con…
-
OTBI – Workforce Profiles: Person Profile Real Time pulling deleted competenciesSummary: I have a reporting requirement to identify the competencies workers have entered on their Person Profile, including workers who have not entered any competencie…
-
How can I pull all reports and their permissions available /shared folder/custom/ pathSummary: How can I pull all the reports available in "/Shared folder/Custom/" path with their permissions through backend(sql) or any other alternate, with environment h… -
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…GauravGupta39 621 views 5 comments 0 points Most recent by Viswanadh Reporting and Analytics for HCM
-
SOAP Or REST File Attachment for maintenance Standard OperationSummary: A requirement was made to carry out bulk upload of PDF file attachments to all the individual maintenance standard operations currently in the system Content (r…
-
I need to build an analysis that shows the headcount for the logged-in manager for the last 5 years.Summary: I need to build an analysis that shows the headcount for the logged-in manager for the last 5 years. I created the analysis using the Workforce Management – Wor…Jessima Parveen 1 view 0 comments 0 points Started by Jessima Parveen Reporting and Analytics for HCM
-
Customization of Purchase Requisition Approval EmailI am currently trying to customize the purchase requisition approval email template. I need to add additional text to the email body and modify the subject line of this …
-
Can we make a OTBI downloadable from the dashboardSummary: We have developed an OTBI report for fetching the direct reportees absence details with date condition filters and attached in MSS dashboard. Whereas, the manag…