TAR:Technical Assistance Request
patches are united to make sure they fix the sataed problems in the stated modules.Some patches don't apply to all users.ORACLE cannot regression test to make sure each patch does not create problems in other modules.Oracle periodically assembles the important ones into mega-patches,family packs or maintenance,which it does subject to regression testing.
TRM:Technical Reference Manual(http://etrm.oracle.com/pls/etrm/etrm_search.search)
Identifying Unposted Journals
SELECT user_je_source_name,accounting_date,count(accounting_date), sum(accounted_dr),sum(accounted_cr)FROM gl_interfaceGROUP BY user_je_source_name,accounting_dateORDER BY accounting_date,user_je_source_name
Identifying Unpostable QuickCash
SELECT payment_amount,last_update_date,batch_idFROM AR_INTERIM_CASH_RECEIPT_LINESWHERE cash_receipt_id not in (select cash_receipt_id from ar_interim_cash_receipts)
Identifying Unposted Invoice Distributions
SELECT 'Unposted invoice distribution',ai.invoice_numFROM ap_invoice_distributions api, ap_invoices aiWHERE api.period_name=&period_nameAND api.accounting_date between &start_date AND &end_dateAND api.accrual_posted_flag='N'AND api.invoice_id=ai.invoice_idORDER BY ai.invoice_num
Researching Hanging Processes
SELECT OSUSER, SERIAL#, SQL_TEXT FROM V$SESSION, V$SQL WHERE V$SESSION.SQL_ADDRESS = V$SQL.ADDRESS AND V$SESSION.STATUS = 'ACTIVE'REF:Note:135300.1 on Metalink
