web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate and fle...
Power Automate
Unanswered

Power Automate and flexfiled on Oracle ERP

(0) ShareShare
ReportReport
Posted on by 8

Hello, I'm new to using Power Automate Desktop.

All I wanna do with Power Automate is simply copy a value on Excel file and paste it in designated space of an Flexfield on Oracle ERP system repetitively.

 

But here's some questions:

I used Recorder function first, but when I ran the recorded stages it doesn't work exactly the way I did, it can't past the value on the certain space of Flexfield. How can I designate certain space on Flexfield when I make stages on Power Automate?

 

second, do I need to install Oracle connectors even if I don't need to get data from Oracle data base?

  • Srini007 Profile Picture
    3,490 Super User 2026 Season 1 on at

    Hi @Ellie_Ryu 

     

    Are you able to generate the selectors of the fields you want to type?

    Also, can you share some screenshots where actually it typed and the related selector?

     

    Regards,

    Srini

  • Ellie_Ryu Profile Picture
    8 on at

    Hi @Srini007 , thank you for leaving a comment. 

    Yes, I found selectors of UI element and I revised it with a variable.

     

    I got this image from Oracle Help Center, it's similar form I use. 

    Ellie_Ryu_1-1697688415639.png

    I want to repeat paste value I copy from Excel on space1 and then copy next value on Excel and then paste it on space2 , over and over again till the last value. 

    I set variables to get increased 1 by 1 so that it can copy the next value, but here's problem:

    the program click the wrong button additionally on Oracle even though I set it to click the next space by using UI Automation fuction.(Also I revised the selector to click the next space with increased variable and it's working).

    Is it because I don't use Oracle Database connector? I thought I didn't have to install it cause all I need to do is just copy and paste.

     

     

     

     

     

  • Srini007 Profile Picture
    3,490 Super User 2026 Season 1 on at

    Hi @Ellie_Ryu 

     

    There is no need of installing the Database connector, as you are automating Front End, If you are dealing with Datatabase then you need the Datatabase Connectors

    So, coming to the wrong button click, can you check selector of that button and check if any of the selector is getting matched? Also, can you share which element it is clicking, Is this random or always?

     

     

    If you find this reply helpful, please consider giving it a LIKE AND

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

     

    Thanks,

    Srini

  • Ellie_Ryu Profile Picture
    8 on at

    Hello Srini,  thank you for your reply and I'm sorry but I need your help again. I have one more question, I'm trying to set Power Automation to click and paste copied values as I mentioned in previous question. So I tried to revise Selector setting and I found Ordinal part so I checked Ordinal and set variable to be put as the value (please refer to the picture below, and the operator means 'equal' in Korean), but the program says this is ' invalid pseudo selector value'.

    Do I need to change the value of variable into hard coded one, like just a number? 

     

    Ellie_Ryu_0-1699941311360.png

     

  • RAYEDJAWAD Profile Picture
    2 on at

    Hey Ellie, just came across your post, I am looking for a similar solution, mine is a rostering system , Oracle ERP PROD, the MS automate desktop screen record is ineffective, did you manage to find anything ?




  • Ellie_Ryu Profile Picture
    8 on at

    Hello 🙂 Unfortunately I failed to find a solution with using Power Automate. I'll just try using Macro of Excel next year, as mine is real just repetitive work. I think power automation and Oracle ERP isn't compatible well.

    Happy new year and hope you can find your solution soon!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 263

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard