The 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 MoreISSUE: ORA-31693: Table data object “APPLSYS”.”FND_LOBS” failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout ORA-01555: snapshot too old: rollback segment number with…
Read MoreIssue: Concurrent program stuck in OPP Steps to solve the Issue: Query to check concurrent program stuck in OPP SELECT a.request_id, substr(e.user_concurrent_program_name,1,80) Program,d.sid, d.serial# ,d.status,to_char(d.logon_time,’DD-MON-YY HH24:MI:SS’)logon, round(d.last_call_et/60) LCT FROM…
Read MoreIntroduction: EBS Application patch is applied to upgrade the version of application files Steps to apply Patch in EBS instance: Patch Upgrade in EBS instance: Step 1:…
Read MoreDescription: After Clone the Oracle Application R12.1.3 and login the application this error occurs. Solution: Check the Server ID in fnd_node table . Select server_id from fnd_node; Take a backup…
Read MoreDescription: Customers run the Oracle Report are Failing with APPS.FND_CP_OPP_IPC ORA-00600: internal error code. This issue made low level business impact Solution: Check the Concurrent Log file to detail…
Read MoreFRM-18108: Failed to load the following objects. Source Module:APPSTAND Source Object: STANDARD_PC_AND_VA Source Module:APPSTAND Source Object: STANDARD_TOOLBAR Source Module:APPSTAND Source Object: STANDARD_CALENDAR Compiling package specification APP_CUSTOM… No compilation errors. We…
Read MoreThis script fetch & transfer the specific concurrent request log file to remote location. $ vi Connout.sh cat /dev/null > /usr/tmp/ftp.log cat /dev/null > /usr/tmp/ftp1.log echo “Enter Concurrent program Request…
Read More