Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
HCM Extract
Discussion List
-
unable to view edit option in hcm extract in 24aSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
HCM Extract BIP report delivery handling of special XML CharactersHello All, We have a requirement from a client to pull all of the Talent Profile items from the HRT_PROFILE_ITEMS table. when creating the extract we noticed that in the…
-
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…
-
HCM Extract- Position Costing informationSummary: Hi Folks, I've need to fetch the position costing details from pay cost allocations table. Also need the concatenated string of values of Entity + Cost Centre +… -
Extract gives an error in work relationship for terminated employeesSummary: We are using this extract from a couple of months ago. It works for all other employees. Now the client requirement to add terminated employees is in the extrac…
-
Unable to view data after submitting a flowI had submitted a flow for a seeded extract called "French Personnel Register" but I am not able to see any data. Further when I extracted the query of behind the UEs us…
-
Extract Rollback using SOAP serviceSummary: Unable to rollback extract using Flow Action Service Content (please ensure you mask any confidential information): Hi, I am using Flow Action Service With Perf… -
Unable to delete the record under data group in HCM extract 24D.Summary: Hello All, I accidentally created a record under data group in HCM extract and saved it after realizing that I don't need this newly created record, so I tried … -
What are the user entities to use to fetch the check payment details in HCM extractHi All, Can someone please help me to find out which user entities to pick to get payment related data like payment amount, account number, check number etc. Thanks, Sow…
-
CANCELED_HIRE system person type not populated after cancellation of employee work relationshipSummary: CANCELED_HIRE system person type not populated after cancellation of employee work relationship Content (please ensure you mask any confidential information): W…
-
Dynamic Payroll Relationship group not working as a parameterSummary: We have a requirement to add Payroll Relationship group as a parameter to a custom BI report. While running with this parameter, the report runs fine with stati…
-
Hide Attribute xml tag if attribute value is nullSummary: Hide Attribute xml tag if attribute value is null Content (please ensure you mask any confidential information): Hello, In HCM Extract is it possible to hide an…
-
Creation of positive pay file for hcm payrollHi All, We have a requirement to create a positive pay file to send across the bank for check payments from payroll. The file should include employees checks and third p…
-
Value Set passing two parameters for ExtractSummary: Hello, Customer Connect! I have some value sets(and respective Fast Formulas), that I use to get some attributes/fields that the User Entity I'm using don't hav… -
HCM Extract| Balance ValueSummary: Hi, I need to fetch balance value for dimension YTD. I created the balance group and HCM extract(Followed the attached PDF). But it is not working as expected. … -
Unable to change the Parent root data group in 24DSummary: Unable to change the Parent root data group in 24D. Content (please ensure you mask any confidential information): We have multiple UE (User Entities) in a extr…
-
After 24D Advanced Edit Option is not working in Extract DefinitionSummary: In Extract Definitions the Advanced Edit option is not available post 24D upgrade Content (please ensure you mask any confidential information): Before Screen s…
-
Get the description of a value in a valueset using HCM ExtractSummary: Hi, I need to extract the field description from the value set for each value and I need to insert the description as an attribute in the HCM extract Content (p…
-
Tag not in the xmlSummary: Can anyone help me with this? I am trying to a field through extract definitions. Once after running the report, I couldn't able to see the tag being populated …
-
Is there a list of Oracle deprecated UEsIs there a list of Oracle deprecated UEs with the date that deprecated UE will no longer be supported?
-
What is the user entity for the table PER_ALLOCATED_TASKS.I want to update a PDF file to employee's DOR. I need to create an extract for this based on the table PER_ALLOCATED_TASKS, hence I need the user entity I should use for…
-
Concat in HCM ExtractSummary: How can I concat 2 or more fields in HCM Extract? Content (please ensure you mask any confidential information): I need to extract in HCM Extract a field which … -
Payment Source and positon costing Column QueryHi, I am currently working in a requirement to get the below column However, I couldn't find the payment reference, source, and position costing and tax reporting unit i…
-
Changes Only - ignore change in countSummary: Regarding HCM EXTRACT Changes mode. The requirement is to pick up new absences. The extract contains ABS_EXT_ABSENCES_ENTRY_UE with absence entry id as a key. D… -
Extract run error: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS5'Summary: We have some Extract runs completed with the status "Completed with Alerts". No output files have been generated. Under "Instance Details" section, the task "Ar… -
24A Parent Data Group Database Item not showingSummary: 24A Parent Data Group Database Item not showing instead I see a list of DBI in the current scope. Content (please ensure you mask any confidential information):…
-
SWP Extract is not fetching the Parent Organization details for few of the Departments.Summary: Hi Team, SWP Extract is not fetching the Parent Organization details for few of the Departments. We are using standard user entity 'PER_EXT_SEC_ORGANIZATION_UE'.
-
Where are the output files from HCM Extracts are stored and how to purge them?Summary: Content (required): Hi Team, I have an HCM Extract which delivers output to user email. However, when I open the HCM Extract results, I can download the attachm… -
Not able to view the files on UCM which are loaded in account hcm$/extracts$/export$Summary: Not able to view the HCM extract files on UCM which are loaded in account hcm$/extracts$/export$ Does the user need any permission/roles to view them on UCM. Pl…
-
Can we use Get_Abscence_Count formula function in extract rule?Hi All, We are trying to get the absence occurrences in an extract for that we are trying to build a extract rule using a formula function "Get_abscence_counts" but we a…