Reports
Discussion List
-
Need SQL query to display HCM Extract results and output file namesSummary: Need SQL query to display HCM Extract results and output file names Content (required): We developed custom HCM Extract and it is having multiple delivery optio… -
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… -
How to customize US Validation Report for Payroll report?Summary: Hi Team, We are trying to create a copy of the seeded report. The extract copied does not yield any result even with no customization. The seeded extract name i…
-
Is there a way to extract filter criteria for multiple extracts in one goSummary: Is there a way to extract filter criteria for multiple extracts in one go Content (required): Hi Team, Greetings! We are checking for the HCM extracts which use… -
Inbound HCM Extract to compress multiple reports in a Single Zip FileSummary: Hi, We have a Inbound BI Report created. The Inbound Interface HCM Extract needs to run multiple reports and compress all those reports into single zip file and… -
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…
-
Can seeded flow Run Element Results Register be run secured by Business Unit ?Summary: Can seeded flow Run Element Results Register be run secured by Business Unit ? We have requirement to generate the output Run Element Results Register based on …
-
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 …
-
Is there another SOAP call that we can use to trigger BIP without exposing the Username & Password?Summary: We are currently using the SOAP wsdl below to trigger BIP report. Unfortunately client wants the username/password to be hidden in the SOAP envelope. Is there a…User_G9FPB 84 views 8 comments 0 points Most recent by MADAN ROOPESH Reporting and Analytics for HCM
-
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 24 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
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 …
-
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 61 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…CB 35 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 42 views 1 comment 0 points Most recent by Priyanka_Girdhar Oracle Integration Cloud (OIC)
-
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 43 views 0 comments 0 points Started by Diivya Prakash Diivya Oracle Integration Cloud (OIC)
-
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 23 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Integrations -
Loop back integration using HCM Extract Inbound InterfaceSummary: Loop back integration using HCM Extract Inbound Interface with HCM Data Loader - If the extract not return any rows on a particular run , it won't have any HDL …
-
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…
-
How to convert calculated fields into measures OTBISummary: We're using data from the Recruiting - Recruiting Real Time subject area. We need to create a performance tile to display Total Openings Left to Fill however th…Mark kristan De los Reyes 68 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle HCM Integrations
-
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 52 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…