Hi Anmise, I did change all ifsapp. to &AO.. but still I get the same error. select emp_no, &AO..Time_Pers_Diary_Result_API.Get_Presence_Hours(company_id, emp_no, valid_from, valid_to) presence, &AO..Time_Pers_Diary_Result_API.Get_Absence_Hours(company_id, emp_no, valid_from, valid_to) absence, &AO..Work_Sched_Assign_API.Get_Sched_Hours_Db(company_id, emp_no, valid_from, valid_to) schedule from &AO..AUTHORIZATION_EMP You will need to grant the IAL to one of the permission sets you are granted. There’s a tab in the permission set screen called IAL. Hi Anmise, Thanks a lot.. I had to grant right to the new IAL object to my IAL permission set I can now access the table with the query.
I’m connected to the dB as IFSADMIN which should have access to that IAL object.. am I right ? P.S. I’m executing the below query via PL/SQL where I’m connected to dB as IFSADMINSELECT * from IFSINFO.Get_Total_Additional_Hours
Hi Anmise, I did change all ifsapp. to &AO.. but still I get the same error. select emp_no, &AO..Time_Pers_Diary_Result_API.Get_Presence_Hours(company_id, emp_no, valid_from, valid_to) presence,&AO..Time_Pers_Diary_Result_API.Get_Absence_Hours(company_id, emp_no, valid_from, valid_to) absence,&AO..Work_Sched_Assign_API.Get_Sched_Hours_Db(company_id, emp_no, valid_from, valid_to) schedulefrom &AO..AUTHORIZATION_EMP
Hi Infaz, I’m on APPS9 Regards,Rajesh
Hi Sandun, I wanted to add more column to the record selector for Request for Order Quotation view… which means that is not possible.Anyways, thanks for you support !
Hi Guys, Is there any workaround for this.. ? I badly need to sort my Custom LU which is a list and that looks horrible without any sort order.
Hi Nadeesha, thanks for your suggestions..I did a work around and added LINE_NO as Source_Key_Name for the MenuItem1 and did not add this Qucik report parameter for MenuItem2By this way.. when the Parameter ISNULL() I can Suppress the Summary field. Passing Static value won’t work as we expected.. so instead I passed some field name which would always have an value and use ISNULL() to suppress the Summary field on the report.
Hi Nadeesha, Unfortunately, these options did not work.I tried TRUE, True, ‘True’ …. it still kept showing False - which was the first value of the Boolean parameter on the report.
Hi Nadeesha, I have this already.. but still it does not work.The report still shows the default value of the parameter (False)
Hello, You may need to check what is the underline query executing for the given records to be shown in your environment. As mentioned by Piyal the given lines will not be shown in latest reference environments. Hi Dumeesha, Thanks for your reply.. Do you know how can I see what query is executing when that checkbox is clicked ?
Aha.. status of the PO line ‘Cancelled”, you may have to filter out. That line noting to do with POCO. If you look at the before picture.. you will see line items 14,15,16 etc also are cancelled.i.e. Line_No 22,23 has same status as Line_No 14,15,16 etcSo I’m sure that the check box is using something different.
I think you can use “Line Status” column easily for your requirement. Hi Piyal, Unfortunately, Line_Status isn’t helpful.. please see the attached before and after differenceBEFORE AFTER
Hi Piyal, Hi Susith, Thanks for the reply. I get the reason what the check box does.I’m trying to use this condition on my report for showing “only” the Changed/New lines.The Purch_Chg_Ord_line shows few other lines also and the ObjState/Status column for all those lines are same. When I hit this check box, it show only the lines that were “really” changed.So I want to use that condition on my report to show only the changed lines rather than showing all from Purch_Chg_Ord_Line
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.