• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

How do you a change a No Update Report?

ablock

Member
Does anyone know how to change a No Update Report to a Update Report?

A report was copied and I have made changes and realized the orginal person copied this report as a No Update report and it will not run properly.

Any help would be appreciated.
 
any one help me.In Report .when the level break values changes I want to fetch state code from another Table .in which event I have to write logic?
 

ablock

Member
Thanks to all for the response!!!

Update ol811.F9860 set siomit = '0' where siobnm = 'Rxxxxxx' and siomit = '1'

Worked!
 

bebinger

Member
Can anyone tell me whether this should work in 9.2? I've tried it on an object, but the log is still showing " Read Only Report, Fetch for update not executed." Your quick response will be greatly appreciated!
Thanks, Billie Ebinger
Dorel Juvenile Group
9.2
 

klwong

Legendary Poster
It looks like it should work. According to Oracle Doc 627916.1, your choices are:

1 - Copy the report to a new report, and define the copy as an update report. Recreate any versions. (Recommended solution for standard JDE objects)
2 - Update the column SIOMIT from 1 (No Update Report) to 0 (Update Report) for the custom report object in the Object Librarian table (F9860) using a SQL query. Taking a back-up of table F9860 is strongly recommended before updating the table. (Recommended solution for custom reports)
 
Top