Reports
Discussion List
-
Is there a SQL query to get employees processed in extract run?Summary: Is there a SQL query to get employees processed in extract run? Content (please ensure you mask any confidential information): there a SQL query to get employee… -
How to bulk download HCM Extract/Payslip data xml files from past 1 year runSummary: For a third party integration, we need to download payslip data xml files for past 1 -2 years. Data XML is not defined as extract delivery option. The only way … -
HCM Custom Extract for Payment RegisterSummary Sample extract for customized payment register reportContent Change Notes Date Version Change Reference 23-Aug-2019 v1 First Version Background Payment Register …
-
Can I use output from one BI report as input to another BI report?Summary: Content (please ensure you mask any confidential information): I know that I can create multiple templates for my output, but that would require me to run the d…
-
produce cost centres from 2 area onto one reportSummary: extracting table tables onto one report Content (required): I'd like to be able to validate the date between cost centres show in "Departments" in HCM vs " Cost…Jeanette.Spalding 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it common to only migrate 5 years of data from Oracle EBS to Oracle Fusion?Summary: We are implementing Oracle Cloud Fusion HCM by migrating from Oracle EBS. We want to import all data from Oracle EBS (20 years) to Oracle Cloud Fusion HCM, but … -
HCM Extract completing with Alerts with no output generated when using aggregate conditionSummary: Hi Team, We have a requirement to get the sum of the attribute conditionally in HCM extract by using it as a summary element. When I am trying to make use of th… -
To capture Personal Payment method changesSummary: To capture Personal Payment method changes Content (required): Planning to develop a extract to capture personal payment method changes . My question is , how t…
-
Export and Import Setup dataSummary: Hi Experts, Through Setup and maintenance, I exported specific business objects such as job or grade. When we click on the export button there is some process r…
-
Find and Replace PROD path reference in extractsSummary: Find and Replace PROD path reference in extracts Content (required): Hi Team, Greetings! We have multiple extracts with reference to Production path on SFTP or …
-
Added new delivery options at Element Result Report but output is not available once we runSummary: Added new delivery options at Element Result Report but output is not available once we execute Run Element Result Register flow Content (required): Added new d…
-
Is there any query/table/report that shows the list of published sandboxes and the changes madeSummary: Required to get the list of published sandboxes in the application and the changes done as part of the sandbox Content (required): Required to get the list of p…Nisha_Hegde 369 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Tables/Queries to fetch deleted time entries from a time card.Summary: Do we have any tables/ delivered reports which brings the deleted time entries from a time card. Content (required): We have a requirement to pull only the dele…SR_CC 273 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
HCM Integration with ADP for Absence and OTLSummary: We are trying to create an integration from HCM to ADP with Absence and OTL Data. Content (required): Has anyone implemented this as this is very basic requirem…
-
OTBI Analysis Revoke Access to Export options Powerpoint, Web Archive, Tab Delimited, XMLSummary: Would like to know if it is possible to disable Export options Powerpoint, Web Archive, Tab Delimited, XML by role in OTBI Content (required): We are looking to…CBeks 42 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Roles for integration user calling hcm report from OICSummary: Roles for integration user to be able to call hcm report from OIC Content (required): Hi team, we're doing an integration with hcm to move some data to another …Claudia Schiff 41 views 1 comment 0 points Most recent by Priyanka Girdhar Integration Cloud HR Guides and Templates -
UE availability for Person Deduction Card (PAY_DIR_CARD_COMPONENTS_F) without Effective Date contextSummary: Is there any UE available for Person Deduction Card (PAY_DIR_CARD_COMPONENTS_F) without Effective Date context Content (required): Please be informed that there…
-
Balance Initialization Data - Payroll ExtractsSummary: Fetching data from balance loads in balance group reports. Content (required): Hello, We are building a payroll report using HCM extracts. Using a combination o…
-
Security on HCM ExtractWe have created a extract and the customer want to implement security. Business Unit Security Need To Be Applied. The extract output should show only the records as per …
-
How can we invoke any external API from Oracle HCM Notification(custom/seeded)Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Diivya Prakash Diivya 61 views 0 comments 0 points Started by Diivya Prakash Diivya Integration Cloud HR Guides and Templates
-
Report generation from base64 pdf returned from webserviceWe require to call a base64 webservice directly from an OTBI report placed on the Fusion apps springboard, and open the base64 pdf file. Business case is: we have a 3rd …Barış Ergün 21 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Integrations -
Available Methods to search for a keyword in Extracts or Integration FlowsSummary: Available Methods to search for a keyword in Extracts or Integration Flows Content (required): Hi Team, Greetings! We are planning to modify the payroll balance…
-
XML tag in RTF TemplateSummary: Team, We have developed one extract. The data is getting appeared in XML. But in the output file, its not getting appeared. Any idea, how can we get Business Un…
-
OTBI>Analysis>Edit Formula the same as the "Listagg" function in HCM SQLSummary: is there a similar function in OTBI>Analysis>Edit Formula the same as the "Listagg" function in HCM SQL? Content (required): Version (include the version you ar…Mark kristan De los Reyes 62 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle HCM Integrations
-
sFTP connection is failing with 503 error after whitelisting Oracle given IPsSummary: sFTP connection is failing with 503 error after whitelisting Oracle given IPs Content (required): Our system was upgraded with 23A over the weekend and after th…
-
HCM Extract: No Output when Fast formula is added to ExtractHi Team, I need to get the Assignment Effective Start Date based on some conditions using a Fast Formula. My fast formula is working fine because I wrote logs for each f…Chaitra Lakshmi Krishna 34 views 2 comments 0 points Most recent by Chaitra Lakshmi Krishna HCM Extract
-
Report Output is blank after passing the flowInstanceName/payrollActionId of the Extract RunSummary: Hello All, Can anybody please give inputs for this issue. Report Output is blank after passing the flowInstanceName/payrollActionId of the Extract Run. The Extr… -
Map View OTBI AnalysisSummary: I have followed the steps in this walkthrough on how to set the map data but I am still getting an error message (Please see attached). Any tips that can help m…Mark kristan De los Reyes 82 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Integrations