My Oracle Support Banner

Get The Contract Number In BPM Using Expression Builder (Doc ID 3011443.1)

Last updated on MARCH 28, 2024

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

Trying to get the Contract Number in BPM using Expression Builder - orcl:query-database-with-bindvar. But it is not returning any value.

Complete query:
orcl:query-database-with-bindvar('select distinct header.CONTRACT_NUMBER from fusion.OKC_K_HEADERS_ALL_B header where header.id=:cid',true(),true(),'jdbc/ApplicationDBDS',concat('cid=',/task:task/task:payload/ns0:findContractHeaderResponse/ns0:result/ns1:ContractId))

EXPECTED BEHAVIOR

Users expect the ability to pull contract number in BPM using expression builder.

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.