Oracle Projects: Resources – SQL Auto-Accounting Validation Scripts

Having setup a number of operating units extremely quickly, and finding the standard Oracle Reports layout difficult to make easy comparisons, the enclosed SQL statement will help you to extract the configuration for all OU and accounting rules.

This script was tested and confirmed working in R12.2.4.

SELECT ho.name "OU",
pf.function_name,
pf.description,
pft.function_transaction_name,
pft.enabled_flag,
psr.segment_num,
pr.rule_name
FROM PA_FUNCTION_TRANSACTIONS_ALL pft,
hr_all_organization_units ho,
PA_SEGMENT_RULE_PAIRINGS_ALL psr,
PA_RULES pr,
PA_FUNCTIONS pf
WHERE pft.org_id = ho.organization_id
AND pft.org_id = psr.org_id
AND psr.function_code = pft.function_code
AND psr.function_transaction_code = pft.function_transaction_code
AND pr.rule_id = psr.rule_id
AND pf.function_code = pft.function_code
ORDER BY
pf.function_name,
function_transaction_Name,
segment_num;

Leave a Reply