Data Models
Discussion List
-
How to get the vertex and loqate geography details in hcm?Summary: As i understand, there is a seeded report available to fetch the details of the vertex and loqate geographies which are loaded in HCM. Any idea what is the path… -
REASON_CODE is not populating in PER_ALL_ASSIGNMENTS_M tableWe have custom reports which are using the REASON_CODE column from PER_ALL_ASSIGNMENT_M table. After we enabled Redwood, the REASON_CODE column stopped populating UI sho…
-
BIP Report returns sql time out error for few usersHi, We have a BIP Report which is working fine for few users and returns SQL time out error for few users. The user who is getting error is running the report by using s…Yuvraj S-Oracle 109 views 4 comments 0 points Most recent by vinay.u.sharma Human Capital Management
-
How to schedule the same PDF notification for Casual employees at 6 months, 12 months, and yearlySummary: Hi All, I have a requirement where we need to send the same PDF document to employees whose Assignment Category = Casual based on the following timeline: First …Dharani Dhar Gupta 15 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Human Capital Management
-
How to populate multiple time event attributes within the REST API timeEventRequestsSummary How to populate multiple time event attributes within the REST API timeEventRequestsContent Hi gurus, I faced an issue with populating multiple time event attrib… -
Issue with “View Document” in Documents of Record – PDF Download ErrorHi Team, Whenever we try to add Documents of Record and click on View Document against an employee, the PDF report should download, but it is throwing an error message. …
-
GL Trial Balance Report ParameterSummary: I need to show the Future Enterable periods for the user while he is running the GL TB report. currently i cannot see where exactly they define the LOV for Acco… -
BI Audit Report/Tables connection errorSummary: We are seeing below error when user is trying to run a BI Report which fetches data from fusion iau viewer.bipublisher_v table to capture report access timeline…
-
HCM Extract - With Document of Records Delivery typeSummary HCM Extract - With Document of Records Delivery typeContent Hi Experts, I have a requirement to store the Report in Document of records, for that we have used HC…User_2025-02-10-21-41-28-701 443 views 14 comments 1 point Most recent by Aditya Jadhav Human Capital Management -
Need sql query to fetch approvers list of a transactionSummary: Hi There, I have a requirement to fetch all approvers' names of a transaction, If any one have report for this requirement, please share. Thanks, Lakshmi Conten…
-
Position Override Flag Changing After HDL LoadSummary: Hello, We are doing a full load for UAT. I have position override set to Y for all active workers. Yet when I load the data it changes to N for some. WHY?? And …
-
XML-23029: (Error) FORG0001: invalid value for cast/constructor ERROR IN BIP REPORTHi All, We are getting below error while running BIP report, while it runs successfully for some orders and gives error for 2-3 orders Can you suggest nay possible solut…
-
Is there any possibility of retrieving the processed or errored HDL files after the retention periodSummary: Is there any possibility of retrieving the processed or errored HDL files after the retention period? Content (please ensure you mask any confidential informati…
-
Need Table details storing User information created in Security ConsoleSummary: We need to get the information of User like First Name, Last Name, username and email id of the user created in Security console. Content (required): Person inf…Sudheer Movva-193114 1.5K views 10 comments 0 points Most recent by s.datta Human Capital Management
-
How to get the Work Terms Number for an assignment?Summary I am trying to use HSDL for correcting assignment information for some employees which requires the Work Terms Number and i am unable to find it outContent I am …Srikanth Ramaraju 7.4K views 10 comments 2 points Most recent by Cristian Ariel Arakaki Human Capital Management
-
Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g…
-
Can we reuse the PER_IMAGES table to store signature images by defining a custom IMAGE_TYPE?Summary: We need to store employee signature images in Fusion so that we can retrieve them dynamically in BI Publisher PDF and Excel reports. Since UCM images are no lon…
-
how can I know who has updated the profile option last?Summary: Hi Team, how can I know who has updated the profile option last? Is there any SQL query for this? Content (please ensure you mask any confidential information):…
-
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …Saurabh_Mharolkar 144 views 2 comments 0 points Most recent by Cristian Ariel Arakaki Human Capital Management
-
Columns removed while editing the dataset in Data Model for BIP reportHi All, We are editing the 'Statement Generation Data Model' ,. We have few existing columns which are available in the Structure diagram, but same is not available in D…
-
How can we read Person Number and set report parameter in a Report URL on Employment page(Person ManSummary How can we read Person Number and set report parameter in a Report URL on Employment page(Person Management)Content How can we read Person Number and set report …
-
Link on the name bring the Manager to the Connections page for that colleague in Team Activity CenteIs it possible the link on the name bring the Manager to the Connections page for that colleague? (former/ Nux Public Info page). Since it currently opens up the Activit…
-
Job Offer Approval Rule in "Worker Type" we have "Contingent worker " & "Employee".Summary: Hello We have a requirement with Job Offer Approval Rule in "Worker Type" we have "Contingent worker " & "Employee". Employee Need to go for Approval Contingent…Krishna Sigilipalli 33 views 3 comments 0 points Most recent by Sonal_Modi Recruiting, Opportunity Marketplace
-
Backend table for FICAWe're trying to look for the backend table for FICA status for below navigation: My client Groups> Person Management>Search for any person> tasks> payroll>calculation ca…Midathala Indu Sree 1 view 1 comment 0 points Most recent by Yaswanth_Pappu-Oracle Human Capital Management
-
Not able to see the data Annual PDP 2026 from hra_doc_types_tlSummary: I am able to see the performance document Name in OTBI and front end but not able to see in the oracle fusion HCM table hra_doc_types_tl Is this expected or do …
-
Need to fetch Transaction approver start date and the next level approver detailsSummary: We have a requirement to fetch the date the transaction was assigned to each level of approver and also the next level approver details. This is applicable for …
-
In Redwood Resign from Employment-Termination details not displaying in Approval notificationSummary: We have migrated to Redwood V3 Resign from employment. when the Employee Resign from Employment, the approval goes to the Line Manager and HR VP. Though they se…
-
Is it possible to query or export approval rules + conditions for a transaction?Summary: I want to export the configured rules and conditions for the Manage Employment approval rule (Transaction Console > Approval Rules). How can I do this? Is there… -
HDL for custom section in Additional Person Info pageSummary: HDL for custom section in Additional Person Info page Content (please ensure you mask any confidential information): Hi experts, does anyone has a simple HDL te… -
Is there a limit on number of parameters that can be added to a BIP report/Data Model?Hi Team, Is there any restriction to add number of parameters in a BIP Report? Thanks, SatyaChinnamsetti Satyanarayana Swamy 1 view 1 comment 0 points Most recent by Chinnamsetti Satyanarayana Swamy BI Publisher Learning Center