Where is the adpatch log file located?

Patch log files:
$APPL_TOP/admin/<SID>/log/adpatch.lgi
i.e. /appltest/testappl/admin/TEST/log/adpatch.lgi

Errors and warnings are
$APPL_TOP/admin/<SID>/log/adpatch.log
i.e. /appltest/testappl/admin/TEST/log/adpatch.log

Where is the concurrent manager log located?

Concurrent manger is started by script adcmctl.sh. This is located at
$COMMON_TOP/ admin/scripts/<CONTEXT_NAME >
something like at /appltest/testcomn/admin/scripts/TEST_myhost01. View this file and will get a line near at the beginning like LOGFILE="/appltest/testcomn/admin/log/TEST_myhost01/adcmctl.txt"
This is the concurrent manger log.

How to find wf_item_type and wf_item_key for a releases?

SELECT hr.NAME, poh.segment1, por.release_num, por.wf_item_type,
  por.wf_item_key
  FROM po_headers_all poh, po_releases_all por, hr_all_organization_units hr
 WHERE poh.org_id = hr.organization_id
  AND por.org_id = poh.org_id
  AND poh.po_header_id = por.po_header_id
  AND poh.segment1 = '796'
  AND por.release_num = '49'

How to get invoice withheld and applied prepayment amount in SQL?

Use the following API column in your SQL respectively:
AP_INVOICES_PKG.GET_PREPAY_AMOUNT_APPLIED(AI.INVOICE_ID) PREPAY_AMOUNT_APPLIED
and
AP_INVOICES_PKG.GET_AMOUNT_WITHHELD( AI.INVOICE_ID) AMOUNT_WITHHELD

How to download affected Asset data into excel from Asset Mass Reclassification?

Get the ‘Mass Transaction Number’ form ‘Mass Reclassification’ screen. (After ‘Previewing’ the Mass Transaction).
Navigation: Fixed Asset user->Navigator->Mass Transaction->Reclassifications

SQL> SELECT *
FROM  FA_MASS_RECLASS_ITF FAM
WHERE FAM.MASS_RECLASS_ID=xxx;

* xxx is the Mass Transaction Number

How to restrict ADI user to download budget but not to upload?

Change the profile option ‘GLDI: Budget Wizard Privileges’ to entry for that responsibility.

How to check if you have the Security by Book functionality enabled?

To check if the FA Security by Book functionality is enabled for a responsibility:
Login to the responsibility. Query the profile option “FA: Security Profile” (Other > Profile). If the “Default Value” is defined, then you have the Security by Book enabled for the responsibility. If the “Default Value is not defined (i.e. null), then you do not have the Security by Book enabled for the responsibility.