- - Knowledge base
Product Updates
Events
Groups
Feedback

Community
Search

Replies posted by Hans Andersen

236 Replies

Newest first

Oldest first

Hans AndersenHero (Partner)

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

Getting CONN_STR from plsqlap_environment_tab through an API

Thanks for the suggestion @knepiosko ,Already looked there. No luck.

Hans AndersenHero (Partner)

asked in Products (Manufacturing, Products, Engineering)

From which supplier was the supplier copied from?

We decided to highjack a note field that is copied to the new supplier.

chajashHero (Customer)

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

Custom field question/Help

@chajash,See my comment above. Your enumeration does not match the return value of the function. Switch to e.g. FndBoolean.

chajashHero (Customer)

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

Custom field question/Help

I have tried adding it as an Expression Boolean field, but no information comes through I presume you are calling pur_ord_pay_sched_line_api.Exist_Pay_Sched_Lines().It returns varchar2. -’TRUE’ or ‘FALSE’. If your enumeration do not contain these values it might just fail.

mdeantonDo Gooder (Customer)

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

User defined system parameter

@mdeanton,You can add new values like this:declare info_ varchar2(32000); objid_ varchar2(32000); objversion_ varchar2(32000); attr_ varchar2(32000); begin client_sys.Clear_Attr(attr_); client_sys.Add_To_Attr('OBJECT_LU','OBJECT_LU',attr_); client_sys.Add_To_Attr('OBJECT_KEY','OBJECT_KEY',attr_); client_sys.Add_To_Attr('PROPERTY_NAME','PROPERTY_NAME',attr_); client_sys.Add_To_Attr('PROPERTY_VALUE','PROPERTY_VALUE',attr_); client_sys.Add_To_Attr('VALIDATION_METHOD','',attr_); client_sys.Add_To_Attr('VALIDATION_ENABLED','FALSE',attr_); Object_Property_API.New__(info_, objid_, objversion_, attr_, 'DO');end;But as a customer, I am not sure you are allowed to.When we have some custom settings, we store them in a CLU.

mdeantonDo Gooder (Customer)

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

User defined system parameter

@mdeanton,I have noticed that out IFS partner is doing this: select Object_Property_API.Get_Value('CDelnoteTransfer','IND002','TABLE_NAME_LINK') from dual;

geminirajeshHero

asked in Products (Manufacturing, Products, Engineering)

Get Shop order number on customer order line

@geminirajesh, If you want it as a custom field, you can do this: Result:

ZTC ZTC JGOTAHero (Customer)

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

Persistent - Custom Field - Data Type Text

However, why does the application allow the creation of persistent fields? The application should only allow read-only fields to be created. The LU ‘InventoryPartInStock’ allow persistent CF’s. You can edit them through code. Just not in this window.E.g. make a RMB that transfer to a CLU. There you can type in a value for you CF. On save, fire an event that copy the value back to InventoryPartInStock.

ZTC ZTC JGOTAHero (Customer)

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

Persistent - Custom Field - Data Type Text

@ZTC ZTC JGOTA ,This window is read-only for all fields. All changes have to done with RMB or elsewhere.

Hans AndersenHero (Partner)

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

Increase speed when searching read only custom fields

@Tracy Norwillo ,It is working fine with few data. But this is want I get with only 8000 rows:

Hans AndersenHero (Partner)

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

Increase speed when searching read only custom fields

Thanks for the suggestions, @Tomas Ruderfelt ,Unfortunate, we are using this for RMB navigations: Both read only cf-fields contain the same values. The problem is the one highlighted. It have to be calculated for all rows for every navigation. For now, I have solved it by making that field persistent instead of read only. At regular intervals I sync the 2 fields. Not a good solution, but the initial solution was bad and had to be replaced.

Hans AndersenHero (Partner)

asked in Finance (Financials)

Add a charge to every customer invoice

@Ozgun BAL ,We have considered that, but it is for every invoice. Not just the ones connected to an order.

Hans AndersenHero (Partner)

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

Error: Index was outside the bounds of the array

@SaraCrank ,I exported a similar profile (did not have a back-up):Then imported is as the corrupt one.No problem since. But we do now back up the profiles regularly.

Hans AndersenHero (Partner)

asked in Products (Manufacturing, Products, Engineering)

Schedule operations based on a fixed date

Thanks @Björn Hultgren ,It was the functionality I was looking for.

MounikaSidekick (Partner)

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

Unable to print multiple copies of an order report

Hi @Mounika ,This looks like bug. Copies it not saved to the xml file: A workaround could be to first print to ‘no_printout’, wait for it to complete, change the printer and print again. That would give you 2 copies. PRAGMA AUTONOMOUS_TRANSACTION;...print_job_api.Set_Printer_Id(print_job_id_,'NO_PRINTOUT'); print_Job_API.Print(print_job_id_); commit;DBMS_LOCK.Sleep(5); --replace with loop on print job statusprint_job_api.Set_Printer_Id(print_job_id_,printer_id_); print_Job_API.Print(print_job_id_);commit;I have not tried it.

OmaNasseADo Gooder (Partner)

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

How to call Database Task from Custom Menu

@OmaNasseA , Try with:argument_type_db_=>'PARAMETER’,Probably also remove commit;

ZTC ZTC JGOTAHero (Customer)

asked in Document Management (DocMan)

What will be the best way to copy files from Oracle?

@Mathias Dahl , We do NOT Base64 encode the data before storing it in the table column. The bytes are stored as they are in the BLOB When I wrote the code I must have convinced myself otherwise. The above code is working, but better just to do this instead :

ZTC ZTC JGOTAHero (Customer)

asked in Document Management (DocMan)

What will be the best way to copy files from Oracle?

Hi @ZTC ZTC JGOTA I do not know of a IFS tool that can do that, but it can be done with the IFS data providerif you are using the database repository the file will be stored as base64 in column edm_file_storage.file_data. The procedure will then be:Create the sql that fetch the files. Loop through the files. Extract the bytes. Send the bytes to a storage (stream, file, database)Below is a code snippet on howto stream a file (httpResponse) in c#.You can also save the bytes to a file.

ATZSUMITSidekick (Customer)

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

Lobby | List View | Top 15 rows should be seen in list view

Hi @ATZSUMIT ,Using rownum like that is not reliable.You can create a IAL and use that as data source:

Hans AndersenHero (Partner)

asked in Products (Manufacturing, Products, Engineering)

Reserve more qty for a customer order than required

Hi @Tharaka Senevirathne ,The documentation is not 100% correct here. It is possible to reserve more from the picking list. I was hoping for a hidden api that would do that.

llemartinhaeDo Gooder (Customer)

asked in Finance (Financials)

is "YYYY" the same as "yyyy"

@llemartinhae,I think there is something else wrong in your system. 2020 had 53 weeks: Therefore yyyy and YYYY should return 2020.

carlosfmendesSidekick (Customer)

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

Inventory Part Revision on Product Structure Revision

Hi @carlosfmendes ,You can make you sql into a string and the execute it as a background job.See this: https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/how-to-create-a-defered-job-to-execute-modify-1757

asked in Document Management (DocMan)

How to automatically uncheck default boxes when creating new revisions?

We would like to also have it unchecked. We only make new revisions, because there is a new file revision.

jamiewhiteSidekick (Customer)

asked in Products (Manufacturing, Products, Engineering)

Upload Bill of materials from Solidworks

Hi @jamiewhite ,You may be able to find commercial solution somewhere. If not, according to this, it should be ‘fairly’ easy to program a solution. We do something similar.

BirkanAYDINDo Gooder (Customer)

asked in Products (Manufacturing, Products, Engineering)

Inventory of cut raw materials

We use a combination of wdr and availability control id. wdr to inform on the real size of the piece.Every night we run a job that set availability control id based on some criteria's.

1
2
3
4
...
10

Page 1 / 10

Badges

SSkinnerhas earned the badge 1st Topic
Bhanwarhas earned the badge 5th Reply
Bhanwarhas earned the badge 5th Topic
JProvencherhas earned the badge 1st Reply
CraigWhytockhas earned the badge 5th Topic

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login as an IFS Employee

or

Username (Do not use your email as a username.) *

Email Address (Use your work email address.) *

Name *

Company *

Account Number

(Private)

Only you and moderators can see this information

Job Title *

Member Type *

IFS Employee IFS Partner IFS Customer Just Visiting

Products Used

(Private)

Only you and moderators can see this information

IFS Cloud IFS Applications FSM PSO Maintenix Fleet Planner Alliance FieldCentrix assyst MWM Other

Country

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login as an IFS Employee

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK