ssss

sss

Read More

responsibility that can run a specific report

SELECT r.responsibility_name,
g.request_group_name,
cp.user_concurrent_program_name
FROM fnd_responsibility_vl r,
fnd_request_groups g,
fnd_request_group_units rg,
fnd_concurrent_programs_vl cp
WHERE r.request_group_id = g.request_group_id
AND rg.request_group_id = g.request_group_id
AND rg.request_unit_id = cp.concurrent_program_id
AND rg.application_id = 'your application_id'
AND r.responsibility_name = 'your name responsibility'

you can also try note: 134036.1 - List Responsibilities That Can Run a Given Concurrent Program(WHOCANRUN.SQL)

Read More

Global Pricing and Licensing

Global Pricing and Licensing

http://www.oracle.com/us/corporate/pricing/index.htm

Read More

AR Transactions Posted to GL

if(!working)  
{  
FixIt();  
}  

SELECT l.subledger_doc_sequence_value "Doc Number",
l.effective_date "GL Date",
l.accounted_dr "Debit",
l.accounted_cr "Credit",
l.description "Description",
l.reference_4 "AR Number",
l.reference_9 "AR Type"
FROM gl_je_lines l, gl_je_headers h
WHERE je_source = 'Receivables'
AND h.je_header_id = l.je_header_id
AND h.set_of_books_id =
AND h.period_name = <>;

Read More

Data Query combining AP, GL

Use the reference columns i.e REFERENCE_1 to REFERENCE_10 of gl_je_lines table to join the AP tables with the GL tables like the below query.



SELECT gjl.reference_1,

gjl.reference_2,

gjl.reference_4,

gjl.reference_5,

gjl.reference_10,

aia.doc_sequence_value,

aia.invoice_type_lookup_code,

aia.description invoice_description,

ada.prepay_distribution_id,

gjl.description,

aca.doc_sequence_value payment_doc_seq_number,

ada.invoice_id,

aia.doc_sequence_value

FROM gl.gl_je_headers gjh,

gl.gl_je_lines gjl,

ap.ap_checks_all aca,

ap.ap_invoices_all aia,

ap.ap_invoice_distributions_all ada

WHERE gjl.je_header_id = gjh.je_header_id

AND aia.invoice_id(+) = gjl.reference_2

AND ada.invoice_id(+) = gjl.reference_2

AND ada.invoice_id(+) = gjl.reference_3

AND aca.check_id(+) = gjl.reference_3;

Read More

Purge Concurrent Request and/or Manager Data

Note 154850.1 - How to Run the Purge Concurrent Request and/or Manager Data Program and Which Tables Does it Purge?


Note: 1086013.1 - How to run the Purge Concurrent Request and/or Manager Data program and which tables does it purge?

Read More

How many times a responsibility has been used by a particular user

You just to enable audit as per metalink Note: '436316.1 - Auditing: How Do I Audit Responsibilities and Data?', and run the reports mentioned in the same document

Read More