E1: CFR11: Problem with Capturing Audit Information on Table F0011 (Doc ID 1296103.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

21CFR Audit is not working correctly when auditing is turned on (enabled) for table F0011. The UserID  is not recorded correctly at times.  Instead the general E1 System User is used. The program ID is also not recorded correctly in the Audit (Shadow) table A0011. The following are the scenarios reported for F0011 table audit issues:

Scenario 1

Batches are created via Z-table processor (R09110Z) and approved via P0011 which is called from Fast path. The user locates their batch in P0011, highlights it and takes ROW Exit to access option Batch Approval. On the Opened batch approval screen, user ticks the Approved option and then clicks OK thus approving a batch.  The Audit information in A0011 is incorrect. The Program ID and UserID are not captured correctly. The UserID shows as the System User instead.

Steps to Reproduce:

1. Create a batch using Z-table processor (R09110Z).
2. Launch P0011 from fast path.
3. In P0011, highlight it and take ROW Exit to access option Batch Approval.
4. On the opened batch approval screen, tick Approved option and then click OK.

Scenario 2

A batch is created manually via P0911.  P0011 is launched via P0911 ROW exit.  This time, it shows the correct UserID.  However, the Program ID is still incorrect.  It should be P0011 - for Batch approval but it shows as P0911 - Journal Entry instead.

Steps to reproduce:

1. Create a batch via P0911.
2. From P0911, launch P0011 through ROW Exit.
3. In P0011, highlight it and take ROW Exit to access option Batch Approval.
4. On the opened batch approval screen, tick Approved option and then click OK.

Scenario 3

A batch is created manually via P0911 and P0011 is launched from Journaling menus, but it has the same issue as described in Scenario 1.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.