Replies posted by Anjaleen Davidson

13 Replies

OrangeCloudSidekick (Customer)

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

Ignore Package Components via Sql query

Hi again Uzma @OrangeCloud ,If you want to use a SQL query then check column value “catalog_type” directly in SALES_PART_TAB. Even the previously mentioned getter method does the same.Best Regards,Anjaleen

2 years ago

OrangeCloudSidekick (Customer)

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

Ignore Package Components via Sql query

Hi Uzma @OrangeCloud , Sales_Part_API.Get_Catalog_Type() can be used for this purpose. There are two overload methods one only uses “catalog_no” and the other uses “contract” and “catalog_no”. Part types of sales parts are denoted as below.INVENTORY_PART = 'INV';NON_INVENTORY_PART = 'NON';PACKAGE_PART = 'PKG';COMPONENT_PART = 'KOMP' Therefore if the catalog_type is ‘KOMP’ then can ignore it.Best Regards,Anjaleen

2 years ago

AddKarolAHero (Partner)

asked in HCM (Human Capital Management, Payroll)

Present Employees

Hi Karolina @AddKarolA , Seems like by changing only the Trans Type cannot get Presence Status as ‘Business Travel’. I also tried couple of combinations even with Wage codes but ‘Presence Status’ gets values ‘Absence’, ‘Clocked In’ or ‘Clocked Out’. Therefore I’ve checked the relevant method behind this process Time_Pers_Diary_Clock_Util_API.Get_Presence_Status. According to the code structure it searches in several tables using employee_no and company_id. This method returns only one of these values ‘A’, ‘R’, ‘I’ or ‘O’ respectively denotes ‘Absence’, ‘Requested Absence’, ‘Clocked In’ and ‘Clocked Out’. So the other two options ‘B’ and ‘T’ respectively ‘Business Travel’ and ‘Training’ are not considered in this method. This denotes through manual changes Presence Status ‘B’ or ‘T’ cannot be achieved. I believe there could be other system processes involved.Hope this info is useful. Best Regards,Anjaleen

2 years ago

ADDEVOLSidekick (Partner)

asked in Products (Manufacturing, Products, Engineering)

Cannot insert null into QMAN_MANDATORY_PART_TAB"."SIMPLIFIED_REV_HANDLING

Hi Eva @ADDEVOL,Yes, as you have said bug 160770 involves with this change via UPD14. In method “Insert_From_Invent” of Qman_Mandatory_Part_API, before this patch the value of SIMPLIFIED_REV_HANDLING was hard-coded as “False”. But via above patch it was changed into a getter method as below. If the passed parameter “contract_” has a NULL value this getter will return a NULL value too to the holding variable. This can happen if the “Quality Basic Data Site” is set to NULL as you have previously identified. Since SIMPLIFIED_REV_HANDLING is a non-nullable attribute, during the insertion it will not allow to insert a NULL value. That’s why you were getting the above error message. Hope this info is useful.Best Regards,Anjaleen

2 years ago

jlblfrDo Gooder (Partner)

asked in Products (Manufacturing, Products, Engineering)

21R1 - Register arrivals : custom fields possible ?

Hi Jean @jlblfr ,I’ve checked in 21R1 Core environments also but as you have said entity ‘ReceivableObjectInfo’ cannot be configured. Even though I couldn’t see the information in the system, I believe this entity is not extendable therefore cannot have Custom Fields. There were several such non-extendable entities were found in page “Excluded Entities”. Below is what I’ve found in configurations page for non-extendable entity “IncomingInvoice”. Thanks,Anjaleen

1 year ago

Elath De SilvaHero (Employee)

asked in Products (Manufacturing, Products, Engineering)

Adding custom fields in IFS cloud environment

Hi Elath,Custom fields can be added in IFS Cloud environment also. There are few things to be checked before.System parameters for category Custom object frameworks should be enabled (ON). Otherwise custom fields cannot be added neither work. And custom fields can be added into respective underlying entity of your needed page via window 'Entity Configuration' as in below. Search for the needed entity and add as a new attribute in ‘Custom Attributes’ section. Example below adding custom fields to entity “CustomerInfo”. You can check the underlying entity info via Debug Console as in below.Example below shows entity relevant to page "Customer", which is ‘CustomerInfo’. After that created custom fields can be added into your page via 'Page Designer'. Hope this info will be helpful. Best Regards,Anjaleen

2 years ago

Jan SiekmannSidekick (Partner)

asked in Products (Manufacturing, Products, Engineering)

Part Class translation?

Hi Jan,In the Core application found LU “EngPartClass” related translations in “Text Translations” window. Please check below. Module involved is PDMCON. Kindly check whether this is available in your environment. Best Regards,Anjaleen

2 years ago

llemartinhaeDo Gooder (Customer)

asked in Finance (Financials)

is "YYYY" the same as "yyyy"

Hi Martin, YYYY returns the “year of the week”. Whereas yyyy just returns the specific “year of the date”.In your example 31/12/2020,“yyyy” denotes the year of the date, which is “2020”.“YYYY” denotes the year of the week. 31st of December 2020 is a Thursday but it falls in the 1st week of year 2021 as you can see below. Therefore YYYY returns 2021, which result in 31/12/2021. Better to use date format ”yyyy-MM-dd” since it is logically correct for your purpose. Hope this is what you have asked. Best Regards,Anjaleen

2 years ago

VIMNLKDo Gooder (Customer)

asked in Supply Chain

Purchase order attributes.

Hi Vimukthi,Found above attributes mentioned in file “dbo.Dm_FACT_PURCHASE_ORDER_LINE.sql” of component PURCFT. It is a Business Intelligence related component. Those attributes are fetched from table “Dm_FACT_PURCHASE_ORDER_LINE”. Best Regards,Anjaleen

2 years ago

mathieut43Do Gooder (Customer)

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

Sum of 2 values that I created in a logical unit by referring to another field of this same logical unit

Hi @mathieut43 ,Kindly check whether any read-only attributes have been involved in this process. This kind of error might occur during validation of read-only custom fields.Best Regards,Anjaleen

2 years ago

lisa.gilesABSidekick (Customer)

asked in Assets (Asset Management)

Active Separate Custom Field View

Hi @lisa.gilesAB ,While checking in the Core environment all the custom fields were listed in 'Active Work Orders' window. But there was a slight difference in number of Approved detail views. There were 2 approved detail views in Core environment as below, whereas its 1 in your case. When you click on this blue link, you can see that detail view ACTIVE_SEPARATE_OVERVIEW is in Approved state as below. I've cross-checked this with few other customers also. If the detail view ACTIVE_SEPARATE_OVERVIEW is not approved then the custom fields corresponding to the LU will not be displayed in 'Active Work Orders' window, as it is the underlying view.Kindly check whether detail view ACTIVE_SEPARATE_OVERVIEW is approved in your environment. If not, approve it and see the result. Best Regards,Anjaleen

2 years ago

Kalana RathnayakeHero (Employee)

asked in Upgrades & Updates

Error deploying file enable_rowkey.SQL - Database object has been discarded, trying to execute the statement again

Hi @Kalana Rathnayake ,I would like to add few information to @Bhagya Wickramasinghe . During the installation, install_tem file will check whether there are any disabled rowkeys available via Install_Tem_SYS.Disabled_Rowkey_Exist. Please check whether it returns 1. Also in Apps 9 in default rowkey is enabled. But if there are any changes made into the Database this error might arise. Also there is a Pre-installation script PRE_FNDBAS_UpdateRowkeyColumns.sql involves with rowkey update. Kindly check whether you have executed it before the installation. As for the case G2140483-A, while applying the update I did not get this Pre-script listed in Installation Instructions document. Hope this will help. Best Regards,Anjaleen

2 years ago

RpauleySidekick

asked in Products (Manufacturing, Products, Engineering)

Navigating with a group by function

Hi @Rpauley, Based on the screenshots that you have provided noticed that you have used CONTRACT in the GROUP BY clause whereas the select query uses “site_api.get_description(CONTRACT)” method.The column used in a Group By clause must be available in the select statement. You cannot select aggregates across a field if you don't include the field in the group by list. You can either include column CONTRACT into the select statement or use the “site_api.get_description(CONTRACT)” method itself in the Group By clause. Kindly try out and let me know the results. Thanks,Anjaleen

2 years ago

Replies posted by Anjaleen Davidson

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded