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.
Free
- Bot Security Program
-
Level 1
- Applications
-
- Business Process
- Finance & Accounting
- Category
- Productivity
- Downloads
- 120
- Vendor
- Automation Type
- Bot
- Last Updated
- July 24, 2020
- First Published
- September 28, 2018
- Platform
- 11.x
See the Bot in Action
Setup Process
Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Configure
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
Run
That's it - now the Bot is ready to get going!
Requirements and Inputs
- AAE v10.7 sp2
- Inputs: Excel files received via email