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;