Saturday, September 2, 2023

Oracle Fusion Create New User As Worker For SCM

Open Oracle Cloud Fusion Url 



after Login Go to Tools (Role) then Security Console Then as below icon or Click on Home then select Tools 



then select User and Add User




after Add Info and Select Worker in Associate Person Type

then add those Roles 


ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT

ORA_ASM_APPLICATION_IMPLEMENTATION_CONSULTANT_JOB 

ORA_ASM_APPLICATION_IMPLEMENTATION_MANAGER_JOB

ORA_PER_EMPLOYEE_ABSTRACT

ORA_GL_GENERAL_ACCOUNTANT_JOB

ORA_GL_GENERAL_ACCOUNTING_MANAGER_JOB

ORA_PER_HUMAN_RESOURCE_MANAGER_JOB

ORA_PER_HUMAN_RESOURCE_SPECIALIST_JOB

ORA_FND_IT_SECURITY_MANAGER_JOB

ORA_PER_LINE_MANAGER_ABSTRACT

SQL Query to Convert number into Words for Money

SELECT INITCAP ( DECODE ( FLOOR (TO_NUMBER ( :amount)), 0, '', TO_CHAR (TO_DATE...