Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to commit the changes using Form Personalization

User_E97G7Apr 27 2021

Hi Team,
We are using R12.2.3
In our system, few users are creating POs with Invoice Match Option as 'Receipt' for Match Approval Level 2-Way. And also creating POs with Invoice Match Option as 'PO' for Match Approval Level 3-Way.
Even we educated the users not to enter like that, few are still doing so.
So, we did Form Personalization so that system will automatically change to 'Receipt' for 3-Way and 'PO' for 2-Way once they go to Shipment Form(from Line Form or from Distributions form). As of now, we achieved this.
But, user need to 'Save' it to reflect these changes. But, is there any Form Personalization option to automatically save the changes.
I tried with COMMIT_FORM for DO_KEY. But, it didn't worked.
Below is the screenshot of Form Personalization we did.
image.pngimage.pngimage.pngimage.png
In the above screenshots, Action Seq 21 is not working.
Can anyone please help me on this.

Thanks in Advance,
Srivathsava

Comments

User_E97G7

Hi All,

Any help will be appreciable

Roy Kidron

Hi,
It's disabled in the screenshot.
Try checking the "Enabled" box in action 21.
Best regards,
Roy.

Rohit Bhagat

Have you got the solution.Please share if yes.

User_E97G7

Yes, ofcorse, I already did that. I disabled during my multiple ways of testing to achieve the requirement

User_E97G7

Hi,
No, we still didn't achieved this
But, luckily, we somewhat educated users to save the changes(as a temporary solution)

braford_w_byron

I'm having the same issue. Built-In DO_KEY > COMMIT_FORM causes the form to lock up for about 15 minutes then it throws an error message

braford_w_byron

Update: DO_KEY > COMMIT_FORM works when called from a Menu option but not in WHEN-VALIDATE-RECORD

1 - 7

Post Details

Added on Apr 27 2021
7 comments
2,741 views