Yearly Archives: 2021

Oracle APEX Chart Conditional Bar Colors

Overview This document explains how to to change the chart bar colors based on the conditions in Oracle APEX. I will be very useful when we want some one Technologies…

Read More

AR Interface Issue Transaction Currency Payment Method Setup

Sales Order Transaction Currency not Associated with Payment Method Currency – Solution Setup Step 1:Navigation : AR IE Manager -> Control -> Auto Invoice -> Interface Line STEP 2 :Navigation…

Read More

View Accounting Function is Not Available in Receiving Transactions Summary

Module – Oracle Purchasing While attempting to view the accounting information from View Receiving Transactions of Inventory Receiving, the following error occurs: Error: Function not available to this responsibility. Change…

Read More

Accrue On Receipt Flag in PO Shipments can not be Unchecked

Module: Oracle Purchasing Enter Purchase Orders Error : Can not uncheck the ‘Accrue On Receipt’ flag in PO shipments Error : Cannot update ‘Accrue On Receipt’ flag NOTE: Steps to…

Read More

Oracle WMS – Cross Dock Setup

X-Dock in Oracle WMS Crossdocking is the use of inbound receipts to satisfy outbound demands. You can use crossdocking to match outbound shipments to scheduled receipts in advance. This enables…

Read More

BMCOIN:Component And Assembly Item Attributes Invalid

Problem Description ——————- You are importing Bills of Material (BMCOIN) and receive the following error for some of your bills/items: Component and assembly item attributes invalid What are the conditions…

Read More

Oracle Analytical Functions

The easiest way to understand analytic functions is to start by looking at aggregate functions. An aggregate function aggregates data from several rows into a single result row. The aggregate…

Read More

After upgrade from 11.5.10.2 to 12.2.5, Cannot compile invalids

Scenario: After upgrade from 11.5.10.2 to 12.2.5, Cannot compile invalids Error: ORA-00980: synonym translation is no longer valid Cause : The files in patch 18359637:R12.PO.D were not run or not…

Read More

Facing performance issue after upgrading database from 12.1.0.2 to 19C with Ebusiness suite 12.2

Scenario : Facing performance issue after upgrading database from 12.1.0.2 to 19C with Ebusiness suite 12.2 Analysis : While analyzing we came across the parameter “_lm_res_hash_bucket” which inturn mentioned for…

Read More

OEM 13c is not reflecting the correct data from all DB nodes after DB 19c upgrade

Scenario: After upgrading the database to 19c, The existing OEM 13c is not reflecting the correct data for all nodes. Solution: Check the OMS agents are updated to the latest,…

Read More