Blog / Category
Oracle Fusion
72 articles in this category
Creating Workers Oracle Fusion HCM API
Creating Workers in Oracle Fusion HCM via REST API Creating and Managing Workers in Oracle Fusion HCM Using REST APIs Instead of the Guided UI Flow Introduction…
Simplify Oracle Fusion Role Reviews with AI Agent
Introduction / Issue Managing user access and role assignments is an important part of Oracle Fusion Cloud security administration. Administrators freque…
User_Info_Details_Report
Introduction This report displays employee master information such as employee ID, name, person type, position, job grade, manager, contact details, employment…
Creating and Applying Receipts Through Lockbox Using FBDI
Step 1 – Create a Lockbox Navigate to Settings and Actions > Setup and Maintenance > Manage Lockbox, and define a new lockbox record. Step 2 – Confirm the Lockb…
Steps to Create Custom Role:
Login into the Dev Instance with Admin User Go to Tools and Click on Security Console Go to Roles and search for role, Click on Plan Management Role Click on dr…
Reporting Currency Vs Translation In Oracle Fusion
Introduction/ Issue: Organizations operating across multiple countries and currencies require accurate financial reporting in more than one currency. In Oracle…
Web Services : SOAP, REST Services
Web Services : SOAP, REST Services Introduction: Web Services are services offered over the web that enable communication between different applications. They a…
Debug Common Errors in SFTP-Based File Transfer Integrations
Use Case: This integration debugging script and approach is used to analyze and resolve common runtime errors in SFTP-based file transfer services, especially d…
OIC 25.04 New Features – Auto-Retry actions generation
I have an integration with one or more invokes and I want to apply retry functionality to them, e.g. retry on failure up to 3 times etc. Now you could implement…
Personalization Migration: ADF to Redwood Page
Introduction: Migrating personalization from ADF page (Classic UI) to Redwood UI Why we need to do: Oracle is modernizing its Fusion Applications UI/UX,…
WebLogic Security Hardening – Best Practices
WebLogic Security Hardening – Best Practices Introduction: Securing Oracle WebLogic Server is critical to prevent unauthorized access, data breaches, and compli…
WebLogic Upgrade from 12c to 14c
Introduction: Upgrading Oracle WebLogic Server from version 12c to 14c is essential for leveraging the latest capabilities, enhancing security, and aligning wit…
Weblogic .out files are not rotating issue.
Issue: In WebLogic Server, the .out log files (such as nohup.out or server.out) are not rotating properly, causing them to grow significantly in size—sometimes…
OTM Generate or creation New “Location”
OTM Generate or creation New “Location” Go to Home (home screen). Enter Shipment Management. Enter BLK Location Manager. The Location Finder menu…
Update Inactive Manager Assignment – Oracle Fusion
Introduction: This blog has the SOAP Webservice details that can be used to update the inactive manager assignments in Oracle Cloud application. Cause of the is…
Inactive Manager Assignment Query – Oracle Fusion
Introduction: This blog has the SQL query that can be used to pull the data of employees whose manager assignment is inactive even if the manager is active. Cau…
Configuration to update the same customer tax registration number for multiple customers/sites
Introduction : This blog has the configuration update the same customer tax registration number for multiple customers/sites Why we need to do : As per the lega…
How to skip deletion of the entries from AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS
Introduction : This blog has the configuration to skip the deletion of the entries from AR_STATEMENT_HEADERS and AR_STATMENT_LINE_CL Why we need to do : While c…
The project budget for the respective task code is not updated in oracle however it is available in Tririga.
Everyday(four times a day) project, budget and forecast files are interfaced from Tririga to oracle through integration DLK , OIC and finally in cloud. However…
KPI Notifications triggered after 24B upgrade for Project manager.
After 24B upgrade patch applied to Oracle fusion environment causing this issue. Solution: Run the “Update Project Performance Data Without producing report” pr…
Restricting Self-Approval in Oracle Fusion
Introduction: Addressing the self-approval concern for expenses and other documents after setting up a vacation rule in Oracle Fusion. You can prevent self-appr…
Updating bulk records pending under Inventory Transactions using Oracle Visual Builder Add-in
Introduction: The Oracle Visual Builder Add-in for Excel connects Excel spreadsheets with REST services, enabling you to retrieve, analyze, and edit business da…
Employee bank account update
The employee has created multiple bank accounts, and an incorrect bank account was mapped at the invoice level. So the payment has been rejected. Steps: Follow…
A new customer bank account number already exists to update the parent and child bank accounts
The customer account number already exists. So the user unable to add the bank for the customer. Steps: Follow the below steps to add the customer bank account.…
STEPS TO PERFORM REVALUATION IN FUSION APPLICATION
Introduction/ Issue Revaluation is a process of adjusting the accounted value of foreign currency denominated balances according to current conversion rates. Re…
To update the invoice distribution accounting date.
To update the invoice distribution accounting date. The business mistakenly entered the GL accounting date Jun-26 instead of Nov-23 and the invoice is cancelled…
To create a new check payment template
To create a new check payment template Prerequisites setup to create a new check payment template: Create a new “payment document” in bank account Create a new…
Mixed Balance Segment Payment Accounting
Introduction: The Legal Entity information in the Payable invoice is discordant with the Accounting Legal Entity. At the payment run, the Payment Process Reques…
SLA Rule Update
Introduction: To update the company and subaccount for the specific BU. Step: 1 Go to Setup and Maintenance > Setup: Procurement > Manage Account Rules(Receipt…
Blanket Purchase Agreement FBDI Process
bpa-word-document
On-Hand Inventory Balance FBDI Import Process
on-hand-inventory-word-document
Get Lookup Values from Cloud Using REST API
Introduction: This blog has the REST API Webservice details that can be used to Get the lookup values from Oracle Cloud application. Cause of the issue: For an…
Item Import Using SOAP Webservice – Oracle Fusion
Introduction: This blog has the SOAP Webservice details that can be used to import the item data into Oracle Cloud application. Cause of the issue: Busin…
How to defining Complex Scheduling for Scheduled Integration in OIC
Introduction/ Issue: How to defining Complex Scheduling for Scheduled Integration in OIC? Why we need to do / Cause of the issue: ICal Expressions in OIC is use…
Query to get Data Accesses of Users – Oracle Fusion
Introduction: This blog has the SQL query that can be used to pull the data access details of all the users irrespective of their status. Cause of the issue: Bu…
Employee Recall Query – Oracle Fusion
Introduction: This blog has the SQL query that can be used to pull the data of employees who are recalled to join the organization. Cause of the issue: Business…
Travel Expenses Query – Fusion Expense Module
Introduction: This blog has the SQL query that can be used to pull Travel expense data from Fusion Expense Module. Cause of the issue: Business wants a report t…
Employee Expenses Query – Fusion Expense Module
Introduction: This blog has the SQL query that can be used to pull employee expenses data from Fusion Expense Module. Cause of the issue: Business wants a repor…
Steps to configure Oracle Database server with Apache tomcat
Step to configure Oracle Database server with Apache tom 1) Copy Oracle Jar file ojdbc14.jar (or) ojdbc6.jar till the lib directory to tomcat server 2) Modify t…
Step to configure MYSQL with apache tomcat
Step to configure MYSQL with apache tomcat: 1) Copy mysql connection jar file to catalina_home lib directory 2) Configure that database parameter in server.xml…
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 cod…
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…
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 databas…
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…
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 re…
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…
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_N…
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…
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…
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 like below as…
MSserver1 is in ADMIN after a restart
At the time of restart some times few Managed Servers will be in Admin State. At the time we have to check logs login to the particular server Go to domain/serv…
Apache Redirection
We will get request from SEO for apache redirection redirect 301 url will provide by the SEO/dev team. Login to server sudo as root Go to /etc/httpd/conf…
How to check Stuck Threads in logs
At the time of stuck threads we will get alerts we can see the servers are in warning state at the the time we can login to the particular warning server grep -…
Weblogic boot.properties
Setting up boot.properties While starting weblogic server [including AdminServer], it will check for a file called boot.properties in <domain_home>/servers/Admi…
create a domain by using console mode
Steps to create a domain by using Console mode:– Go to <WL_HOME>/common/bin (WL_HOME=”D:\Oracle_Jun\Middleware\wlserver_10.3″> Execute config.sh -mode=co…
Creation of Domain GUI mode
Steps to create a domain by using GUI Mode Go to <WL_HOME>/common/bin (WL_HOME=”D:\Oracle_Jun\Middleware\wlserver_10.3″> Execute config.sh Provide domain name,…
Install WLS by using Silent Mode
Steps to install WLS by using Silent Mode:- Download sample silent.xml file Specify the values for the parameters BEAHOME, WLS_INSTALL_DIR and specify the necce…
Install WLS by using Console Mode
Steps to install WLS by using Console Mode:- Check the prerequisites like disk space, file permissions and compatibility Execute Weblogic setup executable file…
Configuration changes in SetDomainEnv.sh
JAVA_PROPERTIES configuraion in SetDomainEnv.sh:- login to particular server Go to Domain/bin Take backup of SetDomainEnv.sh vi SetDomainEnv.sh Edit SetD…
Installation of weblogic in GUI Mode
Steps to install WLS by using GUI MODE:- Check the prerequisites like disk space, file permissions and compatibility 2. Execute Weblogic setup executable file 3…
PGP Key Encryption in AP Payment Outbound Interface
PGP Key Encryption in AP Payments Generally, the PGP keys will be used to Encrypt and Decrypt the messages transferred between one system to another to enable t…
Query to get tax registration at supplier level – Oracle Fusion
The below query extracts the Tax Registration details such as Tax Regime Code, Registration Number of Suppliers from Fusion Applications. SELECT HP.party…
Custom Role and Custom lookup Creation in Fusion
custom-role-and-custom-lookup-creation-in-fusion This document describes how create a custom role and custom lookup in Oracle Fusion. In this document we have l…
AR Invoice Image Upload Using SOAP Request – Oracle Fusion
This blog contains sample payload to upload an image file in AR invoice attachments in Oracle Fusion Applications. During fusion implementation, we might come a…
Supplier Site Assignment Import Using FBDI – Fusion Applications
This blog describes the step by step process of Supplier Site Assignment migration in Fusion Application using File Based Data Import. Using this process we can…
Supplier Site Import Using FBDI – Fusion Applications
This blog describes the step by step process of Supplier Site migration in Fusion Application using File Based Data Import. FBDI Template: SupplierSiteImportTem…
Supplier Address Import Using FBDI – Fusion Applications
This blog describes the step by step process of Supplier Address migration in Fusion Application using File Based Data Import. FBDI Template: SupplierAddressImp…
Supplier Import Using FBDI – Fusion Applications
This blog describes the step by step process of Supplier migration in Fusion Application using File Based Data Import. FBDI Template: SupplierImportTemplate.xls…
Query to Find NonBillable Expense in Oracle Fusion
SELECT pcdl.prvdr_gl_period_name gl_period, trx_org.NAME expenditure_organization, prb.p…
Query to Find Project Estimation To Complete in Oracle Fusion
SELECT A.PROJECT_STATUS, A.OPERATING_UNIT_NAME, A.AGREEMENT_TYPE,  …
Query to find AR Open Balance Of a Project in Oracle Fusion
WITH FUNCTION get_outstanding_amount ( p_payment_schedule_id IN NUMBER,  …
PROJECT UNBILLED BALANCES- FUSION
This report will display all project unbilled details. SELECT ppa.project_id, ppa.segment1 project_number, N…