@adrianm thanks a lot that works!Not sure what the difference is with a READ and a CALL function for projections.How should one find this out :-)?
@yohan can you see the odata logs on an IFS Cloud hosted setup? Or only on a remote deployment?
@Tomas Ruderfelt any chance you can use this IAL/Quick report in a workflow so you can first fetch some data and then do some actions on that data.
@sevo Best for everyone if we stick to English for the questions.What is not working at the moment? as custom fields should be just available in theview you want to select from. If you want to see custom fields you can search for the _CFV view to get your custom fields. For example. customer_order will have a customer_order_cfv view which you can query with a custom report
Hi Pankaj,How I understood IFS is that JSCH is SSH library IFS is using to connect to your SFTP server. Every SFTP server has a key which usually gets send over to the client and gets then stored onto your machine so if the sftp server changes that you will get a notice, “hey. the server you are connecting to is not having the same key anymore” So you can get the key also in other ways. For example on a mac or linux machine you can run a little script to get the keyssh-keyscan -t ecdsa -p "$port" -H "$host" | sed "s/^.*ecdsa-sha2-nistp256 /\[${host}]:${port}\ ecdsa-sha2-nistp256 /" you do not even need the password for this as the server is just exchanging this key the first time you connect. Usually an application like winscp is showing you the key, the first time you connect to the serverhttps://winscp.net/eng/docs/ssh_verifying_the_host_keyYou can copy this key into a simple text file and upload it to IFS
@Rukmal Fernando thanks for your comment. What I am looking for is can I know what variables are available in the execution? So how can I see that ${PartNo} is available? or is it ${PART_NO} , what other ifsBpaxxxx variables are available? So something like, the full list of parameters available when the workflow starts?
@kamnlk Thanks for the tips that helped to assure that the async workflow was actually triggering or not! I was not aware about the BPA_ASYNC_SYS_TAB table. My main question is now, how can we debug workflows in a better way. So what I did was the following:Create a custom event and see if the event triggers in all possible scenario I used an email action to see if for each time I did my action (aurena / wadaco browser / ifs scanit app) the event was triggered OK Which means I have a working event Next step is to create a workflow just with a start and end event Create an event action to trigger this workflow with a timing async I could see the workflow appearing in the BPA_ASYNC_SYS_TAB table OK I could see it becomes DONE Update the workflow with the logic requiredWorkflow goes into IP stage, without knowing why. So my main question is, How can we know what variables are available the moment the workflow executes? How can I know for example , is it PART_NO or PartNo? is "ifsBpaCu
@yohan @jasahu did you find a solution for this problem? We are struggling to understand why workflows are getting stuck in IP state. How did you do the retry option in the workflow?
@mmol did you ever found out what the issue was?
@diwelk @Marcel.Ausan Thanks I was not aware I could edit the line. I tried to add a new shipment line in object connections so the screenshot gave me the AHA moment :-) Maybe next question on this, any trick to say, ok remove documents after 10 days? so can you put a validity in document management after you attached it to a shipment? Or any advice how you can trim your document management for unneeded info. for example a picking list is not needed anymore after 10 days etc. ?
@Romain_SNP you can check this So try not to install as admin and check if all registry entries are set.
@MDDTJAMU what are you trying to achieve? Tax reports depend on a default template where fields are calculated based on the country specific calculations. Sometimes you can copy the default template and then adapt some items. But if there are certain calculations which are required, it could be that it has to be adapted by adapting the default template. So it depends a bit on what you try to achieve? (looks like a PL template?)
@dritter can you specify which put api projection you want to call?
@ibalfe could you share your workflow diagram and setting where you do the READ? Probably you have to use the nested entity feature but hard to tell without a nice workflow image ;-)
@ArcElhadC So issue was that the VALID_FROM_DATE is a key field storing its date as 2024-04-04 00:00 and when using sysdate, IFS does not complain but it stores the date as 2024-04-04 12:12 (note the difference in the hours)When you delete it tries to fetch the objid/objversion using this VALID_FROM_DATE and it cannot find any record because there is a mismatch between the dates, so for IFS the object does not exist anymore. to solve it you can use this so the date from sysdate is correctly created TO_CHAR(TO_DATE(SYSDATE, 'YYYY-MM-DD'),'YYYY-MM-DD') and that will work.
@tharindukshan really liked your idea here any ideas how to do the opposite?
@IFSRUNINNOVAL you cannot imho. Names are based on List + some date List_20240327_094402 If you need this in a csv or so on a regular basis, I think you should:Create an export migration job or schedule a quick report and drop the file on a server location with a specified name Or maybe through external file templates
@sevo you miss an IFSAPP.RECEIPT_INFO_ALT at the end of your FROMselect IFSAPP.Inventory_Location_API.Get_Warehouse(ria.CONTRACT,IFSAPP.Receipt_Info_Manager_API.Get_Default_Location_No(ria.SOURCE_REF1,ria.SOURCE_REF2,ria.SOURCE_REF3, ria.SOURCE_REF4, ria.SOURCE_REF_TYPE_DB)) FROM IFSAPP.RECEIPT_INFO_ALT ria
@Lahirumala de Mel Is this the same for using javascript array functions like map? We had an issue where we tried the following: var orderNos = CustomerOrderSet_Set.map(function(order) { return order.OrderNos;}).join(', ');execution.setVariable("OrderNos",orderNos);The workflow engine complains with a message “map is not a function” This code works perfectly if you try it outside of IFS but when trying to use it on a collection which is a result of an API READ action it gives this error? Can you confirm that we need to do the same type of fix when we want to apply some array functions on a collection coming from a READ action?We get this error
@MiLeNL @eqbstal @bdoucette We were looking for the same question and were wondering. Is there a way of achieving this with a validation workflow? It would be very nice to just expand the validation workflow with an end event with an info message in stead of a failure message? would that be possible? Or is using a user task the only option still? We are on 23R2
If you look for the error it is mostly two things: You should add these things to your header Make sure to encode your Etag correctly (you have to escape the \ . If-Match:W/"Vy8iQUFBUm5xQUIwQUFBNFVMQUFBOjIwMjQwMjAyMDQ1OTE2Ig=="Accept:application/json;odata.metadata=full;IEEE754Compatible=trueContent-Type:application/json;IEEE754Compatible=true @lisa.gilesAB could you show what you currently push to the system>? How your full api call looks like?
@Marcel.Ausan only way is to export to CSV using a datamigration job or external file assistant
@ZhanHao @jgrant_dci You can grant by default lobbies using the system parameter setting by doing this, every user with the FND_LOBBY_ADMIN permission set will be able to see the lobby created
@dsj thank you thats indeed a workaround ! Still curious if there is no other way to escape a ; will keep you posted if I get something back from support
@Alex_Mee For me it looks like that you can run a migration job resetting the condition code for your part in LOT_BATCH_MASTER_TAB Then via datafix you could do an update of the part_catalog UPDATE ifsapp.part_catalog_tab SET condition_code_usage= 'NOT_ALLOW_COND_CODE' WHERE part_no = 'MF-M-CRO-S1'; Ofcourse no guarantees but if it is for some test environment it could help.
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.
