User Account in Suppressed Status


If you find that a worker's user account is in suppressed status, it means the username is already assigned to another user.

Use following query to check the status of user account in LDAP.

SELECT  PAPF.PERSON_NUMBER,
        PPNF.LAST_NAME,
        PPNF.FIRST_NAME,
        PU.USERNAME,
        PU.ACTIVE_FLAG,
        LDAPU.REQUEST_STATUS,
        LDAPU.USERNAME LDAP_USERNAME,
        LDAPU.REQUEST_TYPE,
        LDAPR.ACTIVE_FLAG LDAP_ACTIVE_FLAG,
        LDAPR.REQUEST_DATE,
        LDAPR.LDAP_REQUEST_ID
FROM PER_ALL_PEOPLE_F PAPF,
     PER_PERSON_TYPE_USAGES_M PPTUM,
     PER_PERSON_NAMES_F PPNF,
     PER_USERS PU,
     PER_LDAP_REQUESTS LDAPR,
     PER_LDAP_USERS LDAPU
WHERE PAPF.PERSON_ID = PPNF.PERSON_ID
AND ((TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE) OR (TRUNC(SYSDATE) < PAPF.EFFECTIVE_START_DATE))
AND ((TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE) OR (TRUNC(SYSDATE) < PPNF.EFFECTIVE_START_DATE))
AND PPNF.NAME_TYPE = 'GLOBAL'
AND PU.PERSON_ID(+) = PAPF.PERSON_ID
AND PPTUM.PERSON_ID = PAPF.PERSON_ID
AND PPTUM.EFFECTIVE_LATEST_CHANGE = 'Y'
AND PPTUM.SYSTEM_PERSON_TYPE <> 'CON' -- To exclude Contact
AND ((TRUNC(SYSDATE) BETWEEN PPTUM.EFFECTIVE_START_DATE AND PPTUM.EFFECTIVE_END_DATE) OR (TRUNC(SYSDATE) < PPTUM.EFFECTIVE_START_DATE))
AND PERSON_NUMBER = <P_PERSON_NUMBER>
AND LDAPR.REQUESTING_REFERENCE_ID(+) = PAPF.PERSON_ID
AND LDAPR.LDAP_REQUEST_ID = LDAPU.LDAP_REQUEST_ID(+)
ORDER BY PAPF.CREATION_DATE DESC


If the status is SUPPRESSED, then use following HDL template to create a request with LDAP.


METADATA|User|PersonNumber|Username|GenerateUserAccount|Suspended
MERGE|User|101|abc|Y|N


This will create a new request in LDAP. Once this step is done, submit "Send Pending LDAP Requests" from Scheduled Processes to have the user account created in HCM.

Comments

  1. megan collinsNovember 21, 2020 at 4:15 AM

    That was a great blog. You covered all the points and necessary information. It showed your interest in the topic and all the related topics. I just came across your blog while I was browsing various sites. Also, here is a referred link same as yours oracle fusion hcm training.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Upload/Download files to/from Oracle WebCenter Content Server (UCM)

Image
In the previous article, we learnt about " How to submit BI Report Online using Web Service ". Today, we are going to learn how to upload/download files to/from Oracle Content Server in Oracle Fusion Cloud environment. For inbound or outbound integrations to/from Oracle Fusion Cloud Application to work, we need to search/upload/download files from Oracle Universal Content Management (UCM) i.e. Oracle WebCenter Content Server. The methods available are as following: 1.      Files can be uploaded manually from Application using Data Exchange à Import and Load Data. You can upload files to UCM using File Import and Export as well. Ensure account is hcm/dataloader/import when uploading the file and hcm/dataloader/export when downloading the file. Additionally, these files can be accessed from Content Server ( https://<Instance host:port>/cs/idcplg ). 2.      We can also use WebCenter Content Document T...
Read more

User Account in Oracle Fusion HCM

Image
Configuration for User Account: 1.        Set up for automatic User Account Creation. Go to FSM --> Manage Enterprise HCM Information --> This set up will ensure that user accounts are created automatically for person. 1.        User Name generation method. This set up is done in Security Console. Go to Tools -->  Security Console -->  User Categories This will ensure if work email address is there in the Worker.dat file while loading worker information – this will create user account by default which is same as the person’s work email address. However, this will be pending status as we need to Send Pending LDAP Requests to reflect the user name. Post successful completion of ESS job “Send Pending LDAP Requests” the user account will be reflected as person’s work email address. In case there is no work email addre...
Read more

SQL to get Payroll Balances in Oracle Fusion HCM

SELECT DISTINCT     papf.person_number,     pni.national_identifier_number,     prb.balance_value,     ppa.effective_date,     pbtv.balance_name,     pbd.base_dimension_name FROM     per_all_people_f           papf,     per_national_identifiers   pni,     per_periods_of_service     ppos,     per_all_assignments_f      paaf,     pay_payroll_assignments    ppasg,     pay_pay_relationships_dn   pprd,     pay_payroll_rel_actions    ppra,     pay_run_results            prr,     pay_run_result_values      prrv,     pay_input_values_f         pivf,     pay_balance_feeds_f        pbf,     pay_balance_types_v...
Read more