What's new in Customer Journeys?

Connect and learn more! ×
Department attribute is missing from Contracts Header Details — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Department attribute is missing from Contracts Header Details

Received Response
25
Views
4
Comments
edited Nov 6, 2023 10:37PM in Enterprise Contracts 4 comments

Summary:

We recently had a P2T Refresh and are getting error on our dashboard reports as below.

State: HY000. Code: 27045. [nQSError: 27045] Nonexistent column: "Contract Header Details"."ContractHeaderFlexfield_DESC_DEPARTMENT_". (HY000)

SQL Issued: SELECT "Contract Header Details"."ContractHeaderFlexfield_DESC_DEPARTMENT_" FROM "Enterprise Contracts - Contracts Real Time"

We are not able to find Department attribute under Contracts Header Details dimension under Enterprise Contracts - Contracts Real Time subject area. We added this attribute before our P2T refresh on all our reports but we are not able to find it after Refresh. And the reports are throwing error as attached.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!