Good afternoon @fatih.temiz 😊 I am having the same error creating a custom field with a reference from a Shop Order Operation View.Can you please explain where exactly you went?And what exactly did you change?Thanks in advance,Carlos Mendes
To solve this issue, I simply added to the quick report queries the following code, so if it is not PROD, it simply gives 0 lines back.AND UPPER((SELECT Sys_Context('UserEnv', 'Db_Name') AS Instance FROM Dual)) LIKE '%PROD%'
Good morning, I don’t know if this is still an issue or if this is of any help, but this error reminds me of a message we once recieved aswell.At the time, the problem was that the sales part didn’t have the sales part base price created in the menu of the image. Kind regards,Carlos Mendes
Ok, after some tests, was able to get it working.I leave here the solution if others need something similar.[&SELECT something FROM somewhere WHERE somefield=’[#IFSVariable]’]
Could you not use IDENTITY = Fnd_Session_API.Get_Fnd_User in the SELECT statement? Hi @Technical Outlaws ,That is also a possibility, however it wasn’t working beforehand because I had no quotes for the variable and I also had an error within the query filtering a field.Thanks for your feedback.Carlos Mendes
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.