How to reset/refresh Descriptive Flexfield attributes in the Repository (RPD) (Doc ID 1928784.1)

Last updated on JANUARY 20, 2020

Applies to:

Goal

You are unable to report on DFF fields, there is a SQL error when running a report with a DFF field.

An example of the error would be like:

Error Details
Error Codes: :U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14020] None of the fact tables are compatible with the query request Fact - Person.Persons Attributes_GLG_REPLACEMENT_c. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - HR Action.Action Id, Dim - HR Action.Action Name, Fact - Person.Persons Attributes_GLG_REPLACEMENT_c (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Local Currency', ENABLE_DIMENSIONALITY=1,NO_FORCE_TO_DETAIL_BIN=1; SELECT 0 s_0, "Workforce Management - Person Real Time"."Person"."Persons Attributes_GLG_REPLACEMENT_c" s_1, "Workforce Management - Person Real Time"."Person"."Persons Attributes_GLG_REQ_NUMBER_c" s_2, "Workforce Management - Work Relationship Real Time"."Business Unit"."Business Unit Name" s_3, "Workforce Management - Work Relationship Real Time"."Department"."Department Name" s_4, "Workforce Management - Work Relationship Real Time"."Job"."Job Code" s_5, "Workforce Management - Work Relationship Real Time"."Job"."Job Name" s_6, "Workforce Management - Work Relationship Real Time"."Location"."Worker Location Name" s_7, "Workforce Management - Work Relationship Real Time"."Worker Legislation"."Territory Code" s_8

Solution

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