Hello @paul harland As explained in my first post :I need to display a list of qualifications, according to the selected employee.
it’s a custom method, exactly.Have you added the custom package and method according to IFS standards?I can see my other custom procedures which requiere parameters, so, what’s the method to add to IFS standards for a method with no parameter?Make sure you refreshed the dictionary cache.I did it but still, no success :/
We are currently in APP 10 upd 5Is there an alternative?
Hello @dsj Still, by selecting the no parameter element from the combobox, I can’t find my method, which is present in the following path :IFS applications > IFS Customer runtime configuration component > my custom packageShould I select a component in first?EDIT : I selected the component (CONFIG), still no sucess...
@Marcel.Ausan I guess that CO means “customer order”, but what’s CRIM?About lobbys, I suppose the problem can easily be solved either by using the #USER_DEFAULT_SITE# variable to filter the site or by adding a variable on the lobby page.About sheduled tasks, it’s possible to add a parameter to filter on the site and then, running again the same script but with another site.In my end, I took the habbit to consider the OBJKEY of the object of the view to get every information I need, but still, I would still need to make sure there would have no conflict on objects because of the lack of the filter on the site. In my case, I met some issues on an event about INVENTORY_PART, as queries were filtering only the PART_NO field...
Hello @VBGLinda That’s not related to any SQL querry.EDIT : thats the interface we have
Hello @Marcel.Ausan Thanks for your feedback, but I don’t understand the screen you are showing, it’s probably because we are still using the UPD5 of IFS ….On my side, I had a look at IFS packages, and I found Fnd_Session_API.Get_Language to get the user language. I made some tests in which I was in french and in english versions, in both cases, I could get the right language ISO code.EDIT : I think you are not showing a possible response to my question, it’s not a matter related to the prompt of the custom fields, but it’s about the script behind my read only custom field which returns a text which needs to be translated
@Link I made the following test via sql developper :DECLARE -- p0 -> __lsResult p0_ VARCHAR2(32000) := NULL; -- p1 -> __sObjid p1_ VARCHAR2(32000) := 'ABCDEFGH'; -- p2 -> __g_Bind.s[0] p2_ VARCHAR2(32000) := 'CF$_NEW_INVOICE_NO'||chr(31)||'123'||chr(30); -- p3 -> __lsAttr p3_ VARCHAR2(32000) := 'SERVER_CHANGE'||chr(31)||'FALSE'||chr(30); -- p4 -> __sAction p4_ VARCHAR2(32000) := 'DO';BEGIN p3_:=''; IFSAPP.CUSTOMER_ORDER_INV_ITEM_CFP.Cf_Modify__(p0_ , p1_ , p2_ , p3_ , p4_ ); COMMIT;END; And surprisely, that works very well. About using an event, I can’t see how that would work, as me as a user, I can’t save any new data on IFS if the invoice is in preliminary status...
Hello. The update must be done independently of the invoice status.I will report that IFS can’t make that possible, I will see how we will proceed, say, making a read only CF
Hello?
Hello, what’s the non db field value?
Hello @filiep.vw Are you talking about your default browser?
Hello @Hypervox Unfortunately, that cannot be a solution, as the user would need to fill the CF either via the customer order or the customer order line screen.So, from what I understand, there is no way to share the CF in these screens, so I would have to create events for that
the code woud be more like this :BEGIN IF FLOOR(&NEW:COUNT)!=CEIL(&NEW:COUNT) THEN --display an error message END IF;END;
Hello.Another idea and more handy than the idea I suggested would be to create a custom attribute.In name, I would put IS_CUSTOMER_ID_OKIn server method, I would put something like MyPackageName.Get_Is_Customer_ID_OK(&NEW:CUSTOMER_ID) I would define the procedure like this : FUNCTION Get_Is_Customer_ID_OK(P_CUSTOMER_ID VARCHAR2) RETURN numberISBEGIN IF P_CUSTOMER_ID LIKE ‘15%’ OR P_CUSTOMER_ID LIKE ‘25%’ THEN RETURN 1;ELSE RETURN 0;END IF;END Get_Is_Customer_ID_OK; So, with this new attribute, in the event action screen, you put as new conditionIS_CUSTOMER_ID_OK = 1And this way, you would have just 1 custom action.
@Link I explained everything in my post, you just have to transfer your code into your custom procedure
Heya.I guess it’s better to make a deferred call in that case. DECLARE Attr_cf_ VARCHAR2(32000);BEGIN Client_SYS.Clear_Attr(Attr_cf_); Client_SYS.Add_To_Attr('MESSAGE_ID_', '&NEW:MESSAGE_ID' ,Attr_cf_); Client_SYS.Add_To_Attr('CATALOG_NO_' ,'&NEW:CATALOG_NO' ,Attr_cf_); Client_SYS.Add_To_Attr('LINE_NO_' , '&NEW:LINE_NO',Attr_cf_);….transaction_sys.deferred_call('MY_CUSTOM_PACKAGE_API.MY_PROCEDURE_NAME','PARAMETER',Attr_cf_ ,'A comment about the goal of my cutom procedure');END; Parameter 1 : your package name, then, your procedure name Parameter 2 : no idea what it is about, I simply left PARAMETER Parameter 3 : Attr_cf_ Parameter 4 : a message which describes the goal of your custom procedure
Hello @Link Be carreful, as metionned in my previous post as a comment, Client_SYS.Clear_Attr(attr_);is here to erase the content of attr_, so it’s same as if you doattr_ := ‘’ ;
Hello @Link attr_ VARCHAR2(32000);Client_SYS.Clear_Attr(attr_); -- same as attr_:='';Client_SYS.Add_To_Attr('ORDER_NO', '1234' , attr_); --on here, ORDER_NO is an SQL column and '1234' is the valueClient_SYS.Add_To_Attr('CONTRACT', 'ABC' , attr_);….
Hello @Hanane That wouldn’t be a nice solution, but I would make 2 custom actions.On your first one, you would define the condition :NEW:CUSTOMER_ID like 15%And a second one with the conditionNEW:CUSTOMER_ID like 25% Inside these 2 custom actions, you would put the exact same code
Hello @Hanane is that a persistant or a read only ?By your last screenshot you shared, I suppose it’s a persistant one.In that case, I guess you won’t have any other solution than to create a custom event, in which you might correct the value of your CF
Still awaiting a solution
Hello. By published the CF on SOURCE_LINE_SHIPMENT_ALT, I’m getting this error message : But this error message doesn’t pop up when I publish the whole CF on CUSTOMER_ORDER_JOIN only (never tried on any other view name so far).
Hello @Charith Epitawatta Thanks for the feedback, I guessed there were no solution about my request, but I least, I have a confirmation.From what I understand, you are refering about the use of IFS system monitoring ? I have no information of how to connect, I have tried to use the ifsapp account, no success…About my request, when I explained it wasn’t possible, they changed their idea, and now, I will instead use multiple lobbies.
Already have an account? Login
No account yet? Create an account
Enter your 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.
