BI Publisher
Discussion List
-
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 464 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 54 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 112 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 31 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.2K 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 111 views 3 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCMSummary: Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCM like : Hire date Hiring position Hiring grade Current grade Current position End of …Hitha Harikumar 331 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
User Entity Talent HCM ExtractHello friends. I need to create an extraction in the HCM Talent module. But I never had contact with this module to find out information such as which user entity I shou… -
How to retrieve the job req status for BIPSummary: How to retrieve the job req status for BIP Content (please ensure you mask any confidential information): Hello experts, we would like to build a BIP report wit…Oriana L. 91 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
HDL Template to update assignment recordsSummary: Hi All, I may request a data loader to update all the assignment records simultaneously too since I just received ALL the statuses for 100% of the population to… -
Fetch balance values from Fast FormulasI have a requirement to fetch balance values based on input balance names passed to Fast Formula. I am using Balance Specific DBI's to fetch their values. When I hardcod…
-
Record Limit in Payables Invoice RegisterSummary: What is the limit (Max number of Invoices can be pulled in) of Payables Invoice Register? Content (required): Client want's to know what is the maximum number o…Prateek Bajpai 51 views 2 comments 0 points Most recent by Kratika Sharma Payables, Payments & Cash Management
-
Lookup Type that stores raw completion status and previous event statusSummary: Hello, I need the lookup_type and lookup_code for the raw_completion_status and previous_event_status in WLF_EVENT_ATTEMPT_INTERACTIONS table. Content (please e…
-
Query to extract second manager level (under top manager) for all employeesSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve for each employee the second level manager …Valerio Curzi 303 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to convert number in words in erpIn BIP report in cloud , we have to print one amount column in words. We have used the condition as below to convert it , but unfortunately it works upto one limit and l…RupaliGahalot 111 views 3 comments 0 points Most recent by RupaliGahalot Reporting and Analytics for ERP
-
Build reports for questionnaire templatesSummary: We have built evaluation, pre-enrolment forms. We can view individual learner response. How do I build a report to show this. I've never built a report before, …