Contracts With Attachments Report (Doc ID 2589714.1)

Last updated on OCTOBER 16, 2023

Applies to:

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

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