BI Publisher
Discussion List
-
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 384 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 81 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 55 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 122 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 467 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… -
Oracle Reserve Detail Report and Asset Balance Report - Add ParametersSummary: a) Oracle Reserve Detail Report does not have key parameters liks Company, Major and Minor Category. The Report might fail for huge data and having these parame… -
What is the BICC PVO (View Object) to extract data for pay_bank_accounts?Summary: I would like to extract bank accounts number from personal payment method. Examples of PVO are HcmTopModelAnalyticsGlobalAM.CompensationAM.PreSalaryPVO, HcmTopM…Babatunde Ayodele 151 views 3 comments 0 points Most recent by Babatunde Ayodele Reporting and Analytics for HCM -
Getting extra employees in BI report those are not direct or indirect reports of logged in managerSummary: Created BIP report to get direct indirect reports of manager however we are getting few extra employee those are not direct or indirect of logged in user (line …Swati U 45 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Impact of Member Name Path when a Tree includes multiple versionsSummary: Impact of Member Name Path when a Tree includes multiple versions Content (please ensure you mask any confidential information): We have a tree that includes on… -
Learning Calendar: In Monthly Calendar ViewSummary: Hi, have anyone prepared and implemented Learning Calendar in Monthly Calendar view. If so, could you share the report layout. Content (required): Version (incl… -
Table details for My Public Info-->About Me SectionSummary Table details for My Public Info-->About Me SectionContent Hi All, Could you please help me with the table/Column details for employee 'About me' Section. I am a…nitin Sharma 111 views 10 comments 0 points Most recent by Amee Patel Reporting and Analytics for HCM -
Fusion BIP Reports Permissions Changes AuditHi, Is it possible to know the person name/ID/number who updates the permission of various reports/folders in Reports and Analytics for BIP. Thanks!Shilpa Varghese 32 views 5 comments 1 point Most recent by Shilpa Varghese Reporting and Analytics for HCM
-
How do we export the expected effort of non-catalog item to OTBI?Summary: Expected effort of non-catalog items are not showing up in OTBI Content (please ensure you mask any confidential information): We are currently doing an integra… -
Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCMSummary: Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCM for fetching employee division. Content (please ensure you mask any…Hitha Harikumar 1.1K views 16 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to convert data rich text format to plain text in BIP.Summary: Am getting below output for one of Field format,:1. Words: 17Characters (with HTML): 897challa praveen 112 views 3 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM