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. Cause of…
Read MoreConfiguration 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 legal requirement, Business requested…
Read MoreHow 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 creating/customizing/debugging the customer statement…
Read MoreThe 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 some of the project budget…
Read MoreKPI 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” process with from and to project number as…
Read MoreRestricting 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-approval of expenses by selecting the “Prohibit Self-Approval…
Read MoreUpdating 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 data directly from the service. You can download…
Read MoreEmployee 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 the below steps to…
Read MoreA 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. SQL Query:…
Read MoreSTEPS 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. Revaluation adjustments represent the difference in the value of…
Read More