The below query extracts the error details along with interface attributes of Customer Sites import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,site.* FROM hz_imp_errors err…
Read MoreThe below query extracts the error details along with interface attributes of Customer Contact Points import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,cpt.* FROM hz_imp_errors…
Read MoreThe below query extracts the error details along with interface attributes of Customer Account import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,acc.* FROM hz_imp_errors err…
Read MoreThe data in a GTT is written to the temporary tablespace, which is not directly protected by redo, so using a GTT improves performance by reducing redo generation. Unfortunately, prior…
Read MoreWhat is it? In previous releases the database stored compilation and execution statistics in a shared sql area which is non persistent. Starting in 12c the database can use a…
Read MoreDuring tuning a query, I found one table has stale statistics. While running gather stats for that table, got below error. Let me demonstrate with a demo table: SQL> execute…
Read MoreThe simplest method is to add a hint to the query to overcome ORA-00001 Added in 11.2, the ignore_row_on_dupkey_index hint silently ignores duplicate values: insert /*+ ignore_row_on_dupkey_index ( acct (…
Read MoreA virtual column applies a function to a column in the table. The database only computes this at runtime. The value is not stored in the table. So instead of…
Read MoreThe smallest unit of data storage in Oracle Database is the block. This defaults to 8k (8,192 bytes). Each index entry must fit within one block. So the maximum size…
Read MoreImpact: Unknown underscore parameters without proper advice from metalink, would impact the database. Solution: We need to ensure that we have proper advises from Oracle Support on those underscore parameters…
Read More