Category 81
Discussion List
-
calculation card link with legal employerSummary: we are trying to fetch the below calculation card with specific legal employer Could you please let me know if any query is available or guide me on the linking… -
User-define column does not return valuesSummary: Content (required): Hello everyone, We are currently trying to create a data model using the following sql: SELECT /*+ MATERIALIZE */ r.row_low_range_or_name SS…Maria Xydopoulou 41 views 10 comments 0 points Most recent by Maria Xydopoulou Reporting and Analytics for HCM -
Reporting on 'Required' Field in OTBI From the Learning CatalogHello all, Does anyone know if its possible at all to report on the 'Required' section of any assigned learning to an individual? Within the Learning Catalog, we have co…
-
Can you password protect files sent out using an Agent?Summary: Is it possible to add a password to the output file for additional security that is sent out via email by the agent? It isn't needed for all situations but if w…Sarita Schumacher 42 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Query not working with where clause in BI publisherSummary: OTBI Query not working with where clause in BI publisher We have query which works in BI Publisher with no where clause but when added with where clause the whe…
-
Privilege for ORA_PER_LINE_MANAGER_ABSTRACT to access Workforce Management - Worker Assignment SASummary: Hello, Does anyone know what is the exact privilege required for ORA_PER_LINE_MANAGER_ABSTRACT to run the data of subject area Workforce Management - Worker Ass…Hazel De Castro 51 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)Summary: Hi Forum: I'm looking to use below to accomplish General tab for Scheduling a report START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day END: Last_Day(ADD_MONTH…JTW_HCM 1.4K views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Cannot extract Moved to HR information from BI tables (Recruiting)Summary: Content (required): Hello experts, we need to track candidates under Moved to HR and Moved to HR date. Is there a BI table to extract this information? Thanks i…Valerio Curzi 21 views 2 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
SQL or table to get the PAY_PAYROLL_TIME_TYPE ID of time and tasksgood morning experts We are working on a time and tasks report and we did not find the PAY_PAYROLL_TIME_TYPE ID, only the code and the name, could you help us with the S…
-
OTBI plugin for officeSummary: BI Publisher tab disappeared from Word Content (required): I installed OracleAnalyticsPublisherDesktop-6.4.0-win64.exe, and it opened Word after the installatio…Maboagamo 81 views 17 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Formula for exporting date in csv as dd mmm yyyySummary: I have a need to present date in a csv extract as dd mmm yyyy. I have the below formula that presents it as dd mm yyyy, any assistance that could be provided to…
-
Delete Folder with permission set to Open in BI CatalogSummary: Able to Delete BI Catalog Folder Content (required): With admin user we created the following folder structure Shared Folders>Custom>Custom_1>DM_Reports>.... No…Sahil Makhiza 41 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
New Hires ReportSummary: Is it possible to create a new hire details report that pulls in the effective date from the assignment vs the proposed start date in the offer letter? Content …Bhuangtran 173 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
OTBI Analysis with suspended assignment detailsSummary: We have an OTBI analysis to capture employees' suspended assignment details and need to add the date of the that suspended assignment started. Content (required…Ayesha Iroshani 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Exact Privilege for Human Resource Analyst Role to view own data in the OTBI reportSummary: Hello, Does anyone know what is the exact privilege required for Human Resource Analyst Role to view own data in the OTBI report. It appears that there are nume…Hazel De Castro 41 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
New Redwood reports available for P&GSummary: Hello, Is there any new redwood reports available for Performance & Goals? Kindly provide the links here. Your help is highly appreciated. Regards, Hazel Conten…Hazel De Castro 51 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
How to make Blob Image circular in bi publisherSummary: We have a requirement to display image in circular in the output. Content (required): Version (include the version you are using, if applicable): 23A Code Snipp…
-
Is it possible to have multiple organization trees active in core HR?Summary: Is it possible to have multiple organization trees active in core HR? What is the impact if the hierarchy is different? Does this affect reporting? Content (req…
-
Compensation Eligibility StatusSummary: Content (required): Hello everyone, I'm currently trying to create a Value Set that will get me the Compensation Plan ID and the Compensation Eligibility Status…Maria Xydopoulou 51 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
we need below BI columns but unable to development of those from absenceSummary: any one help me and to the requirement Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that …AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Degree Reporting - Item Code not available in Subject AreaSummary: Hello there, I'm trying to create a simple analysis that provides a full list of Degrees and the Item Code. There doesn't seem to be a "Item Code" option to sel…
-
Application Source website details informationSummary: Content (required): Hello experts, from BI, is there a way to extract website details for the Application Source object (Recruiting module)? For example, if we …Valerio Curzi 32 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can I pull the source information indicated on the Candidate Profile.Summary: We are looking to pull the source information that is stored on the Candidate Profile - not the submission that is associated with any requisitions. Content (re…Craig Stevens 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Does the Oracle code 3 of 9 barcode (B39R00.ttf) work?Summary: Content (required): I'm trying to utilize the built in oracle barcode fonts but I have taken screenshots of the barcode and scanned them on online scanners whic…KevinCochran 121 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for HCM
-
Error on running an OTBI report after 22B being appliedSummary: We are facing issues in running a OTBI report post 22B upgrade. Please see the attached error and let me know how to resolve this issue. Content (required): Ver…
-
Custom date and currency formatting in report data table columnsSummary: Is there a vehicle for providing custom formats? Content (required): In OTBI data tables, columns only offer a limited set of pre-defined formatting. How can I …Maboagamo 41 views 8 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to count number of offerings within a courseSummary: There is probably a really easy guide to this, but I can't get the count to work! I am using the Learning Records Real Time area and I am trying to get the numb…Mark Stoker 64 views 5 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Using AsofDate variable as a Dashboard promptSummary: Using AsOfDate variable as a Dashboard prompt Content (required): We have several OTBI reports that run using AsOfDate as the prompt variable. I would like to a…Denise Izzi 61 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How should I format the phone number in sql?HOW CAN I FORMAT THIS QUERY AS '+55 111 222 33 11' SELECT CASE WHEN SUBSTR (LTRIM (RTRIM (PPH.SEARCH_PHONE_NUMBER)), 1, 3) = '+55' THEN LTRIM (RTRIM ((PPH.SEARCH_PHONE_N…Cansel Karasoy 82 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
OTBI Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PSummary: Created OTBI report with only 1 field but the report errors Content (required): The Subject Area is Workforce Management - Person Real Time, and the field is % …Anna-MariaP 362 views 2 comments 0 points Most recent by Anna-MariaP Reporting and Analytics for HCM