If using unified audit trail there's a solution by adding custom attributes to the column 'application_contexts'.

Execute AUDIT CONTEXT NAMESPACE USERENV ATTRIBUTES SID; to add the SID from V$Session to the unified audit trail.