Payables and Cash Management - EBS (MOSC)

MOSC Banner

Invoice Workbench: Exact Fetch Returns more than request number of rows - need sql trace

edited Apr 10, 2020 5:02AM in Payables and Cash Management - EBS (MOSC) 5 commentsAnswered

Hello,  in 12.1.3, whenever we enter an invoice and click on the lines, we get the exact fetch error.  The form does not show me the sql that was running at the time, which I need to determine the cause.

I've done a trace with binds and waits and I see many queries but the trace file does not show any errors.   I've done an FRD trace and the frd just repeats the error that I see in the form, but it does not tell me which query caused the error.

I am at a loss for how to obtain the query that is causing this.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center