My Oracle Support Banner

Contracts With Attachments Report (Doc ID 2589714.1)

Last updated on SEPTEMBER 17, 2019

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.13.19.07.0 and later
Information in this document applies to any platform.

Symptoms

Writing a  BI Publisher data model to get the list of the contracts and their attachments by using the below 3 tables. Results in Error

FND_DOCUMENTS_TL
FND_ATTACHED_DOCUMENTS
OKC_K_HEADERS_VL

But we are getting below error when running the below sql in the environment.

SELECT
  fad.*
FROM
  fnd_attached_documents fad,
  okc_k_headers_VL ohb
WHERE
1=1
and ohb.id = fad.pk1_value
order by fad.creation_date desc

Error: Java.SQL.SQLSyntaxErrorException ORA-1722 Invalid Number

Changes

 

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
Changes
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.