Introduction/ Issue: Developing a BIP report in Fusion to identify component demand shortages for assembly items and improve supply planning decisions. Why we need to do / Cause of the…
Read MoreIntroduction: In Oracle Order Management, We have two Shipping methods post Sales Order creation, Full Shipment and Partial Shipment. They are carried out by specifying the quantity while creating Shipment in OMS (Fusion). In this blog we will…
Read MoreIntroduction: Redwood Pages and standard ADF pages represent two different approaches to building user interfaces within Oracle applications. While standard ADF pages have traditionally been used to develop enterprise-grade web applications…
Read MoreIntroduction: – Interactive Grids are widely used to display and manage large volumes of data efficiently. However, one common challenge users face is handling column widths—especially when data length varies…
Read MoreIntroduction: Oracle APEX Interactive Grids are one of the most powerful components for displaying and managing large volumes of data within an application. They allow users to view, edit, filter,…
Read MoreMerge Replication in SQL-Server Introduction: Merge Replication in SQL Server is used in distributed environments where multiple databases need to work independently and later synchronize data.This guide explains why Merge…
Read MoreIntroduction In an Oracle E-Business Suite (EBS) R12.2 environment, the DMZ web tier acts as the first line of defense between external users and internal application services. Because this tier…
Read MoreIntroduction One of the common issues Oracle E-Business Suite (EBS) administrators face is the login page hanging or failing to load. In many cases, the root cause is excessive resource…
Read MoreTried to import a partitioned table from Oracle enterprise edition to Standard edition 2 database. 1st Method : impdp \”/ as sysdba\” directory=DUMP dumpfile=2tab_tst_19_12_25.dmp logfile=2tab_tst_19_12_25_2.log TABLES=GLOBUS_APP.T502_ITEM_ORDER REMAP_TABLE=GLOBUS_APP.T502_ITEM_ORDER:T502_ITEM_ORDER_TEST2 REMAP_TABLESPACE=GMI_APP_DATA:GLOBUS_PROD_PERM Imported a entire table, but faced the below error. Since, we cannot import a partitioned table to a SE2 database. 2nd Method : impdp \”/ as sysdba\” directory=DUMP dumpfile=2tab_tst_19_12_25.dmp logfile=2tab_tst_19_12_25.log TABLES=GLOBUS_APP.T502_ITEM_ORDER REMAP_TABLE=GLOBUS_APP.T502_ITEM_ORDER:T502_ITEM_ORDER_TEST REMAP_TABLESPACE=GMI_APP_DATA:GLOBUS_PROD_PERM CONTENT=DATA_ONLY Created the table with the metadata first. Then imported with the data_only option. This time it works.
Read MoreIn SQL Server environments, confusion between keys and indexes remains a common and often overlooked issue. Although closely related, keys and indexes serve different purposes, and treating them as interchangeable…
Read More