FACILITY maintenance record is with un-authorized status in STTB_RECORD_LOG table, even if same record is showing as authorized in FCUBS frontend application (GEDFACLT screen). (Doc ID 2567823.1)

Last updated on APRIL 29, 2021

Applies to:

Symptoms

On : 12.0.3 version, Production Support-SET

ACTUAL BEHAVIOR
---------------
Line maintenance is pending in STTB_RECORD_LOG whereas there is no unauthorized entries in GEDFACLT

Line maintenance is pending in STTB_RECORD_LOG whereas there is no unauthorized entries in GEDFACLT.

1. Create a facility and Save it and do not authorize it now.
2. Unlock the facility and change the line serial number
3. Authorize the facility.
4- Verify the facility in sttb_record_log.

EXPECTED BEHAVIOR
-----------------------
If the primary record is authorized in GEDFACLT screen, then all the relevant audit log details must be update correctly in STTB_RECORD_LOG table.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a facility and Save it and do not authorize it now.
2. Unlock the facility and change the line serial number
3. Authorize the facility.
4- Verify the facility in sttb_record_log.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proceed with EOD and also not able to validate correct audit logs for the maintenance record.

Changes

Cause

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