OTBI
Discussion List
-
OTBI HR Help Desk Reports Not Returning Data, Security MappingSummary: Creating a all module reporting role, and added all the transactional duty roles specified to HR help desk. Additionally, have added DSPs to view all Service ty… -
Is it possible to route Project budget approvals to PM supervisor?Summary: Content (required): I am trying to setup budget approval rules to be sent to project manager supervisor but I can't seem to find the supervisor attribute in the… -
How to Generate a BIP Report in xlsx Format with 90+ Report FieldsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Malavika Sairaman 71 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
hcm bi report - how to schedule report on every end of monthSummary hcm bi report - how to schedule report on every end of monthContent Hi, I wonder how to schedule HCM BI report on every end of month. I wasn't able to find the o… -
Query for unearned revenue in oracle fusion from RA_CUST_TRX_LINE_GL_DIST_ALL tableSummary: we have Oracle fusion cloud services and we need to develop a report for unearned revenue how Can I identify the unearned revenue from RA_CUST_TRX_LINE_GL_DIST_…Shameer Muhammed 513 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections -
We have new requirement in my workforce page how find which subject area available ?Summary: HI Team, we have new requirement in my workforce page > additional person info group. which subject area available . Any one help me on . Thanks. Ajay Content (…AjayKumar Maddipati 51 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Need Table or Subject area with "Assessable Value"Summary: We need to retrieve the information that is on column "Assessable Value" on the PO Lines. Content (required): Cannot find "Assessable Value" on any OTBI Subject… -
Getting duplicate record in OTBI reportSummary: Content (required): Hi Expert, We have built an OTBI report for talent meetings and when we are running the report there is a record that is coming multiple tim…Faizan Rashid 865 views 3 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
Relationship between TAX tablesGood afternoon, Would any friend know which table makes the link between the ZX_RATES_B tables and the GL_CODE_COMBINATIONS? -
Is there a way to enter a prompt date and show this date in a column within the report?Summary: Enter an effective date of 01/05/2023 in a prompt Display this date within a column in the output of the report Content (required): If I user enters a prompt ef… -
Creating Asset Cost Summary Report in OTBISummary: Creating Asset Cost Summary Report in OTBI Content (required): I created "Asset Cost Summary Report" in OTBI, however, I am not getting back the balances as the… -
Standard Oracle depreciation report.Summary: Hi All, Thank you in advance for your help and time. I am just wondering if there is a standard Depreciation report that we can use in the Asset module (Oracle … -
DRILL DOWN TO EXPENSE REPORTS AND EXPENSE ITEMS FROM OTBISummary DRILL DOWN TO EXPENSE REPORTS AND EXPENSE ITEMS FROM OTBIContent Do we have a deep link which we will use in OTBI Report, this is new feature in 20C https://www.… -
convert date formatSummary: Need help with date formatting Content (required): substr(fleff.attribute_char5, 1, 10) to only display as MM-DD-YYYY Below is the query: SELECT substr(fleff.at…kalyan gade 111 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
How to Add Two Entries in one Criteria from the same Subject AreaSummary: Hi Team, We are trying to add two Entries in to one Criteria in the same Subject Area. Kindly help us how to add. 1. Document Review Cycle Info->Business Proces…Srinivasa Rao Pavuluri 61 views 0 comments 0 points Started by Srinivasa Rao Pavuluri Product Development -
Copy and Modify the Seeded Recruit to Hire DashboardSummary: We want to make modifications to the analysis tied seeded Recruit To Hire Dashboard. I've read various posts and documentation on how to achieve this, but none …Alex Tellez 163 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to update the Item Cost to the last Receipt CostSummary: How to update the Item Cost to the last Receipt Cost Content (required): As per the business, they maintain the cost on the basis on the basis of last received … -
Are there downloadable dashboards for Supply Chain Management modules?Summary: I am looking for downloadable dashboards like the ones created by Caroline Gladwin (please refer to link: OTBI Sample Dashboards - 1. How to Install and Configu… -
Pulling Comments from Resignation/Termination ActionSummary: Content (required): We are implementing employee self-service and manager self-service on submitting resignation/termination. There is an Comments and Attachmen…Kathleen Nguyen 31 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
REST Service for Item EFFSummary unable to get it workingContent Can some one help with below payload to make it working. I am creating Item EFF. My URL is… -
Dynamic assignment of a course does not workSummary: Dynamic assignment of a course does not work Content (required): Hi, we are encountering an issue with the assignment of a course in LMS. We set a dynamic rule … -
Dynamic Regular Date Earned Formula RequiredSummary: Need a formula to get the last two regular dates earned to update each month. Content (required): I have a Payroll Net Pay Variance report which compares the Ne… -
Annual Leave Buy / Sell - ReportSummary: A Report to identify those Employees who Bought / Sold Annual Leaves Content (required): Hi, Can you please help me to develop a report which will give details … -
HR self-service reporting in Oracle HCMSummary: Content (required): Hello everyone, I wanted to ask about the possibility to have HR self-service reporting in Oracle HCM, i.e. the possibility for HR users to …Maria Xydopoulou 62 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Deeplinks in OTBI and BI ReportsContent Is there a way we can use the Deeplinks in the OTBI and BI reports dynamically. Suppose I have a column for 'Person Number' and I click on a particular person nu…Amrit 121 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Properties Attribute "Read Only" - what does it do?Summary: Properties dialog box -> Attributes section -> Read Only Content (required): Hi All, If I adjust the attributes section to "read only" in the properties dialog …William_Johnson 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Parameter not working when embedding OTBI AnalysisSummary: Embedded an analysis on HCM page but it seems that the binding variable is not being received by the analysis because the report is not being filtered Content (…Jezreel Furagganan 61 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM