How to find historical sql_id executed by users
AWR captures only the top N sql for each category (Elapsed time, CPU time, I/O time, Gets, Reads, etc.).

If you set this limit to MAXIMUM with DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS, even that does not guarantee capturing all SQLs as they may age out from the shared pool between taking AWR snapshots.

If you want all SQLs to be logged, you can use SQL tracing (Monitoring and Tracing SQL) or Auditing (Monitoring Database Activity with Auditing) with the settings that fulfill your requirements.