Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
substr & instr clause in TAD — Cloud Customer Connect
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

substr & instr clause in TAD

Received Response
edited Dec 26, 2020 8:19AM in Purchasing 1 comment


substr & instr clause in TAD



We have requirement to populate the PO charge account based on category. However we should not validate the full category so we have to check the partial name of the category as per user requirement. so i have to tried use substr clause in CONDITION field for Account rule. but i am encountering error due to syntax. Can we use substr & instr clause in CONDITION field ?


Howdy, Stranger!

Log In

To view full details, sign in.


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