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_interface
GROUP BY user_je_source_name,accounting_date
ORDER BY accounting_date,user_je_source_name
Identifying Unpostable QuickCash
SELECT payment_amount,last_update_date,batch_id
FROM AR_INTERIM_CASH_RECEIPT_LINES
WHERE cash_receipt_id not in (select cash_receipt_id from ar_interim_cash_receipts)
Identifying Unposted Invoice Distributions
SELECT 'Unposted invoice distribution',ai.invoice_num
FROM ap_invoice_distributions api,
ap_invoices ai
WHERE api.period_name=&period_name
AND api.accounting_date between &start_date AND &end_date
AND api.accrual_posted_flag='N'
AND api.invoice_id=ai.invoice_id
ORDER 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