Displaying a Text 'REPRINT 'on the 2nd 3rd etc.. times

Hi everyone I have a requirement from customer, they want to show text 'Reprint' or 'Copy' when they print same Official Receipt in 2nd, 3rd.... times. In first time they don't want to show this text. Please suggest me how to do this option in Reports Builder (Paper layout) or should i do it on Oracle EBS.

Thanks you so much.. i will appreciate all your answers.
johnpaul RañisesAsked:
Who is Participating?
johnpaul RañisesConnect With a Mentor Author Commented:
I mean Oracle Application
or should i put a query on my paper layout.?
Mark GeerlingsDatabase AdministratorCommented:
We had this same requirement some years ago when we had a custom system (not Oracle EBS) that used Oracle Reports.  We were able to get the word "Reprint" to be printed on documents only when they were actually reprinted.  We did this by modifying the Paper Layout to include to include this word only if the printed_date in the table this report was based on was already filled in with a date.  Normally in our system, the first printing of an invoice filled in this date after it printed the invoice once.

We don't know how to answer this question from you: "should I do it on Oracle EBS?"  Is your system an Oracle EBS system, or not?  If yes, that is more complicated.
Mark GeerlingsDatabase AdministratorCommented:
You will need a query or a function item in the report that checks a date and/or status on one of the records being printed to know whether the word "Reprint" should be printed, or not.
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

johnpaul RañisesAuthor Commented:
how should i start sir.? I'm just only a beginner with this.
can you give a  code sir.?

Mark GeerlingsDatabase AdministratorCommented:
In a custom system, with just Oracle Reports, this is quite easy.  In Oracle Applications though, almost everything is quite complex.  If you don't have experience making configuration changes or modifications in Oracle Applications, I recommend that you hire a consultant who has experience in Oracle Applications to guide you and assist you with this.
johnpaul RañisesAuthor Commented:
not solved
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.