Friday, March 3, 2023

Oracle Cloud ERP : Missing Scheduled Processes function while creating an integration user

Issue: 

Missing 'Scheduled Processes' function under the Navigator > Tools

Investigation:  

Default installation does not assign roles such as employee, contigent worker  applocation admin etc to the SuperUser Account.

Solution:

Simply assign the Employee role to that user using superUser Account. Logout and login with the user and navigate to Tools >> nlw you will be able to see the function "Scheduled Processes".

Role :

Name: Employee

Code: ORA_PER_EMPLOYEE_ABSTRACT 

SOA_ADMIN_ROLE
Code: SOA_ADMIN_ROLE

Navigation >> Tools >> Security Console >> Users






Save and close


Now run the Retrieve Latest LDAP changes to reflect the roles.

Tools >> Scheduled Processes >> Scheduled New Process >> submit the job : Retrieve Latest LDAP Changes








Once the sync roles job succeeded, login the ERP with the created User and verify if scheduled processes and Reports and Analytics exist under Tools.


ERP - Register the CSF key | subscribe to Oracle Fusion Cloud | Subscribe to Fusion Business Events and FBDI Callback

Usecase: To Subscribe to Fusion Business Events and FBDI Callback: 

In a FA-based SaaS instance, the outbound call of a webservice uses a OWSM security policy which retrieves the credentials for the call from a CSF Key. This means that you need to register a CSF key for every connection to an external system

Register CSF key(Identity domain and OIC Service name) under Manage Security of SOA Composer in Fusion SaaS.

Detailed Steps with screenshots:

Login to soa composer

https://<Oracle Fusion ERP Cloud Instance>/soa/composer


Manage Security


Provide the CSF key details. The details will be fetched from OIC instance >> profile >> about 

CSF key: concating with Identity domain and OIC Service instance name

And provide OIC instance user and password details.






Note: to know how to create an integration user in ERP, follow my below link:

https://soalicious.blogspot.com/2023/03/erp-create-integration-user-with.html

Oracle Cloud ERP - Create an Integration user with adequate roles and Priviledges | Assign Required roles to an Integration User

Usecase : Here, we will create an Integration user and assign roles to Integration user in Oracle Fusion ERP cloud using security console.

Roles to add:

  • Add Function Security Policy : 
    • Name: Manage Webservices catalog Code: FND_MANAGE_CATALOG_SERVICE_PRIV : Privilege to Manage Web service Catalog.
  • Add Role:
    • Role1: Name: Integration Specialist Code:ORA_FND_INTEGRATION_SPECIALIST_JOB : it is a job role which inherits Oracle ERP Cloud roles but does not include any data access. Individual responsible for planning, coordinating, and supervising all activities related to the integration of enterprise information systems.
    • Role 2: Name: SOA Operator Role , Code: SOAOperator: SOA application operator, for common operational tasks like start, stop  monitor, backups.
    • Role3: Name: Attachments User , Code: AttachmentsUser: provides access to the Attachments Security which enables user to download log or output file using ERP Integration service.
    • Role 4: Name: Employee , Code: ORA_PER_EMPLOYEE_ABSTRACT
    • Role5: Name: SOA_ADMIN_ROLE, Code: SOA_ADMIN_ROLE : this is needed to access the SOA composer to register the CSF key.
Detailed steps with screenshots:

Login to ERP >> Home Navigation >> Tools >> Security console


Users >> Add User account



Provide user details >> Save and close


Roles >> Create Role



Provide Role name, code and Role category as " Common - Job Roles" >> Next


Add Function Security Policy >> 

Name: Manage WebService Catalog
Code: FND_MANAGE_CATALOG_SERVICE_PRIV



Add Role  >> Next

Role1: 
Name: Integration Specialist
Code: ORA_FND_INTEGRATION_SPECIALIST_JOB

Role 2:
Name: SOA Operator Role
Code: SOAOperator

Role 3 :
Name: Attachments User
Code: AttachmentsUser






Add User >>search username >> add user to role >> Save and Close




Users >> search the created user >> click kn the user >>Edit >> Add Role

Role 1:
Name: Employee
Code: ORA_PER_EMPLOYEE_ABSTRACT

Role 2: 
Name: SOA_ADMIN_ROLE
Code: SOA_ADMIN_ROLE






Save and close


Tools >> Scheduled Processes >> Scheduled New Process >> submit the job : Retrieve Latest LDAP Changes








Once the sync roles job succeeded, login the ERP with the created User and verify if scheduled processes and Reports and Analytics exist under Tools.

 



Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...