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

Is creating Contract Variables using PL/SQL code supported in Oracle Fusion support

in Enterprise Contracts 1 comment

**This post was created as part of a How to Service Request (SR)


Release:

[22A]


Summary of the question:

In EBS, uses can create a contract variable with source as SQL. The SQL query can be used to feed the input parameter and then the query will run and provide the output as a variable


Example In EBS , these steps can be followed

1) Create Contract Variable with source as PL/SQL

2) RFQ created

3) The supplier response for the questions are stored in variable name

4) BPA is created from RFQ using the contract template which uses the above variable

5) In the PL/SQL code, we pass the input parameter as RFQ number for this BPA and also the awarded supplier. The PL/ SQL code looks at the variable and look for the same requirement as the variable name and finds the answer for this question and for that supplier and return the answer to this variable

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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