ORACLE E-BUSINESS SUITE FINANCIALS HANDBOOK NOTES

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