My Oracle Support Banner

FAW:SME Main Branch Step Is Failing With Error “Apply patch failed due to :: Patch Execution failed "Couldn't create the RPD. Error details: [nQSError: 92014] The repository (or XML) has duplicate UIDs." (Doc ID 2980376.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Fusion Analytics Warehouse - Version 23.R1.x and later
Information in this document applies to any platform.

Symptoms

In SME when re-applying a step under Main branch, you may encounter the below error:

Steps to Reproduce:

  1. Create a View (Example:W_PR_PO_LIFE_CICLE_AGING_VW) in OAX_USER using DW_REQUISITION_CF & DW_PURCHASE_ORDER_CF.
  2. Due to performance concern created table DW_PR_PO_LIFE_CYCLE_AGING_F in schema OAX_CUSTOM_DATA and granted access to OAX$OAC and OAX_USER.
  3. Replace the view W_PR_PO_LIFE_CICLE_AGING_VW with the newly created table DW_PR_PO_LIFE_CYCLE_AGING_F.
  4. Log into Semantic Model Extension--> Re apply the Main branch step. It will fail with above stated error 

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!


In this Document
Symptoms
Cause
Solution
References


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