Replies posted by Charana Udugama

81 Replies

jaylee78Do Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

is there a way to set up a history log Attributes for permission set change (grant and revoke an object or method)?

Hi @jaylee78,I don’t think you will be able to track method level grants through History log. Probably for the best as these are tracked through base security sys tables and can become a massive overhead if logging is setup on those. You could try out a custom event (PRES_OBJECT_GRANT_TAB) for this matter since it records old value and new value. You can just record these values along with the session user and timestamp to a table you created. Once again, be vary on the overhead if you are doing lot of changes to security.Hope this works.Regards,Charana

2 years ago

craryitSidekick (Customer)

asked in Distribution (CRM, Commerce)

Importing Mass Amounts of Distribution Orders

Hi @craryit.I did a little digging on this. So my short answer is not to do this. There are multiple conditions being checked when a ‘Distribution Order’ is being created. For example, there are some calls to check in Purchase Order, Customer Order APIs. There are some records kept in DISTRIBUTION_ORDER_API and they are also being called and processed. Also, as you suspected there are some data being created in the Distribution Order History tables as well and these are also being created depending on certain values on the row of the parent table. As you can see, this is a complex operation and the code is and should handle it. Otherwise there could be errors popping in strange places. 😋So it is a bad idea. 😃Best Regards,Charana

2 years ago

Kandi GeorgeDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter insight

Hi @Kandi George,You can follow the guide here https://docs.ifs.com/techdocs/Best Regards,Charana

1 year ago

ZTC ZTC JGOTAHero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Any tutorial or instructions in how to utilize IFS Developer Studio?

Hi @ZTC ZTC JGOTA ,You can use this https://docs.ifs.com/techdocs/ given that you have access. Best Regards,Charana

2 years ago

Devni PanduwawalaHero (Employee)

asked in Products (Manufacturing, Products, Engineering)

Modifying Decimal places in ‘Sales and Operations planning for make to stock’ window

Hi @Devni Panduwawala,The issue can be addressed by following these stepsGo to Tools > Options> Regional Settings tab. Check the ‘Info’ and adjust the values accordingly. You can refer Modify Decimal places in Sales and Operations planning for make to stock | IFS Community were the same issue has been addressed previously. Best Regards,Charana

1 year ago

Erik ROLSidekick (Customer)

asked in Supply Chain

Custom Shipment Event Action

Hi @Erik ROL Here the issue is in the usage of Shipment_Flow_API.Get_Next_Step function. This function returns a list. Not a specific values. This function checks and lists out the next possible steps. And returns it as a single VARCHAR2. ie :- “Reserve, Report picking, Complete, Print pick list”So you need to go through this VARCHAR2 and treat it as a list and look for ‘RESERVE’. Best Regards,Charana

2 years ago

Christophe BUSSISidekick (Partner)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Supplier Template

Hi @Christophe BUSSI There is a way to do this:Step 1) you can use any existing Supplier as template by simply specifying it as Template Supplier Step 2: Go to the Quick Supplier Registration screen and use the Template Supplier I hope this helps.Best Regards,Charana

2 years ago

ludovic.rougeanHero (Customer)

asked in HCM (Human Capital Management, Payroll)

Custom tab with filtered data from other view

Hi @ludovic.rougean.In the IFS documentation, it is mentioned that “Custom Tabs let you attach pages as additional tabs to any tab form window. The attached pages can be both existing application pages or Custom Pages”.So, it describes that Custom Tabs can be added to Tab Form windows. Examples of Tab Form windows are “Purchase Order”, “Customer Order”, etc. All Tab Form windows are existing application windows.I hope this answers your question. Best Regards,Charana

2 years ago

ReinierHulsmanDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to connect Employee to Resource/Person via REST

Hi @ReinierHulsman ,The reason for this the scope of the method/function Get_Next_Sequence___. This method has 3 underscores(___) in the end of it's name. This means that this method is 'Implementation' in the IFS Scope and 'Private' in PL/SQL scopehis means that this method can be used within it's own API package RESOURCE_CONNECTION_API. If you look carefully in the API, you can see how it's used newsiterec_.resource_connection_seq := Get_Next_Sequence___;Also this function is not exposed to outside in the package specification. So, using this method outside of the API like RESOURCE_CONNECTION_API.Get_Next_Sequence___ is not going to work.Additionally, if you really need to use this method, I'd suggest you to use a custom method in Public scope within the API and use it inside that custom method.FUNCTION Custom_Method RETURN NUMBERIS seq_ NUMBER;BEGIN seq_ := Get_Next_Sequence___; RETURN seq_ ;=END Custom_Method;Hope this answers your question. Best Regards,Charana

2 years ago

signilsSidekick

asked in Assets (Asset Management)

Adding notes to Fixed Asset Object screen

Then I believe, you can go for the 2nd option “Or you can develop a custom procedures in both APIs to be called within once a new record is inserted in to FIN_NOTE_TEXT_API. This is not that tricky and safer if you know what you are doing.”Can you look into this?

2 years ago

signilsSidekick

asked in Assets (Asset Management)

Adding notes to Fixed Asset Object screen

Hi @signils,These 2 views are associated with FIN_NOTE_TEXT_API and FA_OBJECT_NOTE_API respectively.So in simpler terms, you can call for the FA_OBJECT_NOTE_API.New___ method within the Insert___ procedure of the FIN_NOTE_TEXT_API. This a bit tricky thing and needs to be handled very carefully. Or you can develop a custom procedures in both APIs to be called within once a new record is inserted in to FIN_NOTE_TEXT_API. This is not that tricky and safer if you know what you are doing.Else you can use a trigger in FIN_NOTE_TEXT_Tab to call the FA_OBJECT_NOTE_API.New___ method or directly insert into FA_OBJECT_NOTE_Tab. This is not the best way and personally I advise you not to go this route.I hope this helps. Best Regards,Charana

2 years ago

Ushan SenarathHero (Employee)

asked in Products (Manufacturing, Products, Engineering)

Estimate screen: Items shown in IEE are not in Aurena

Hi @Ushan Senarath, I’ve looked in all these pages in Aurena. But the mentioned data was not present in any of the pages. However, The mentioned data should technically be in the ‘Estimate Item’ page in Aurena. Because except for the tab ‘Details’, the other two ‘Components’ and ‘Operations’ is present in the page. There are 2 new Tabs ‘Additional Cost’ and ‘Calculation result’. But those didn’t have the mentioned data. So I guess, the data didn’t make it to Aurena. Best Regards,Charana

2 years ago

GayanDHero

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

APP9 Export to Excel- Date Issue after Year 2029

Hi @GayanD ,This is actually an issue in Microsoft Excel. It is an issue occurring when working with with two-digit year numbers. Here is the official documentation from Microsoft regarding the issue. Excel works with two-digit year numbers - Office | Microsoft DocsAs of now, the only solution seems to be entering the dates in 4 digit numbers. Which is an option in App9. With that the issue will be resolvedHope this helps.Best Regards,Charana

2 years ago

waidyahDo Gooder (Partner)

asked in HCM (Human Capital Management, Payroll)

IFS Connect Floe Stops upon Package Modification

Hi @waidyah,I think the usage of ‘TO_DATE’ is wrong. The correct usage should be the other way around. Can you try by interchanging date and the format? see below,TO_DATE(‘31/12/…….’, ‘DD/MM/YYYY)This might solve the issue. Comment further if you need further clarifications.Best Regards,Charana

2 years ago

Thomas WidmoserSidekick (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Alert | parallel tasks

Hi @Thomas Widmoser According to the FSM Mobile Alert | IFS Community post, it is possible. <Quote>The push notifications introduced in FSM6u5 would facilitate this but it requires an Azure config to setup.Details on the setup requirements can be found in FSM6u5 release notes on page 3.</Quote>Hope this helps. Best Regards,Charana

2 years ago

RpauleySidekick

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

how to get columns to appear in Lobby Data Source Designer

Hi @Rpauley, First of all, although there is a column named ‘Transaction Qty’ shown in the IEE, there is no Get_Transaction_QTY Function in the ‘INVENTORY_TRANSACTION_HIST_API’. The view ‘INVENTORY_TRANSACTION_HIST’, which is used here in the ‘Inventory Part on Hand Development’ has the column ‘QUANTITY’. Which is the one you see as ‘Transaction Qty’. So the function you should be using is, ‘INVENTORY_TRANSACTION_HIST_API.Get_Quantity(transaction_id)’.As you can see, the argument that is used here is the transaction_id. PS: You might need to look into the function Get_Transaction_Id_Tab in the same API if you need to get the transaction_id. Hope this answers your query. Best Regards,Charana Udugama

2 years ago

atvanstSidekick (Customer)

asked in Products (Manufacturing, Products, Engineering)

Calendar generation stop with error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Hi @atvanst,This error can cause due to basically 3 reasons. When you try to assign a value to a numeric variable, but the value is larger than the variable can handle. When you try to assign a value to a numeric variable, but the value is larger than the variable can handle When you are trying to assign a NULL value to a NOT NULL constrained variable.But it’s really hard to determine the exact reason without more information. If you are unable to determine and resolve the issue with this, please go ahead and raise a case to support. That’s the best option. Best Regards,Charana

2 years ago

chrisplantSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

ORDER_SUPP_DEM_EXT_TMP_VIEW - No data

Hi @chrisplant,I’ve looked into this view. This view ‘ORDER_SUPP_DEM_EXT_TMP_VIEW’ is built using the table ‘supply_demand_info_tmp’. So if there are data on the table, there should be data on the view.This table is being populated in the API ‘ORDER_SUPPLY_DEMAND_API’. The procedure used is ‘Add_Sup_Dem_Info___’. Using this method, you can populate the table and the view will be populated accordingly. There is another way, which is much easier but, could be problematic if not reverted in time. The method used to clean this temp data is in the same API. The procedure is ‘Clear_Old_Snapshots___’. This one fetches the data from the table and sends to ‘Clear_Snapshot___’ procedure for the clearing. So technically, if you comment out the call for ‘Clear_Snapshot___’ in the below lines,FOR rec_ IN get_old_snapshot_id LOOP Clear_Snapshot___(rec_.snapshot_id);END LOOP;You can stop it being cleared, hence the data will stay in the table and the view. Also be mindful that you might need to

2 years ago

dwilsDo Gooder (Customer)

asked in Finance (Financials)

Event Action Details Conditions

Hi @dwils,LIKE condition is used match patterns. This is almost same as what you use in Search in IFSAPPs.For an example we need names starting with the letter ‘R’. We can put the value as ‘R%’. If we need something that ends with the letters ‘er’. We can put the value as ‘%er’. Here is a document on the usage of LIKE Oracle / PLSQL: LIKE Condition (techonthenet.com)Hope this helps.Regards,Charana

2 years ago

Asela MunasingheSuperhero (Customer)

asked in Service (Touch Apps, MWO, MRO)

Escalation Matrix in IFS Support

Hi @Asela Munasinghe ,You can refer to this documented here in an external-facing knowledge article. Hope it helpsBest Regards,Charana

2 years ago

Jahir91Do Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Developer Studio

Hi @Jahir91,I’m not sure if this has the info you are looking for. But if you have access, this is the best place to get the required information and guidance. IFS Applications 10 Technical Documentation (ifsworld.com)Please refer to IFS Development Guide. Best Regards,Charana

1 year ago

ImankaSidekick (Customer)

asked in Supply Chain

Inventory part receipts in APP10 (Upgrading from APP9 to APP10)

Hi @Imanka ,In apps 10, inventory_part (TRUE/FALSE) is in receipt_info_tab. This is a bit different in Apps 9. The LU for ‘Purchase Order Receipt’ window is ‘PurchaseReceipt’. The view used for that window is PURCHASE_RECEIPT_NEW. This view has used the tables ‘purchase_receipt_tab’, ‘purchase_order_line_tab’, ‘purchase_order_tab’, ‘user_allowed_site_pub’. And the inventory_part(TRUE/FALSE) is in the table ‘purchase_order_line_tab’ Thanks,Charana

2 years ago

DeepakSidekick

asked in Supply Chain

Cancel customer Order

Hi @Deepak ,Canceling an order after marking Delivered is not possible according to the logic in the code. We might be able to look into the possibility of a data repair, please raise a ticket to support if you need to try it out. Best Regards,Charana

2 years ago

ZTC ZTC JGOTAHero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Rowkey Activated - No option to enable it

Hi @ZTC ZTC JGOTA ,First of all, which window are you working on? With that I might be able to provide you with the requirements needed for the ‘Activate Rowkey’ to be enabled.Also the menu strip options can be greyed out due to permissions. But if you are using AO in this case, this is due to the logic behind the command ‘Activate RowKey’.Also from my experience, if you are activating it via a SQL, it’s always an ‘update query’. If not you have to call the execute method of the command ‘Activate RowKey’ from the database which also could be subjected to logics and permissions. Best Regards,Charana

2 years ago

ravi.soniSidekick (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Internal data source for Demand Planner base flow

Hi Ravi,The ORA-01031: "insufficient privileges" error occurs when you attempt to execute a program or function for which you have not been granted the appropriate privileges. This error can be avoided by signing on as the appowner(ifsapp) or with any other user who has the appropriate privileges. Also you can simply grant the privileges to the user you are currently using. Thank you,Charana

2 years ago

Page 3 / 4

Replies posted by Charana Udugama

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded