Thisismarkantony.com

Invoice AP_BATCHES_ALL SELECT * FROM AP_BATCHES_ALL WHERE batch_id IN ( SELECT batch_id FROM AP_INVOICES_ALL WHERE invoice_id = :P_INVOICE_ID ); AP_INVOICES_ALL SELECT DISTINCT ai.*, fnd_flex_ext.get_segs('SQLGL','GL#', '101' , ai.accts_pay_code_combination_id ) "Accts Pay Account" FROM AP_INVOICES_ALL ai WHERE invoice_id = :P_INVOICE_ID ORDER BY ai.invoice_id ASC; AP_INVOICE_LINES_ALL SELECT * FROM AP_INVOICE_LINES_ALL WHERE invoice_id = :P_INVOICE_ID; AP_INVOICE_DISTRIBUTIONS_ALL SELECT aid.*, fnd_flex_ext.get_segs('SQLGL','GL#', '101' , aid.accts_pay_code_combination_id) "Accts Pay Account", fnd_flex_ext.get_segs('SQLGL','GL#', '101' , aid.dist_code_combination_id) "Dist Account" FROM AP_INVOICE_DISTRIBUTIONS_ALL aid WHERE aid.invoice_id = :P_INVOICE_ID ORDER BY aid.invoice_id, aid...

SELECT fcr1.request_id , fcp1.user_concurrent_program_name , DECODE(fcr1.phase_code,'C','Completed',fcr1.phase_code) phase_code, DECODE(fcr1.status_code,'D', 'Cancelled','E', 'Error' , 'G', 'Warning', 'H', 'On Hold' , 'T', 'Terminating', 'M', 'No Manager' , 'X', 'Terminated', 'C', 'Normal', fcr1.status_code) status_code, fcr1.request_date , fcr1.requested_start_date , fcr1.actual_completion_date, fcr1.parent_request_id FROM apps.fnd_concurrent_requests fcr , apps.fnd_concurrent_programs_vl fcp , apps.fnd_concurrent_requests fcr1 , apps.fnd_concurrent_programs_vl fcp1 WHERE 1 = 1 AND fcp.concurrent_program_id = fcr.concurrent_program_id AND fcp1.concurrent_program_id = fcr1.concurrent_program_id AND fcr1.parent_request_id = fcr.request_id AND fcr.parent_request_id = 95625343 ORD...

.Click the 'Diagnostics' link in top right of screen 2. From the Diagnostic drop down select 'Set Trace Level' and click 'Go' 3.There will be Six Options In the LOV 4. Select The appropriate option 5. Note down the Trace ID Numbers returned and click 'Save' 6 . Perform The Search/Operation. 7. Select "Disable Trace " after Operation. 8. The trace files should be output to the directory returned by the following query

A PL/SQL procedure can check the status of a concurrent request by calling. FND_CONCURENT.GET_REQUEST_STATUS FND_CONCURRENT.WAIT_FOR_REQUEST  FND_CONCURRENT.GET_REQUEST_STATUS : -          This function returns the status of a concurrent request -          If the request is already computed, it also returns the completion message. -          This function returns both user friendly (translatable) phase and status values as well as developer phase and status vales that can drive program logic. Syntax  Function FND_CONCURRENT.GET_REQUEST_STATUS                    ( request_id in out number,                    application in varchar2 default null,                    program in varchar2 default null,             ...

SELECT DISTINCT   gjb.NAME batch,   default_period_name period,   wn.recipient_role approver,   DECODE (gjb.approval_status_code, 'A', 'Approved', 'I', 'In Process', 'J',   'Rejected', 'R', 'Required', 'V', 'Validation Failed', 'Z', 'N/A' ) status,   wn.begin_date approval_start_date,   wn.end_date approval_end_date,   wn.due_date approval_due_date FROM   wf_notifications wn,   wf_items wi,   gl_je_batches gjb WHERE   wn.CONTEXT LIKE 'GLBATCH%'   ||   (     SELECT       item_key     FROM       wf_items a     WHERE       a.user_key    = wi.user_key     AND a.item_type = 'GLBATCH'     AND ROWNUM      = 1   )   || '%' AND wi.item_type = wn.MESSAGE_TYPE AND wi.user_key  = gjb.NAME AND gjb.name LIKE 'BatchName%'