Blog / Category
Fusion
208 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…
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…
Forecast-Based Component Demand in Fusion SCP
Introduction/ Issue: Developing a custom BI Publisher (BIP) report in Oracle Fusion Supply Planning to provide visibility into component dependent demand based…
Query to get the details of Invoice and Supplier Payment Method Mismatch in fusion.
WITH FUNCTION f_payment_method_at_supplier ( p_vendor_id IN NUMBER ) RETURN VARCHAR2 IS payment_method VARCHAR2(250); — — This function will tell us payment met…
Query to get Sales Order in fusion.
SELECT dha.source_order_id AS sourcetransactionidentifier, dha.order_number AS sourcetransactionnumber, dha.source_order_system AS sourcetransactionsystem, dha.…
Understanding Ledger in Oracle ERP Fusion
Understanding Ledger in Oracle ERP Fusion Introduction / Issue: A recurring gap I see with consultants and even client teams new to Oracle Fusion Financials is…
Oracle Fusion Financials 26B – GL AI Agent Setup Guidance
GL_AI_Agent_26B_Blog Oracle Fusion Financials 26B – GL AI Agent Setup Guidance Introduction / Issue: For Oracle Financials consultants planning to enable and ru…
Supplier Calendar Calculation
Supplier Calendar – Clipper -Supplier Test Step 1 : Define ExceptionsNavigation: Setup and maintenance 🡪 Global Search 🡪 Manage Schedule Exceptions 🡪 Create…
Recovering Deleted Shipment History in Fusion SCP; Target Refresh vs Net Change
Introduction/ Issue: To reload all existing shipment history into Fusion that was deleted when the Load Planning Data from Flat Files process was run in Target…
Assembly and Component Items Demand Shortage Report in Fusion SCP
Introduction/ Issue: Developing a BIP report in Fusion to identify component demand shortages for assembly items and improve supply planning decisions. Why we n…
How a Redwood Page differs from a Classic ADF page
Introduction: Redwood Pages and standard ADF pages represent two different approaches to building user interfaces within Oracle applications. While standard ADF…
Query to get vendor master with missing GST Numbers report in fusion.
SELECT Qry_rslt.”Supplier Name” ,Qry_rslt.”Supplier Number” ,Qry_rslt.”Supplier Site Name” ,Qry_rslt.”Supplier Status” ,Qry_rslt.”Inactive Date” ,Qry_rslt.”Proc…
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…
How AI helps in Oracle Fusion Financials
Introduction/ Issue: Modern finance teams using Oracle Fusion Financials deal with large transaction volumes, tight close timelines, compliance pressure, and gr…
Load Sales Forecast into plan without running the plan Upload
Prepare the DPForecasts.csv file The file name should not be changed. Date format must be “YYYY/MM/DD”. If part number has leading zeros, then change the cell t…
Add History for a new Item or new Item-Customer
Make sure the new item/customer/customer site is collected and exists in Oracle cloud. Prepare the ShipmentHistory_SI_RD.csv file to load Shipments History data…
Creating Zero Amount Payments in Oracle Fusion Payables
Introduction/ Issue: In Oracle Fusion Payables, there are scenarios where invoices get fully adjusted through credit memos, prepayments, or rounding adjustments…
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…
Converting UTC to Local Time with DST in Oracle Integration
Working with time zones can be tricky—especially when Daylight Saving Time (DST) comes into play. This Oracle Integration recipe offers a ready-to-use solution…
Exporting Plan Data in Oracle Fusion Supply Chain Planning
Introduction/ Issue: In Oracle Fusion Supply Chain Planning, planners often need to extract plan measure data from demand or supply plan layouts for reporting a…
Configuring Work Orders to Align with Resource Requirements in Fusion Supply Chain Planning
Issue: The Work Orders for a specific item loaded from EBS into Fusion Supply Chain Planning are appearing in the Buyer Material Plan within the supply plan. Ho…
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,…
Oracle AI Agent: Bringing Intelligence to Enterprise Workflows
Introduction Oracle AI Agent is a powerful, intelligent assistant designed to automate tasks, guide users, and deliver smart recommendations within Oracle Cloud…
Use Oracle Chatbots for faster results with less effort
Introduction In today’s fast-paced digital landscape, users expect instant support and seamless interactions. The AI Oracle Chatbot, powered by Oracle Digital A…
Query to get Employee Expense Report in fusion.
SELECT eer.expense_report_num AS “EXPENSE REPORT NUM”, ee.expense_source AS “EXPENSE SOURCE”, papf.person_number AS “EMPLOYEE NUMBER”, ppnf.full_name AS “EMPLOY…
Query to get India AP GST Tax Register Report in fusion
SELECT taxdet.invoice_id, taxdet.invoice_amount, taxdet.line_type_lookup_code, taxdet.description, taxdet.invoice_date, taxdet.gl_date, taxdet.supplier_site_nam…
How to define Work Structure
Manual-Usage: The manual should be used along with the Fusion HCM application in order to familiarize themselves with the navigation and functionality. 1. Login…
How to create Fusion PO
1.- Log in with our credentials 2.- Clic on the “Purchase” module and select “Purchase order” 3.- Go to the task bar and choose the “Create order” option. 4.- F…
AR Customer Collector Portfolio Report
Introduction: This blog has the SQL query that can be used to pull the data for the AR Customer Collector Portfolio Report Cause of the issue: Business wants to…
AR Customer Dunning Strategy Status Report
Introduction: This blog has the SQL query that can be used to pull the data for the AR Customer Dunning Strategy Status Report Cause of the issue: Business want…
New TDS rate creation
Business requested a new TDS rate for the supplier to apply at invoice level. Steps: Load new recovery tax rate. Navigator: Setup and Maintenance à Financials à…
Oracle PLSQL to Generate XML Tag Using Standard Functionality
declare l_ctx dbms_xmlquery.ctxHandle; l_clob clob; begin l_ctx := dbms_xmlquery.newContext(‘select * from <TABLE_NAME>’); dbms_lob.createtemporary(:g_clob,true…
New tax rate creation
Business requested a new VAT to apply the tax at the invoice level. Steps: Go to Set up and Maintenance > Financials > Transaction Tax > Manage Tax Rates and Ta…
How to pass multiple parameters in REST API web service
Introduction: The purpose of this document is to demonstrate how we pass multiple set of parameters in REST API through Postman. Cause of the issue: Whenever we…
Tomcat upgradation 8.x to 9.x
Introduction: Apache Tomcat Upgrading from Tomcat 8 to Tomcat 9 is a critical step for taking advantage of the latest features, improved performance, and enhanc…
User is not as employee roles in Oracle Cloud
Introduction: This blog has the SQL query that can be used to pull the data for the oracle cloud users having what roles & for which BU it is assigned if it is…
Cloud Critical Users Roles with respective BU Wise
Introduction: This blog has the SQL query that can be used to pull the data for the oracle cloud critical users having what roles & for which BU it is assigned.…
Supplier Bank Account’s Branch BIC (Swift Code) Update Using REST API – Oracle Fusion ERP Cloud
Introduction: This blog has the REST API details that can be used to update the Supplier Bank Account’s Branch BIC (Swift Code) in Oracle Cloud application. &nb…
Delete AR Invoice via REST API Oracle Fusion Cloud
Introduction: This blog has the REST API details that can be used to delete AR Invoice in Oracle Cloud application. Cause of the issue: Business wants to…
OTM Registration of customers and suppliers
OTM Registration of customers and suppliers The first part of the manual corresponds to the finance area, with the incorporation of customers and suppliers into…
Enabling Oracle Fusion BIP report execution on Fusion Standard Page by using Dashboard
Introduction: In General, BIP reports can be run by an ESS job or from Reports & Analytics. We’d like to demonstrate another way for launching a BIP report on t…
Bank Number Missing Field From Expenses
Introduction Bank branch details missing in the expense. We need to go Manage Administrator Profile Option with this code CE_USE_EXISTING_BANK_BRANCH to add thi…
Data Access Control Issue for Account Payable
Introduction: If the user has the below roles and data access set for a specific BU, it is showing all BUs in the payable module. It should be shown only one BU…
Project Tasks Import FBDI Query in Oracle Fusion ERP Cloud
Introduction: This blog has Project Tasks Import FBDI Query that can be used to retrieve data as per Project Tasks FBDI Format in Oracle Fusion Cloud applicatio…
Supplier Site PayGroup Mass Update Using REST API – Oracle Fusion ERP Cloud
Introduction: This blog has the REST API details that can be used to update the Supplier Site PayGroup in Oracle Cloud application. Cause of the issue: B…
SQL to get the details of Cloud Users who logged within the last 30 days
Introduction: The purpose of this document is to provide detailed SQL query overview of the cloud users who logged within the last 30 days. Cause of the issue:…
SQL to get the details of Cloud Fusion Projects (PPM)
Objectives : The purpose of this document is to provide comprehensive information on project headers and its line-level details. This document aims to offer a d…
Supplier Unmasked bank details Report Query
Supplier Unmasked bank details Report Query Introduction: This SQL query is used to fetching the data of supplier unmasked bank details to identify if th…
Customer collector name at site level query
Customer collector name at site level query Introduction: This SQL query is used to fetching the data of customer and collector name at site level.  …
Conquering Application Deployment Failures in WebLogic
Introduction: Deploying applications to WebLogic can often be a daunting task, fraught with potential pitfalls. In this post, we’ll delve into common deployment…
How to list all integrations in an OIC instance using REST API
Introduction: This process would overview how to use the rest API to list available integrations in an OIC instance. Cause of the issue: As there is no o…
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…
Worker Email Change Using REST API – Oracle Fusion
Introduction: This blog has the REST API details that can be used to update worker email details in Oracle Cloud application. Cause of the issue: Business wants…
Worker Creation Using REST API – Oracle Fusion
Introduction: This blog has the REST API details that can be used to create worker data in Oracle Cloud application. Cause of the issue: Business wants t…
Corporate Card Transaction amount is not appearing amount field.
Introduction: Corporate card transaction amount is not showing in the user’s profile. The user should have these two roles of access in their account: travel ma…
Remove all BU access in the Cash Management
Introduction/ Issue: Cash Management data security is NOT partitioned by Business Unit, therefore its security policies allow access to all BUs. Why we need to…
Query to get Payment Reversal
Introduction Business requested to provide the Payment reversal information Cause of the issue: Business want to cross check with Payment reversals How do we so…
Oracle Internet Of Things (IoT)
Dear Readers I would like to explain more about the Oracle IoT Cloud services. Will provide continues blogs on this technology. In this block we will explore wh…
EMPLOYEES HOLIDAY CALENDAR LIST (Core HCM)
Introduction: This SQL query is used to fetch the Holidays list for Employees like Employee number, Holiday name, Start date, End date etc… Cause of the issue:…
EMPLOYEE SALARY DETAILS QUERY (Core HCM)
Introduction: This SQL query is used to fetch the data of Employees Salary details (CTC)like Annual salary, Fixed CTC, Employee number, DOJ, Base element name e…
Projects Import FBDI Query in Oracle Fusion ERP Cloud
Introduction: This blog has Projects Import FBDI Query that can be used to retrieve data as per Projects FBDI Format in Oracle Cloud application. Cause o…
Customer Name Mass Update Using REST API – Oracle Fusion ERP Cloud
Introduction: This blog has the REST API details that can be used to update the customer’s name in Oracle Cloud application. Cause of the issue: Business…
New Postal Code Blog -2
new-postal-code-blog-2
overstating the PO value and needs to be removed _Issue1
overstating-the-po-value-and-needs-to-be-removed-_issue1
ESS Job History Query in Oracle Fusion ERP Cloud
Introduction: This blog has ESS Job History Query that can be used to retrieve the ESS Job historical information in Oracle Cloud application. Cause of t…
Update customer contact email address as Inactive Using SOAP Webservice – Oracle Fusion ERP Cloud
Introduction: This blog has the SOAP Webservice details that can be used to update the customer contact email address as inactive in Oracle Cloud application. &…
How to Create Vacation Rule Set
Introduction we will be discuss about the vacation rules setup in oracle cloud. Vacation rules setup is very important in the approval setup process. Vacation r…
How to Create Manage Delegation
Introduction/ Issue: A delegate is a person who’s authorized to perform expense entry and management of another person’s expense reports. A delegation is the re…
Roles and Role Types
roles-and-role-typesroles-and-role-types
Update customer send statement and send dunning flag Using SOAP Webservice – Oracle Fusion
Introduction: This blog has the SOAP Webservice details that can be used to update the customer send statement and send dunning flag into Oracle Cloud applicati…
Update customer statement delivery method Using SOAP Webservice – Oracle Fusion
Introduction: This blog has the SOAP Webservice details that can be used to update the customer statement delivery method into Oracle Cloud application. Cause o…
Carrier Lookups
carrier-lookupsroles-and-role-types receive-item-into-inventory requisition-by-min-max-n-replenishment
Display OTBI analysis as Infolets in Fusion (SaaS)
Objective: To show OTBI analysis as a infolet in infolet section in a form of widget in springboard section in SaaS Home Screen. User getting the latest info in…
How to connect ATP Database from SQL Developer
Objective: The intent of this content to show how to connect ATP Database from SQL Developer tool. To connect the ATP database we need wallet. Wallet file need…
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…
Update Item Using SOAP Webservice – Oracle Fusion
Introduction: This blog has the SOAP Webservice details that can be used to update the item data in Oracle Cloud application. Cause of the issue: Business wants…
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…
EMPLOYEE WORK SCHEDULE UPDATE (Core-HCM)
Introduction: This SQL query is used to fetching the data of Employees Work Schedule changes like Work Schedule id, Name etc… In this Last update date is used a…
EMPLOYEE ASSIGNMENT UPDATE (Core-HCM)
Introduction: This SQL query is used to fetching the data of Employees Assignment changes like Manager change, location change etc… In this Last update d…
Oracle Fusion HCM _ Hire an Employee
Hi, this blog post help you to Hire an employee in Fusion HCM.hire-an-employee-in-fusion-hcm
Oracle Employee Self Service
Employee Self-Service: Personal Information Personal Information: Able to view all Personal Records and Able to Edit Demographic Details. (Pencil Icon is for Ed…
Oracle Fusion Absence_ Employee Navigation
Hi, this blog post helps Employees to Manage Leave in Fusion employee-absence_management_fusion-hcm
Oracle Fusion Absence_ Worklist Navigation
Worklist includes transactions routed to any approval groups that you belong to, even though you may not have approved the transactions. You can edit a pending…
Multi Period Accounting
Introduction Multi period accounting (MPA) enables users to create accounting for a single accounting event for more than one GL period. The functionality is pr…
Create Payables Invoice Aging Period
Introduction. Use the AP Invoice Aging report to analyze the cash flow of unpaid invoices and your uncleared payments. The report organizes uncleared items into…
Employee Revoke (Core Hr-HCM)
Introduction: This SQL query is used to fetching the data for Employees who are Revoked means cancelled the termination those employees will fetch based on last…
Wheebox Assessment tests (ORC-HCM) Query
Introduction: This SQL query is used to fetching the data for candidates who are applied various assessment tests (Wheebox) at the time of recruiting like one c…
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…
How To Get Business Unit Of Customer in Fusion Receivables
Introduction: Customer & Business Unit link Table in Oracle Fusion. Cause of the issue: Since the customer is not assigned to a BU in Fusion. Customer Site is a…
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…
Query to Extract Absence and Long Leave details in Oracle Fusion HCM
Query: SELECT empl_leave_trxn_id, employee_id, leave_name, leave_type_id, To_char(start_datetime, ‘DD-MON-YYYY’) from_date, To_char(end_datetime, ‘DD-MON-YYYY’)…
Grade Creation Notification in Fusion HCM via Alert Composer
Objective: The intent of this document is to understand how notification works in Oracle Fusion Alert Composer. Scenario: Here we can see grade creation in fusi…
Fusion HCM Candidate Query
Introduction: This SQL query is used to fetching the data for candidates who are attended various assessment tests at the time of recruiting. In this assessment…
Creating payable invoice auto approval BPM rule in Oracle Fusion
Creating payable invoice auto approval BPM rule in Oracle Fusion: In this document, we discuss in detail the invoice approvals workflow functionality in Oracle…
Oracle Fusion AP Recurring Invoice Process
Recurring Invoices You can enter invoices for periodic business expenses for which you may not receive invoices, such as rent. To enter recurring invoices, firs…
The payroll relationship or assignment isn’t eligible for the element Statutory Deductions on the date YYYY-MM-DD
Introduction: While create Manage Users to hire a new employee the following error occurs “the payroll relationship or assignment isn’t eligible for the element…
To create payment in Oracle Fusion by payment process request
To create a payment in Oracle Fusion by payment process request: We have two options in Oracle Fusion to make payments to suppliers. Either we can create a manu…
ASSERTION ERROR IN WEBLOGIC
Problem:-Assertion Error Cause:- We will get the Assertion Error in the console because while running managed servers some one clear the cache. So that we will…
Data Migration and Conversion Strategy
Data migrations generally result from the introduction of a new system. This may involve an application migration or consolidation in which one or more legacy s…
SSH Key Upload in Oracle Fusion
When we use SSH keys for authenticating third party servers, the Public key will be configured in third party server whereas Private key will be configured in O…
SSH Key Generation for Third Party Server Authentication
It’s a secure access credential used in the Secure Shell (SSH) protocol. This is one of the authentication methods that Oracle uses to communicate with third pa…
Weblogic Servers getting failed on restarting after upgrade failed.
Issue: Servers getting failed on restarting after upgrade failed. Description: For upgradation purpose all the servers are stopped and tried for reconfig.sh but…
Create Chart of Accounts Structure in Fusion
Key Flexfield Structures A key flexfield structure arranges the segments of a key so that you can reuse a single key flexfield in multiple combinations of the s…
Update (redeploy) a Web application in weblogic
When you update a Web application, WebLogic Server redeploys the archive file or exploded directory. Update a Web application if you have made changes to it and…
Creating a Custom Payment Process Profile (PPP) in Oracle Fusion:
Creating a Custom Payment Process Profile (PPP) in Oracle Fusion: Payment process profiles include several types of information, such as specifications for paym…
How to fix deployment is in start running state- weblogic 12c
When we see the app is in start running state at the time of deployment in weblogic 12c Go to the logs if you didn’t see any issues Just try to restart the mana…
Weblogic app installed state
Some times we will get the status of application is INSTALLED. The admin server console shows all deployments in INSTALLED state when they should be showing as…
Uninstall Cloudamize agent
How to uninstall cloudamize agent on servers Sudo to host as root user cd /usr/local/cloudamize/bin/ ./uninstall_cmizeagent.sh check the process and make sure n…
How to delete content from crontab
How to delete total content from crontab login to the server su – username crontab -e esc:%d Note: if you need to delete total content(all lines) from cr…
Oracle Fusion Rapid Implementation: (Financials)
Oracle Fusion Rapid Implementation: (Financials) Rapid Implementation is an Excel (Spreadsheet). These features help to upload the setup data in Oracle Cloud in…
How to fix INVALID status for RAC component in dba_registry
Before upgrade or after upgrade, database may show INVALID status for component Real Application Clusters in dba_registry as below . SQL> select comp_nam…
How to check weblogic version
To check weblogic version From registry.xml from Middleware_Home Go to Middleware_Home under which weblogic is installed and look for a file registry.xml Defaul…
Create a Primary Ledger & Specify Ledger Options in Fusion.
Create Primary Ledger Create a primary ledger as your main record-keeping ledger. A primary ledger records transactional balances by using a chart of accounts w…
Create Chart of Accounts Value Sets in Fusion.
Manage Chart of Accounts Value Sets A value set is a group of valid values that you assign to a flexfield segment to control the values that are stored for busi…
How to Create the boot.properties in IDCS Asserter
Problem: When you are running the weblogic in production mode and when you try to start the weblogic using nohup then there is no chance to enter the username a…
FAILED_NOT_RESTARTABLE state. in weblogic 11g
Server Failed_not_Restartable State in Oracle Weblogic 11g when we have go through the weblogic console and see any managed server in FAILED_NOT_RESTARTA…
Create Currencies and Currency Rates in GL fusion.
Create Currencies and Currency Rates in GL fusion. This chapter contains the following: Currencies Conversion Rate Types Daily Rates Currencies Considerations f…
Create accounting calendars in GL fusion.
Accounting Calendar Options Define an accounting calendar to create your accounting year and the periods it contains. Specify common calendar options that the a…
[Security:090295]caught unexpected exception, No such object in Weblogic Remote managed Server.
Problem: <[Security:090295]caught unexpected exception, No such object> <[Security:090303]Authentication Failed: User weblogic weblogic.security.providers.authe…
SQL Query to retrieve User Roles – Fusion Applications
Query: SELECT pu.username,prdt.role_id, prdt.role_name, prd.role_common_name FROM per_user_roles pur, per_users pu, per_roles_dn_tl prdt, per_roles_dn prd WHERE…
Query to get Organization detail in Fusion
Overview : Below query to give the organization information in Fusion Query: SELECT hra.organization_id as bu_id ,hro.name organization_name ,hra.busines…
To create an Interest Invoice in Oracle Fusion:
To create an Interest Invoice in Oracle Fusion: Created automatically by payables, for the amount of interest calculated on the overdue amount of an original in…
To see the active servers count in weblogic
Steps: login to the weblogic console Go to Domain Structure Under Domain Structure Click on deployments Click on monitoring tab Now you can able to see number o…
Create Journal on a Spreadsheet Fusion
Please make sure to open the period where you want to post the journal. Let us create the following journal on a spreadsheet- Navigation- Go to General Accounti…
System variable to get current language by default in Oracle Fusion BIP report
Objective : Sometimes having a requirement to build the BIP report to display records other than English (ex: Arabic, French, German etc). In Order to build suc…
Tax only invoice
TAX only invoice
Smart view in Fusion
smart-view-in-fussion
Rollback depreciation after period close
rollback-depriciation-after-period-close-in-r12
Manage Accounting periods in Fusion
Manage-Accounting-periods-in-fusion
Valueset maintaince in fusion
Value set maintenance
ACH Process
ACH-process-in-fusion
OPMNCTL startall Fails with “unexpected exit: status 4200”
While trying to start the opmnctl services in idm we are getting 4200 error code as below applmgr@*****:~ $ applmgr@*****:~ $ /*****/fmw/idm/instances/IDM_inst1…
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 take Thread dumps from console
How to take Thread dump from weblogic administration console. Login in to the console Under Domain Structure Go to Environments Click on servers( It will displa…
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…
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…
Fusion – Query to extract Oracle Enterprise Contract Clauses
Cloud Enterprise Contract Clause Query ============================ select ch.contract_number, cab.label||’ ‘||caa.article_title from okc_k_headers_vl ch,okc_k_…
Fusion – Query to extract Customer Details
select hp.party_name customer_name, a1.account_number customer_number, a3.STATUS site_status, SITE_USE_CODE,LOCATION,PRIMARY_FLAG ,PARTY_SITE_NUMBER,A5.ADDRESS1…
Fusion – Global Human Resources Views
Global Human Resources Views EEC_CONTEST_TEMPLATE_HDR_VL EEC_METRICS_VL EEC_REWARDS_VL HCM_EXTENDED_LOOKUP_CODES_VL HR_ALL_ORGANIZATION_UNITS HR_ALL_ORGANIZATIO…
Fusion – Sample Payload For FindCustomerAccount Operation In TCA Account Web Service
SOLUTION Below are some sample payload for findCustomerAccountOperation: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”…
Fusion – Update Supplier, Supplier Site, Supplier Contact Payload – Webservice
<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/”…
Fusion – Create Supplier, Supplier Site, Supplier Contact Payload – Webservice
<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/”…
Fusion – Sample Payload To Update Descriptive Flexfield On Internet Supplier Portal Invoice
Sample Payload to update AP Invoice Header level DFF attribute: Payload: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”…
Project Expenditures Import Using FBDI – Oracle Fusion
This blog describes the step by step process of Project Expenditures data conversion in Fusion Application using File Based Data Import. FBDI Template: ProjectU…
Fusion Reporting Sequence
Fusion Reporting Sequence Step by step process to create reporting sequencing in Fusion
Multiple Customers having same bank account
customer-bank-account This is to know how to add multiple customers which share the same bank account details. user cannot add the bank details directly, using…
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…
Customer Site Usage Import Error Query – FBDI Oracle Fusion
The below query extracts the error details along with interface attributes of Customer Site Usages import using FBDI in Fusion Applications. SELECT distinct err…
Customer Site Import Error Query – FBDI Oracle Fusion
The below query extracts the error details along with interface attributes of Customer Sites import using FBDI in Fusion Applications. SELECT distinct err.messa…
Customer Contact Points Import Error Query – FBDI Oracle Fusion
The below query extracts the error details along with interface attributes of Customer Contact Points import using FBDI in Fusion Applications. SELECT distinct…
Customer Account Import Error Query – FBDI
The below query extracts the error details along with interface attributes of Customer Account import using FBDI in Fusion Applications. SELECT distinct err.mes…
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 Contact Import Using FBDI – Oracle Fusion
This blog describes the step by step process of Supplier Contacts migration in Fusion Application using File Based Data Import. Using this process we can create…
Query to get HCM Extract Input Values in BI Report
Introduction This Post Provides the SQL Query that returns HCM Extract Input Values in BI Report Query SELECT TO_DATE (par_val.flow_param_value, ‘YYYY-MM-DD’) F…
Employee’s Supervisor Details Query
Introduction This Post Provides the SQL Query that returns Employee’s Supervisor Details Query SELECT papf.person_number employee_number, ppnf.full_name employe…
Getting HCM Extract Input Values in Fast Formula
Introduction This Post Provides the Detail to get HCM Extract Input Values in Fast Formula Sample Fast Formula PERSON_NUMBER_PARAM = GET_PARAMETER_VALUE(‘PERSON…
Query to get Last Run Parameter Value in BI Report
Introduction This Post Provides the SQL Query to get Last Run Parameter Value in BI Report Query SELECT TO_DATE (SUBSTR (rpj.VALUE, INSTR (rpj.VALUE, ‘”}’) – 10…
Employee Assignment Details Query
Introduction This Post Provides the SQL Query that returns the Assignment Details of the Employees Query SELECT peo.person_number employee_number, loc.in…
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…
How to Define a PROJECT in FUSION Applications
Description Step how to Define a PROJECT in FUSION Applications. Define the Implementation Project. Please find the below steps to define a project Step1: Login…
Assign Offerings and options to a Project and How to Assign Project tasks to the Users
Step1: Click on Next button to assign Offerings and Options. Which we have planned to implement. we will navigate to Select offerings to implement window as bel…
How to Define a CALENDAR in FUSION Applications
Description Step how to Define a CALENDAR in FUSION Applications. 1 Define a CALENDAR Please find the below steps to define a CALENDAR Step1: Login as Applicati…
How to Add a Year to the CALENDAR in Fusion Applications
Description Step how to Add a Year to the CALENDAR in Fusion Applications. When a financial year ends and starts a new financial year, we have to define calenda…
How to Define a Value Set In Fusion Applications.
Description Step how to Define a Value Set In Fusion Applications. Step1: Login as Application User. Step2: you will be in home page as below. Step3: we need to…
How to Assign GL Roles to the User
Description. Step to how to Assign GL Roles to the User. Step1: Login as Application User. Step2: you will be in home page as below. Step3: Click on the Securit…
How to Setup the Default Business Group in Fusion Application
Description Step how to Setup the Default Business Group in Fusion Application. Please find the below setups to set up the default Business Group Step1: Login a…
How to Create the Primary Ledger in Fusion Financial’s
Description Step how to Create the Primary Ledger in Fusion Financial’s. Please find the below setups for creating the Primary Ledger. Step1: Login as Applicati…
How to setup the Default JE Category in Fusion Financial
Description Step How to setup the Default JE Category in Fusion Financial. Please find the below setups to Setup the default JE Category Step1: Login as Applica…
Create Bank, Bank Branch, Bank Account in Oracle Fusion Applications
Description Step how to Create Bank, Bank Branch, Bank Account in Oracle Fusion Applications. Please find the below steps to define a Bank, Bank Branch and Bank…
Inventory Org setups in Fusion
Description This post will help to understand basic concepts of Define Inventory Organization. An Inventory organization is the facility to store and transact I…
Supplier Refund Process in Oracle Fusion Applications
Description Refund is the amount, which we have already paid to our Supplier against his services or Purchase Goods and now we have taken back this Payment or s…
Fusion HCM – Steps to Create a Basic HCM Extract
Description: Step 1:An HCM Extract is created from the below Navigation : Navigator -> Data Exchange -> Tasks -> Manage Extract Definitions -> Create Step 2:Sel…
Requisition Creation and Approve process in Fusion
Description A requisition is used in business as an internal document used to notify stores or the purchasing department of items that are needed or need to be…
Fusion HCM – Automating Payroll Batch Loader
Description This post illustrates what are the steps we needs to follow for Automate payroll batch loader in Fusion Application. Below are the Steps to Automate…
PROJECT UNBILLED BALANCES- FUSION
Introduction This Post illustrates the steps required to find PROJECT UNBILLED BALANCES- FUSION Application Script to PROJECT UNBILLED BALANCES- FUSION This rep…
Fusion HCM – Managing an Array Type Fast Formula
Below is a Sample Array Type Fast Formula : DEFAULT_DATA_VALUE FOR PER_HIST_ASG_ASSIGNMENT_ID IS 0 DEFAULT_DATA_VALUE FOR PER_HIST_ASG_ASSIGNMENT_TYPE IS ‘x’ DE…
PA – Project Revenue exception
Introduction This Post illustrates the steps required to project Revenue Exception in Fusion Application. Script to PA – Project Revenue exception SELECT pcdl.p…
Query for Project Accounting Labor Revenue in fusion Application
Introduction This Post illustrates the steps required to Project Accounting Labor Revenue in fusion Application Script to Project Accounting Labor Revenue in fu…
PA Invoice Detail in Fusion Application
Introduction This Post illustrates the steps required to PA Invoice Detail in Fusion Application Script to PA Invoice Detail Query in Fusion Application SELECT…
AR Aging 4 Bucket with project details in fusion
Introduction This Post illustrates the steps required to AR Aging 4 Bucket with project details in fusion application Script to AR Aging 4 Bucket with project d…
HCKT Hard Limit Reached Events in Fusion
Introduction This Post illustrates the steps required to HCKT Hard Limit Reached Events in Fusion Script to HCKT Hard Limit Reached Events in Fusion Purpose Pur…
Project Details – Auditor Query – FUSION
Introduction This Post illustrates the steps required to get Project Details in fusion Application. Script to Project Details in FUSION SELECT DISTINCT PPA.proj…
Query for Project Unbilled Balances – FUSION
Introduction This Post illustrates the steps required to get Project Unbilled Balances in Fusion Application. .Script to Project Unbilled Balances in Fusion App…
Query to AP Supplier Invoices in FUSION
Introduction This Post illustrates the steps required to get the AP Supplier Invoices in – FUSION Application Script to AP Supplier Invoices query – FUSION SELE…
AP – Employee invoices query – FUSION
Introduction This Post illustrates the steps required to get the AP – Employee invoices query FUSION Application Script to AP – Employee invoices query – FUSION…
Fusion HCM – Calling a Fast Formula from another Formula
Below is a Sample Formula showing How to Call a Fast Formula from another Formula : DEFAULT FOR ASG_HR_ASG_ID is 0 DEFAULT FOR PAY_EARN_PERIOD_END is ‘4712/12/3…
Fusion HCM – Getting HR Data in Fast Formula
Introduction This Post illustrates the steps required to get the hr data in fast formula-Fusion HCM Script to get the hr data in fast formula-Fusion HCM To get…
Fusion HCM – Query for Absence Accrual Balance
Introduction This Post illustrates the steps required to Absence Accrual Balance-Fusion Application Script to Absence Accrual Balance-Fusion HCM SELECT peo.pers…
Fusion HCM – Query for OTL Time Entries Details
Introduction This Post illustrates the steps required to OTL Time Entries Details in Fusion Application Script to OTL Time Entries Details – Fusion HCM SELECT p…
Fusion HCM – Query for Personal Payment Method Details
Introduction: This Post illustrates the steps required to get Personal Payment Method Details in Fusion HCM Script to Personal Payment Method Details in Fusion…
Query to Calling a Value Set in Fast Formula-fusion HCM
Below is a Sample Formula shows How to Call a Value set in Fast Formula : Inputs are hr_id (number), eff_st_date(text), eff_end_date(text), mode (text) l…
Function To Get Bill Rate Of Employee in Specific Project in Oracle Fusion
FUNCTION get_bill_rate ( p_project_id IN NUMBER, p_person_id IN NUMBE…
Query to Find AP Reimbursable Expenses in Oracle Fusion
WITH GET_PERIOD_AVG_RATE AS ( SELECT gper.avg_rate, &…
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 Projects Not Accruing Revenue in Oracle Fusion
–**** Project Not Accruing Revenue Due to Expenditure Exception ****– SELECT PE.accounting_period AS GL_PERIOD ,OKH.contract_numbe…
Query to find AR Open Balance Of a Project in Oracle Fusion
WITH FUNCTION get_outstanding_amount ( p_payment_schedule_id IN NUMBER,  …
HCKT Hard Limit Reached Events in Fusion
Purpose of the report is to display project hours and hard-limit amount with interactive mode. with XXANSR_PA_EVENTS_cte as (SELECT evt.ROWID as “ROW_ID”,  …
REVENUE TRANSFER REPORT (FUSION)
Purpose of this report is to derive all projects expenditure and event details with cost information. SELECT revenue_type, TO_CHAR (customer_id) cus…
Building Dynamic Regions in Oracle APEX using APEX API
Modifying region queries/source dynamically can be done easily, whereas building regions dynamically can be done only using APEX API. Using the below code, a st…
Integrating With Fusion Application Using Services (APEX)
Fusion Applications provides web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and c…