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 MoreOracle 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 MoreBMCOIN: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 MoreOracle 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 MoreAfter 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 MoreFacing 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 MoreOEM 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 MoreORACLE EBS 12.1.3 JDBC CONNECTION LEAK ISSUE
Issue: This homepage feature got a new bug with 12.1.3. This bug only affects EBS 12.1.2 and 12.1.3 customers who have OAMainMenuRESTHandler.class version 120.0.12010000.18. $ strings -a $JAVA_TOP/oracle/apps/fnd/framework/webui/rest/OAMainMenuRESTHandler.class|grep Header [$Header:…
Read MoreMissing Archive log error in Golden gate integrated capture.
Scenario: There was a missing archive log error and we need to change the archive log location for integrated capture process in Goldengate. Error : ERROR OGG-00868 Error code 1291,…
Read MoreDB Node Crashes after upgrading to 19c
Scenario: DB node Crashes after upgrading from 12.0 to 19c. Error: 2021-02-04T12:00:15.450521+00:00 Errors in file /u01/database/19.0.0/diag/rdbms/doyen/doyenB/trace/doyenB_lgwr_56472.trc: ORA-00600: internal error code, arguments: [3732], [33], [2], [], [], [], [], [], [],…
Read More