BI Publisher
Discussion List
-
Difference between creation_date and submission_date in IRC_SUBMISSIONS tableSummary: Difference between creation_date and submission_date in IRC_SUBMISSIONS table Content (please ensure you mask any confidential information): Hello experts, does…Oriana L. 1 view 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM -
SQL Query for Time Card Data and Absence DetailsSummary: Content (please ensure you mask any confidential information): Dear All We have requirement to create OTL Time Card Punch in and Punch out Report if the Employe…Shameer Muhammed 436 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
Help in Benefits HCM ExtractSummary: Hello again! I need to pull some data and I found the perfect UEfor it: BEN_EXT_ENRT_RSLT_UE. The only problem is that it can't be a Root Data Group UE. Searchi… -
'The page has no content' error messageSummary: Hi All, We have a reports dashboard that is generated by clicking on a custom tile as per the below screenshot. For new users (sometimes even for repeat users),…Anne Fonseca 12 views 2 comments 0 points Most recent by Anne Fonseca Reporting and Analytics for HCM
-
Can we automate the HDL loads for Business Objects like Talent Profile / DOR having CLOB Files ?Assume, client is giving the DOR files on a regular interval and placing them in some folder and we have to automate the DOR HDL load on a recurrence basis. Is there a m… -
BI Publisher Report- Learning Initiatives including Course number and Title-LearningSummary: BI Publisher Report- Learning Initiatives including Course number and Title fetching duplicate rows Content (required): Hello All, I have the SQL code that fetc… -
Can Delivery Option Web Content file entry be removed from Extract already on Scheduler?Summary: Can Delivery Option Web Content file entry be removed from Extract already on Scheduler with out impacting nightly output to FTP Content (please ensure you mask… -
Chnages only extract to pull chnages on same daySummary: I have requirement to pull Employment Assignment Action at changes only extract. It is working fine when there is single change in a day but user is expecting b…
-
Better alternative for not like operatorSummary: Better alternative for not like operator Content (please ensure you mask any confidential information): Hello , I am trying to exclude certain checklist names f…Nikhila 21 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
feasibility check of triggering Manager's direct and indirect reportees dataHi Team, Requirement: I have a requirement to trigger the report to managers as an attachment. The report should include data from both direct and indirect reporters. Co…Haritha 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Depreciation projection for 2 million assets in Oracle cloud Fixed Assets?Summary: Is it possible to run depreciation projection report for 2 million assets without any performance issue like long delay in generating report output in Cloud Fix…
-
How to send a report to a network folderSummary: Is there a way to schedule a report or Agent to send directly to a network folder? Content (please ensure you mask any confidential information): Version (inclu…THawkins_LGI 151 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Transfer Payment File using SFTPDear All, I have a requirement that entails transferring files using an SFTP server for each payment in AP ERP Cloud to another designated server. I've managed to succes…George Mattar 393 views 7 comments 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
How to change the timeout option on Oracle Saas?This is regarding one of the API connector setups from Setup and Maintenance -> Manage Transmission Configuration -> "http multiple part data upload" protocol. Oracle is…Nitish Mishra 82 views 9 comments 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Showing error in BIP report ScheduleSummary: Hi Experts, we are facing following error during report scheduling. Content (please ensure you mask any confidential information): Version (include the version …
-
total column row should have only total amount valueSummary: In Report we are using Pivot table and there is amount column so doing total of the row , but the total row is giving again entire row values. Providing sample …
-
Goal Status Overview Real Time is not reporting Review Period NameSummary: Created a OTBI Report using the Subject area "Workforce Goals - Goal Status Overview Real Time". but not getting the data for "Review Period Name" and we have a…
-
BI tables to retrieve employee assignment country and departmentSummary: Content (please ensure you mask any confidential information): Hello experts, we need to configure custom person security profile based on employee assignment c…Valerio Curzi 51 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
getting duplicate seniority dates in OTBI report FusionSummary: Oracle Fusion OTBI report is there giving duplicate records for one of the employee. It showing two seniority date records out of it we need earliest seniority …
-
Report submitted in Scheduled Process going to Error stateSummary: Content (required): Hi All, BI report configured under 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applic…Anil Pillaresetty 121 views 1 comment 0 points Most recent by larachalak Reporting and Analytics for HCM -
Which schema is recording the salesperson account information?Content (please ensure you mask any confidential information): Can anyone provide the schema or SQL query on how to check the salesperson with Revenue&Receivable&Freight… -
Which table holds the HR Representative Data for a particular employee?Summary Which table holds the HR Representative Data for a particular employee?Content Hi, Can anyone please let me know, which table holds the HR Representative Data fo… -
How to Test/preview etext templateSummary Have you ever created etext template to create delimited or fixed length files? Have you faced issues with debugging the template with ????? characters on the ou…Sricharan Monigari 465 views 3 comments 6 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
Action Taken Table/Field under Manage Accounting ErrorsSummary: Hello Colleagues, Good day! With regards to Manage Accounting Errors, do we have a table/field that contains the Action taken? I tried to search all tables and …Ralph Aldrich Magno 81 views 4 comments 0 points Most recent by Ralph Aldrich Magno General Ledger & Intercompany
-
payroll report with gross pay showing element entry deductionsSummary: I need to create a report (OTIBI or BIP) that shows a person name, person number, pay period, pay period week, gross pay (for the pay period), add-in bonuses, (…
-
Seeded Termination Report in HCMSummary: Good morning everyone, Does anyone know if there is a seeded termination report in Oracle HCM. Also, is there a best practice for verifying inactive employees? …Daniel McMillian 81 views 8 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Create Security Report in OTBI with details of roles both past and present with dates and statusI tried submitting this question in the HCM Report Sharing Center that was discussed during yesterdays HCM Customer Connect but was getting an access denied error so pos…
-
Expense Notification Banner for Global TransferSummary: Expense Notification Banner for Global Transfer Content (required): Background - Post Global Transfer, employees are unable to submit expenses for the previous …
-
Run Payroll Costing Report flow relation with Payroll Costing Report Extract?Hi All, I'm trying to understand if there is any relation between Run Payroll Costing Report flow and Payroll Costing Report Extract? My requirement is to modify Payroll…