Please post the Application Release, Db version and OS details.
Application is 12.0.3,
DB is 11g
and Os is Windows Xp.
An I have done the personalization not the customization.
Hope u have clear on the problem
When you turn off the personalization, do you get the error.
If yes, there is a bug with this, please see
R12: APXINWKB: When Reviewing Invoices From a Batch Get Error APP-SQLAP-10186 'Please commit or clear your changes before continuing' [ID 831813.1]
R12: APXINWKB: Querying Invoices Using Folder Errors with FRM-41051 and ORA-06512 at APPS.GL_CURRENCY_API and FRM-40735 WHEN-VALIDATE-ITEM [ID 757322.1]
The following is for R12.1.1, But you can cross check
APXINWKB form: clicking OK in an error message window, session freezes [ID 859303.1]
I have tried by unchecking the persanilazation it is working fine.
What may be the cause...any idea.
Bit late (2 years!) to be answering this but I just hit the same problem and found this thread. After some experimentation I have come to this conclusion:
Probable route cause is I guess (this really is a guess, I have not looked at the standard form to confirm) a FORMS POST, probably executed by the AP Invoice WB form each time you navigate out of a header record.
I am guessing this because it is the most obvious thing I can think of that would result in a WHEN-VALIDATE-RECORD FP firing each time you navigate from one queried record to another. As you said, turning off the FP and closing+re-opening the form gets rid of the message.
I.e. FORMS POST causes WHEN-VALIDATE-RECORD causes FP to fire causes RECORD STATUS change causes APP-SQLAP-10186
My way round this is to add a condition to the FP trigger event: ":SYSTEM.RECORD_STATUS <> 'QUERY'" this should stop the FP firing until the user makes a manual change to the record.
This works for me (at least in unit testing) so I thought I'd post it here even though it's 2 years to late because someone else may hit the same issue and find this thread.