We would like to use DOC0160 for two departments to print new enquiries on a daily basis and update the status to AI (as per feature 2 in Status Codes - HIG9110). The enquiry class / type filters the records for the teams.
The report does not include the target date. Is there a way to add it?
The report also reprints already printed records. Is there a way to stop this e.g. only printing a specific status off?
Thank you Fezan
I followed your steps but I am now getting an Error when running the report. I set my sequence 12 as I already have an 11 but it also fails if set to 11.
Error “REP-1425: An error occurred running DO_SQL package in program unit f_1formattrigger: An error occurred parsing the SQL statement: ORA--340532296: Message -340532296 not found; product=RDBMS; facility..”
Thank you for trying to help with this. I have had a play in the test database and if I keep the number of items in GRI0240 below 12 I don’t get the error. However it is adding the items to DOC0160 to use as part of the selection but I fear there has been a misunderstanding on the original request.
I want to add the Target Date to the report that DOC0160 produces, I don’t need to filter based on the target date.
Yes please Fezan. If there is no way we can edit the existing report please submit an enhancement. I think this would be useful to more than just us.
Answer Verified By: Paul Withington