Oracle Fusion

Setting JAVA_HOME and the path in linux environment

Setting JAVA_HOME path 1.Open the .bash_profile using vi editor for the root user 2.Add the following environment variable in the file. The following is the code snippet of .bash_profile. The…

Read More

Create PO Change Order in Oracle Cloud – Add Project Info To Existing PO Line Using SOAP request

This blog describes the sample request for creating Change Order in Oracle Cloud for the existing Purchase Order. This Change Order is to add project details in PO line and…

Read More

Data Source and steps to configure in weblogic

Data Source:- A data source is an object which is used to establish connection between data source contains info about the database like Hostname of the database server, port number,…

Read More

How to see Active connections in weblogic 12c

login to the console Go to Environment Click on Datasources Go to monitoring Then we will see active connections current count and active connections high count.

Read More

Weblogic server health status Not reachable

Few servers  are currently unreachable at the time of post-migration cell recycle. At this time the server state is running but the server health state is Not reachable. At this…

Read More

Application went to Admin after configuration changes in weblogic 12c

1.When we have done any changes in SetDomainEnv.sh 2. We have to restart the servers to reflect the changes. 3. Some times  after the restart of the servers the servers…

Read More

User Status Query – Oracle Fusion

The below query extracts the list of employee users along with their user status and employee status SELECT pu.username USER_NAME ,papf.person_number EMPLOYEE_NUMBER ,ppn.first_name EMPLOYEE_FIRST_NAME ,ppn.last_name EMPLOYEE_LAST_NAME ,DECODE(SUSPENDED,'Y', 'Inactive User','N', 'Active…

Read More

Query to get list of Data Accesses of users – Oracle Fusion

The below query extracts the list of data accesses given for any user in Oracle Cloud Application ————————————————–***************——————————————– SELECT gl.name "Security Context Value", pr.role_name"Job Role Name", pu.username "User Name", role.ACTIVE_FLAG…

Read More

Transmission Configuration For Payment Outbound Interface – Oracle Fusion

Transmission Configuration AP payments made in Oracle Could sends payment files to banks to make the real payment to vendors. In such cases, file transfer link has to be enabled…

Read More

How to run a cron in background

How to run a cron in background Login to the server where the cron exists sudo as root check the cront list –>  crontab -l then select cron and run…

Read More