set serveroutput on set lines 300 DECLARE V_CURRENT_TABLESPACE VARCHAR2(50); V_DEST_TABLESPACE VARCHAR2(50); V_SQL VARCHAR2(1000); V_OVERFLOW NUMBER := 0; BEGIN V_CURRENT_TABLESPACE := ‘¤t_tablespace’; V_DEST_TABLESPACE := ‘&destination_tablespace’; FOR LIST_OWNER IN (SELECT DISTINCT OWNER…
Read MoreSELECT fpot.user_profile_option_name, profile_option_value, fpov.creation_date, fpov.last_update_date, fpov.creation_date – fpov.last_update_date “Change Date”, (SELECT UNIQUE user_name FROM apps.fnd_user WHERE user_id = fpov.created_by) “Created By”, (SELECT user_name FROM apps.fnd_user WHERE user_id = fpov.last_updated_by) “Last…
Read MoreISSUE: A concurrent request fails to complete successfully due to a timeout caused by the Concurrent Processing integration with BI Publisher (formerly XML Publisher) functionality Error Message A (CONC-PP NO…
Read MoreIssue: Various programs (like the AP Trial Balance and Invoice Register Report) complete with a warning status. The log file shows the following error message: Beginning post-processing of request xxxxxxx…
Read MoreSteps Oracle Inventory and Oracle Cost Management provides the required features to effect the necessary period-end procedures to: § Reconcile the inventory and work in process costs and values. §…
Read MoreSQL Query to find details from PO till Cheque payment The following five components of P2P Cycle Query are 1. Requisition Detail 2. Purchase Order Details 3. Receiving Details 4. …
Read MoreFrom the failed notification, determine the notification ID. Step 1: Use the notification ID to determine the context under which the API was called select substr(notification_id, 1, 12) nid, substr(status,…
Read More1)Login as soauser and append below environment variables in .profile export SOA_HOME=/DEVSOA/product/SOASuite export JAVA_HOME=$SOA_HOME/jdk export PATH=$SOA_HOME/opmn/bin:$SOA_HOME/OPatch:$JAVA_HOME/bin:$PATH export KEYSTORE=$JAVA_HOME/jre/lib/security/cacerts 2) create a directory “certs” in /local/home/ Place all third party trusted…
Read More