My Oracle Support Banner

OFSC Integration with ADW: Account Locked (Doc ID 2937065.1)

Last updated on MAY 05, 2023

Applies to:

Oracle Fusion Cloud Field Service - Version 22.D.04 and later
Information in this document applies to any platform.

Symptoms

On : 22.D.04 version, Integration

Data not flowing from OFS to target ADW using DBAAS Integration in Field Service

ERROR
-----------------------
Account is locked


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create, update or complete an activity in OFS
2. Query the target database and check if the change was propagated to the database
3. Data is not presented on target database
4. Check if the issue is related to a locked account by querying the DBA_USERS view:

    select status from dba_users whete username =<username>
5. If the status shows LOCKED, proceed with the action plan

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, management team cannot run decision maker reports

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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