Hello,I am looking for some input and see if someone can help me find a solution for the below PL/SQL Block that is used for a Right Click Menu.The blow Block is supposed to fetch 2 tables and then if a value is not in the Customer order table to add them in the 2nd custom table (CUSTOM LU) and ensure there are no duplicate records created. DECLAREp0_ VARCHAR2(32000);p1_ VARCHAR2(32000);p2_ VARCHAR2(32000);p3_ VARCHAR2(32000):= NULL;P_ORDER_ VARCHAR2(32000);P_VIN_ VARCHAR2(17):= NULL;C_ORDER_ VARCHAR2(32000);C_VIN_ VARCHAR2(17):= NULL;CURSOR PLANNED_VINS ISSELECT DISTINCT &AO.CUSTOMER_ORDER_LINE_CFP.Get_Cf$_Planned_Vin(objkey) FROM &AO.customer_order_line WHERE ORDER_NO = &ORDER_NO and &AO.CUSTOMER_ORDER_LINE_CFP.Get_Cf$_Planned_Vin(objkey) is not NULL ;CURSOR CHASSIS_TRACKER ISSELECT DISTINCT CF$_FULL_VINFROM &AO.C_L_U_CHASSIS_TRACKER_CLV WHERE CF$_ORDER_NO = &ORDER_NO and CF$_FULL_VIN is not null;BEGINOPEN PLANNED_VINS;OPEN CHASSIS_TRACKER;LOOPFETCH PLANNED_VI
Hello, I have run into a rather interesting challenge I can’t seem to solve.I create a Migration Job for the Excel addin, its purpose is mass change shop order dates.The Source Mapping was auto generated via the default settings on the migration job.When I Open the Migration Job in Excel and use the search and try to search with a date field, the search does not convert the query into the appropriate date logic. Is this something I need to somehow program into the Source Mapping itself?Migration Job:Excel IFS Search:Checking the Advanced Tab to validate and resulting error:Manually correcting this makes it work. This however is not great for the end user as they need to know to make this change when searching for dates and becomes more difficult to use.Looking forward to some possible solutions.
Hello everyone,I have been running into an odd error after creating a new user and assigning existing permission sets to the new user. The permission sets work fine on the existing user but for the new user i receive the below error, does anyone per chance know how to resolve this? Is it security related or do we have to open a Support ticket? Database error occurred. Contact administrator.Url: https://yourwebserver.com/main/ifsapplications/projection/v1/ShopFloorWorkbenchHandling.svc/GetIdentificationByCardEnabled()Date = 2021-06-24T22:43:25.591ZClient version = 10.9.104.0 Any help is greatly appreciated.
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.