OTBI
Discussion List
-
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 2 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 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 584 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 154 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 12 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 2 views 0 comments 0 points Most recent by Paramesh Kurva Reporting and Analytics for HCM -
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 Most recent by Jessima Parveen Reporting and Analytics for HCM -
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… -
Is there a list of tables where the "Manage Geographies" setup is stored?Summary Looking for SQL Tables for the Manage Geographies setupContent Someone has setup some Geography data in the Manage Geographies setup pages which include some hie… -
issues with buyer pdf template for negotiation using the BIPHi team, I have customized the buyer pdf view template for negotiation. Followed all the required steps/ways to achieve it. The new layout does not show u on the configu… -
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…marcfromhawaii 402 views 5 comments 0 points Most recent by Habiba KAYAAKAY Reporting and Analytics for HCM -
Users are not able to see custom ESS jobsSummary: The custom ESS job has the permission for BI author role and assigned BI author role to the users still users are not able to see/run the Custom ESS jobs Conten…Chandana.palaparthi 91 views 2 comments 0 points Most recent by NikhilYadav General Ledger & Intercompany -
How to Sort the data in Resource AlertSummary: We've developed an alert which will notify line managers and listing the employee's (reporting to the line manager) who are all overdue in completing their lear…