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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Use orcl: query-database sql count value on Flexfields

edited Jan 1, 2025 8:59PM in Purchasing 2 comments

Summary:

We need a rule to use a Sql statement to Auto reject PO's when the value in the flexfield is different in the rows.

Content (please ensure you mask any confidential information):

HI Purchasig Team,

We need a rule to use an Sql statement to Auto reject PO's when the value in the flexfield is different in the rows.

I have a flexfield in the line of the PO, Attribute 10, this flexfiled will have a number, in all the lines of the PO, I can't buy when the number is different, so I need a rule to reject when the Attibutte10 has different values inside the flexfield. The PO should not be rejected when the flexfield numbers are the same.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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