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 laterInformation 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 |