How to bounce apache or oc4j in oracle r12

The following steps need to be followed in the same sequence to bounce Apache or OC4J in R12.

1) login to the apps tier with ‘putty’ or any equivalent software.
2) cd $ADMIN_SCRIPTS_HOME
3) adapcctl.sh stop
4) adoacorectl.sh stop
5) adapcctl.sh start
6) adoacorectl.sh start

sql query to check AP invoice and payments

  SELECT aca.check_number "Document Number",
         asa.segment1 "Supplier Number",
         asa.vendor_name "Supplier Name",
         aca.STATUS_LOOKUP_CODE "Payment Reconcilation Status",
         aca.CLEARED_AMOUNT "Payment Amount",
         aca.CURRENCY_CODE "Currency",
         aca.CLEARED_DATE "Payment Date",
         aia.invoice_num,
         aia.invoice_amount,
         AP_INVOICES_PKG.GET_APPROVAL_STATUS (aia.INVOICE_ID,
                                              aia.INVOICE_AMOUNT,
                                              aia.PAYMENT_STATUS_FLAG,
                                              aia.INVOICE_TYPE_LOOKUP_CODE)
            "Invoice Acct Status"
    FROM ap_checks_all aca,
         ap_invoice_payments_all aipa,
         ap_invoices_all aia,
         ap_suppliers asa
   WHERE     aca.check_id = aipa.check_id
         AND aipa.invoice_id = aia.invoice_id
         AND aia.vendor_id = asa.vendor_id
         AND aipa.ACCRUAL_POSTED_FLAG = 'N'
         AND POSTED_FLAG = 'N'
         AND TRUNC (aca.CLEARED_DATE) BETWEEN '01-JUN-2013' AND '30-JUN-2013'
ORDER BY check_number;

sql to check Instance clone date

SELECT

resetlogs_time FROM v$database;

Profiles for OAF Personalisation

FND: Personalization Region Link Enabled -->Yes
FND: Personalization Seeding Mode -->Yes
Personalize Self-Service Defn -->Yes

 

Order Management APIs Fail with ORA-20001 in MO_GLOBAL.INIT [ID 973664.1]

Order Management APIs Fail with ORA-20001 in MO_GLOBAL.INIT [ID 973664.1]

How to retrieve data from cs_sr_incidents_v_sec views

unable To Retreive Data From cs_sr_incidents_v_sec And cs_incidents_b_sec [ID 1368799.1]

It is mandatory to set the database session language to American ,if your session language is not American.

select * from NLS_SESSION_PARAMETERS;

The Priority of NLS Parameters Explained (Where To Define NLS Parameters) [ID 241047.1]

NLS_LANG Explained (How does Client-Server Character Conversion Work?) [ID 158577.1]

The correct NLS_LANG in a Microsoft Windows Environment [ID 179133.1]

How to check fmb file version from unix

strings -a XTRINWHL.fmb | grep Header

adident Header XTRINWHL.fmb

API to reset apps login password

DECLARE
   l_Flag   BOOLEAN;
BEGIN
   l_Flag :=
      fnd_user_pkg. ChangePassword (username => 'USERNAME', newpassword => 'PASSWORD');
   IF l_Flag
   THEN
      DBMS_OUTPUT.put_line ('The password has been resetted');
   ELSE
      DBMS_OUTPUT.put_line ('The password has not been resetted');
   END IF;
END;