We have set up the emailing of quick reports as Application Server tasks. One application server task per quick report to be scheduled. Job Type: Quick Report Queue: Batch2 Select the Quick Report to be scheduled List the email receivers in the field Email Address. Note the Application Message ID received and schedule it via Scheduled Tasks: Task Name: Run Application Server Task Application Message ID: The ID of the application message created in Application Server Task. I tried this but the job never runs it is always in waiting
You can use the layout tree on your left side to manipulate lines etc, like adding or removing them. actually I tried that but I am unable to select them as a separate line those 2 yellow lines are part of Header and body respectively and I need to understand how to reduce length of them
Does anyone have any views on why this problem might be there ? I am still looking for a solution
Hello @amrflynn I do not know if I understood your question clearly. What kind of report are referring to? IFS reports out of the box? Crystal or quick reports? the ones we make in IFS Report designer
for testing purpose I have set it to 1 hour
Now with errors gone the application message is stuck in waiting state only I tried setting up a time ahead of present time and waited for it to execute but nothing happened there
Hi, Please check that your SQL statement does not start with a blank character. BR Johan Lindström It was in fact the issue of extra space at the very start. I fixed that error but now I have this new error for Quick Report ID which is also weird because the ID it shows is not visible anywhere - Entity instance not found. (QUICK_REPORT - QUICK_REPORT_ID=624083.0)
Hi @amrflynn , Could you please double check your SQL statement and check if it has a “WITH” clause? Asking this because as far as I’m aware, it’s not possible to execute SQL expressions that begins with "WITH" clauses in quick reports. SQL expression is directly executed when previewing a quick report and it's executed through PL/SQL access provider when exporting to excel. Therefore, it’s not possible to use SQL expressions that begins with "WITH" clauses to export to excel due to a limitation in the PL/SQL access provider. Kind regards, Dinushi No it does not have a WITH statement but it makes me wonder what all are the limitations of PLSQL Provider do you have any knowledge about it ? because my sql statement uses ORDER BY, NVL, Subqueries and division operators. Do they cause errors ?
That I couldn’t comment on other than you indicate it works in English and not in Polish, leading me to believe language has a bearing. Not to mention experience with German and Chinese where even out of the box IFS code doesn’t always handle the full list of parameters that have to be evaluated for a function to operate. The difference between ‘false’ and ‘falsch’ in my example was enough to make views not open and errors to occur. It is also worth pointing out that when I did a copy special and ran the code in PLSQL Dev. I get the ORA-20110 Error does that mean anything to you ? It would really be helpful for me If you can help me understand this error as from my investigation it is different in each context(this error)
If the custom menu calls some portion of a field or the data in the field in English, but the data is now in Polish, the translation is not automatic. You have to provide all of the translations for the custom information as well as the code has to be written to handle the different possibilities in the data. yeah but if the data is part number only then how can the language become a barrier ?
Hi @Hakeem Sulaiman please check the attached document Best regards, Aneta Hi AnetaI would like to thank you for your comments.We also want to know If there are some concrete steps to set this up via PDF_REPORT_CREATED event.Because it is already working that way for one of our customer but for the other customer it is not working where they have separate email address for purchasing and AP team invoices.
Hakeem- There are several ways to send these emails. The setup I have used is attaching an event to the ‘print job’ of the invoice print. This is parameter specific (a list is available via F1 help under ‘email’ search). The basic data is on the customer record in both the contact list and the invoice tab. I hope this is helpful. Best-Christy I am afraid I am not able to understand what are you trying to suggest.Is it possible for you to give us a step by step solution for this ?Thanks a lot in advance.
This would again be a problem, because several batches have been approved already after this one. This means we would have to cancel approximately 7 batches = 7 days of work of 3 people!Is there any manual possibility for us to enter the batch and change the number?
As much as this solution seem to be working, There has been several batches in the row already approved, this would require to cancel several days of work of multiple people and repost it again. even If we try to do so, we get this error Is there a way to simply change the Order reference to a different number ?
Aah now it makes more sense . The error you are getting, is because the actual date type you are throwing into the procedure is not correct. The date type which you can give into the procedure are stated in the procedure itself. Right now you are passing something which is not supported. Hence the procedure is returning the; ‘Unknown date type’. If you try to give in the correct date type, i think it will start to work. Where to pass this correct date type ? I am also not sure by looking at this that what is the correct date type ? can you help me understand ?
Aah now it makes more sense . The error you are getting, is because the actual date type you are throwing into the procedure is not correct. The date type which you can give into the procedure are stated in the procedure itself. Right now you are passing something which is not supported. Hence the procedure is returning the; ‘Unknown date type’. If you try to give in the correct date type, i think it will start to work. Can you please help me understand what will be the date type here and do I need to define it below decalre for all 5 of these variables ?
Can you share your code? Not sure what you are trying. DECLAREinfo_ varchar2(4000);attr_ varchar2(4000); date_entered_ date;start_date_ date;CURSOR c1 ISSELECT * FROM PURCHASE_ORDER_LINE_PART_CFVWHERE CF$_ID_DOCUMENT = &CF$_ID_DOCUMENT;BEGIN --pdDate_ := &PLANNED_DELIVERY_DATE; IF &CF$_ID_DOCUMENT IS NULL OR &STATE = 'Closed' OR &STATE = 'Cancelled' THEN error_sys.appl_general ('PurchaseOrderLinePart','Dates Cannot be updated as the Document ID is NULL and/or Purchase Order staus is Closed/Cancelled.'); ELSE FOR rec_ IN c1 LOOP client_sys.Clear_Attr (attr_); date_entered_ := IFSAPP.Purchase_Order_Line_Part_API.Get_Date_Entered(rec_.Order_no , rec_.Line_no , rec_.Release_no ); Pur_Ord_Date_Calculation_API.Calculate_Order_Line_Dates(#WHAT IS THE SYNTAX FOR PASSING PARAMETERS HERE#); client_sys.Add_To_Attr('PLANNED_DELIVERY_DATE', rec_.planned_receipt_date , attr_ ); c
The problem which i think I am having is I am trying to call Pur_Ord_Date_Calculation_API.Calculate_Order_Line_Dates();when and I have to pass the values from the PO line that I have selected into this so that when I calculate it inside loop it applies that date taken from one line and apply it to all the other PO lines.Can you please help me understand how to pass the values from one line and apply it to all of them ? If that works than this whole issue will be fixed.
Yes it was successful in SQL developer for single record
Is there an error in the background jobs, when you print/send the invoice? Those invoices for those customers didn’t even come to the list of background jobs like for that customer(for whom it is working)
This is the error I get when i try to change dates and save the record.
Strange enough I am getting an error that says following - Server error messages:83705139-ef80-41a6-8250-4c5690be53cfIfs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-06550: line 8, column 23:PL/SQL: ORA-00942: table or view does not existFailed executing statement (ORA-06550: line 8, column 23:PL/SQL: ORA-00942: table or view does not existORA-06550: line 8, column 1:PL/SQL: SQL Statement ignoredORA-06550: line 18, column 4:PLS-00221: 'FND_STREAM_API' is not a procedure or is undefinedORA-06550: line 18, column 4:PL/SQL: Statement ignoredORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 2070ORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 2075ORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 1934ORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 1954ORA-06512: at "IFSAPP.EVENT_SYS", line 199ORA-06512: at "IFSAPP.SHOP_ORDER_DATE_MODIFY_EVU", line 13ORA-04088: error during execution of trigger 'IFSAP
Hi, Additional information about stream messages. Streams Message Creates a new stream message Parameters: From: The Foundation1 user who is sending the stream message To: The Foundation1 user who should receive the message Subject: This will be the header shown in the stream message. URL: The URL to navigate when the stream message in clicked. (Optional) Message: Message to display If you have properly configured the custom event and action a stream message will be available in the bottom left corner of the application. You can click on it to open. The community is awesome, Thanks a lot chamika it really helps.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
