Create Chart for Account Segment Values

This Bot is specifically creates Values for Natural Account Segment Values. • Upon completion of the Bot an email notification should be sent to the requester with an attachment of all Segment Values successfully created and any exceptions.

Top Benefits

  • Maintains Chart of Account Segment Values sourced from a Comma Separated Values (CSV) Text file
  • BOT can update COA Segment values as and when required and eliminate manual efforts.
  • It would also ensure accuracy for creation of corresponding COA values.
  • Automation is not dependent of human resource on daily basis.

'- The Bot will fetch the requests sent via email attachment in excel file. It will process each Segment Value requested within excel file. - The Bot will capture any exceptions encountered while Value set validations are performed and will send those exceptions back to the requestor. - The Bot will send confirmation email to the requestor for all successfully created segment values.

The user will send the email with an excel file attachment for multiple COA Segment Values creation. The Bot will use standard Oracle Form – Key Flexfield Value Set Values maintenance ensuring all validations are performed as if the values are entered manually. This BoT can be used for creation of Values for any Segment Value Set, which can be parameter.

Get Bot


Bot Security Program
Level 1
Business Process
Automation Type
Last Updated
July 24, 2020
First Published
September 28, 2018

See the Bot in Action


Setup Process


Download the Bot and follow the instructions to install it in your AAE Control Room.


Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)


That's it - now the Bot is ready to get going!

Requirements and Inputs

  • AAE v10.7 sp2
  • Inputs: Excel files received via email