What is the size of an attachment that we can attach with a document of record?

There is a profile option where the default value is 2GB. And the profile option is FND_FILE_UPLOAD_MAX_SIZE.  This value can't be changed by anyone if it is required also. If anyone wants to increase the size, then we need to log a service request with business justifications to increase this file size limit.


Can we restrict a user to not upload certain file types in a document of record?

Yes, we can restrict users to not uploading a certain file format. Setup and Maintenance Manage Attachment File Formats This task allows you to configure the file formats that you want to restrict from being attached. The feature works as an "exclusion".


Can I view the details in the approval notification

Yes, for that we need to enable BIP-related profiles. BIP_EMAIL_NOTIFICATION_HCM BIP_EMAIL_NOTIFICATION_HCM_PER  BIP_ONLINE_NOTIFICATION_HCM  BIP_ONLINE_NOTIFICATION_HCM_PER


Explanations of transaction statuses

SUBMITTED: Once we have submitted any transaction after that the system will run an ESS job that is Refresh Transaction Administrator Console Transaction Status and it will make update the status of the transaction to any one of the following statuses: IN PROGRESS, ERRORED, STUCK, AUTO RECOVERY


User name creation during new hires

There are 4 types of user names created when we hire an employee in the system, this kind of setting we can control vis user category from the security console. 1. Email - It will accept the work email we defined during the hiring process. 2. FirstName.LastName - It will accept the worker's first name and last name.


User name creation during new hires

There are 4 types of user names created when we hire an employee in the system, this kind of setting we can control vis user category from the security console. 1. Email - It will accept the work email we defined during the hiring process. 2. FirstName.LastName - It will accept the worker's first name and last name.


What are the organization that we consider as classification?

Organization classifications define the purpose of the organization, whether it's a department, a division, or a legal entity. In some enterprises, organization classifications overlap, which means that the same organization can be assigned multiple classifications. Provided by the Oracle Document.


Characters limit for username

The username can be in any format, and the maximum length of the username is 80 characters


Is it possible to restrict a few document types based on countries

Yes, it is possible to restrict or hide certain document types in Oracle Fusion HCM based on various criteria, including country-specific requirements.


Double opt-in, how system would identified the location of the candidates?

When you open the browser you will get a popup saying that you want to track the location, if the candidate allows the popup then it is going to automatically deduct the location of a candidate.


Getting Approve and Reject button on FYI for Termination

1. administrator login to BPM worklist for task configuration 2. click on 'Task configuration' 3. Search for 'Termination' 4. click on 'TerminationsApproval' 5. click on the pencil icon. 5. Click On 'Configuration' 6. Set 'Task Aggregation' as none


Why “Include Related Contact” is missing in-person security profile

This option was removed from the Person Security Profile back in Rel 12 for performance reasons. I can't find the exact release readiness documentation link, but this change was documented.  Please note the additional duty role that can be added.


Not getting any data for the department field

Navigate to the Setup and Maintenance. Search for the Manage Administrator Profile Options. Search for the profile option PER_LOV_SEARCH_DEPARTMENTS_STARTSWITH Change the Site Level value from N to Y. Save and Close.


Load worker and SQL

select 'METADATA|WorkTerms|AssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentStatusTypeId|BusinessUnitId|PeriodOfServiceId|PersonId|PrimaryWorkTermsFlag|ActionCode|ReasonCode|WorkTermsAssignmentId|JobCode|DepartmentName|DefaultExpenseAccount' from dual UNION ALL


SQL Query to get the profile id or profile code for an employee

select                  "PER_ALL_PEOPLE_F"."PERSON_NUMBER" as "PERSON_NUMBER",                "HRT_PROFILES_B"."PROFILE_CODE" as "PROFILE_CODE"


Load Metadata File for Job Creation using HDL

Dat File Name: Job.dat METADATA|Job|JobCode|ActiveStatus|FullPartTime|EffectiveStartDate|Name|SetCode|JobFamilyName|SourceSystemOwner|SourceSystemId MERGE|Job|ABC-JB-010-2D|A||1951/01/01|Systems Administrator|ABCSUS|Security Systems Service, Maintenance & Repair|ABC_SS_US|ABC-JB-010-2D


Load Matadata File for License & certification creation using HDL

Dat File Name: ContentItem.dat METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name MERGE|ContentItem||LC063||1951/01/01|ABC_Licenses_Certifications|U|103|Supervision of Aerosols