Module: SODProcure to PaySeverity: CRITICAL
Toxic Duty Combination: User Possesses Both PO Creation and PO Approval Privileges
Enterprise troubleshooting playbook from the OAG ADK 5.0 knowledge base. Designed for Oracle Apps DBAs, techno-functional consultants, and support teams.
Recognized Error Signatures & Log Keywords
sod po create approvepo creation vs po approvalsod conflict po creationpo create and approve authoritytoxic duty po approvalsegregation of duties po conflictSOX.P2P.01
Root Cause Analysis
User {userName} is assigned conflicting responsibilities allowing self-approval of purchase orders.
Diagnostic SQL Queries (Read-Only)
CHECK_USER_SOD_RESPONSIBILITIESDetect users assigned responsibilities granting both PO Entry and PO Approval
SELECT u.user_id, u.user_name, r.responsibility_name
FROM fnd_user u
JOIN fnd_user_resp_groups g ON u.user_id = g.user_id
JOIN fnd_responsibility_tl r ON g.responsibility_id = r.responsibility_id
WHERE UPPER(u.user_name) = UPPER(:userName)Remediation Mode: MANUAL_UI
Verification Query
SELECT count(*) FROM fnd_user_resp_groups WHERE user_id = :userIdExecute This Fix Safely with OAG AI Consultant
OAG AI Consultant runs directly on your Windows desktop behind your corporate firewall, connecting to your Oracle TNS tier with zero cloud data exposure.