- - Knowledge base
Product Updates
Events
Groups
Feedback

Community
Search

Replies posted by Neil Guild

26 Replies

Newest first

Oldest first

Neil GuildSidekick (Customer)

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

Importing a Page Design to an environment

Hi @MiLeNL ,I have checked everything out and the import of the page has not worked as expected.I have an outstanding case with IFS to resolve this issue.Thanks for your efforts and I’ll update this case as soon as I get an answer from IFS. Cheers,Neil.

Neil GuildSidekick (Customer)

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

Importing a Page Design to an environment

Hi @MiLeNL, Strange indeed! I’ll check out opening the page designer and ensuring the context(s) are consistent 😊👍. Cheers,Neil.

Neil GuildSidekick (Customer)

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

Importing a Page Design to an environment

Hi, I understand. Is this still the case if the Custom Attributes are already present in the target system? Cheers,Neil.

Neil GuildSidekick (Customer)

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

Importing a Page Design to an environment

This is the screen showing details of the Application Configuration Package that has been imported.The Customer Order is the configuration that I am trying to use.It shows that the Customer Order is Approved, Published and In Sync yet it still doesn’t show up in the Customer Order screen, and I didn't do any Publishing, I just imported the ACP! Cheers,Neil.

SeeingSharpDo Gooder (Customer)

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

PL/SQL Access for IFS Cloud 22R1 Customers

Hi, Research on the internet has revealed that from Oracle Server version 12 and newer, connections from Oracle Clients versions older than 12 are not allowed by default, giving the errorora-28040: No matching authentication protocol. So, I had to download Instant Oracle Client version 19 and use that to make a connection to the Oracle 19c database. Thanks for all your helpful suggestions to the original problem @SeeingSharp See you on the Community again sometime :-). Cheers,Neil.

SeeingSharpDo Gooder (Customer)

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

PL/SQL Access for IFS Cloud 22R1 Customers

@SeeingSharp, Thanks for your suggestion.I have tried these lines in my sqlnet.ora and I still get the same error, so the search for the solution continues.I am using to try to access the database. You seem to be using Oracle SQL Developer, is it the same tool? Cheers,Neil.

SeeingSharpDo Gooder (Customer)

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

PL/SQL Access for IFS Cloud 22R1 Customers

Hi, Just for information: We are migrating from APPS8 to IFS Cloud and we raised a case with IFS to get access to the underlying database in the Cloud.This requires a VPN and once we had raised a case to get that sorted out (it was quite involved!) we got an email with details about the usernames and passwords that could be used to access the database. Cheers,Neil.

SeeingSharpDo Gooder (Customer)

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

PL/SQL Access for IFS Cloud 22R1 Customers

Hi, We have managed to get a VPN sorted out so that we can access the underlying databases but using PL/SQL Developer to try to connect to the database we are getting the following error:- I have Googled for help on this and the suggestion was that it was a version mismatch which would be solved by putting the following two lines in the sqlnet.ora file: SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8SQLNET.ALLOWED_LOGON_VERSION_SERVER=8. We have tried this and it has made no difference.We opened a case with IFS to get the VPN sorted out and because the VPN is ok they have just said that it is a user configuration problem so they just want to close the case with no further help. It would be great if someone who knows how to solve this apparent version mismatch problem with PL/SQL Developer could add to this thread with the answer please? Cheers,Neil.

Neil GuildSidekick (Customer)

asked in Upgrades & Updates

Updating user profiles after migrating from APPS8 to IFS Cloud

Hi @gianni.neves , You seem to be handling your migration in a different way to us.Congratulations on finding the answer. I would not have been able to help you to discover that answer! Cheers,Neil.

Neil GuildSidekick (Customer)

asked in Upgrades & Updates

Updating user profiles after migrating from APPS8 to IFS Cloud

Hi, I don’t know what state your 22R1 system is in or how you’ve handled the migration so far. We used IFS to migrate our APPS8 system to IFS Cloud and our APPS8 users formed the basis for the users in IFS Cloud. Although the structure of the users is very different between APPS8 and IFS Cloud, there are two base permission sets which are necessary for any user to log on in IFS Cloud and they were not present and that is why adding them enabled those users to logon. Basically, the building blocks for a user are permission sets which have access to a set of screens (known as Projections in IFS Cloud). Users are then granted a Permission set which has access to a set of screens (Projections). When we started off, we had a ‘Super user’ which had access to all screens and we used this one to identify the names of Projections that were necessary for each user type present in our original APPS8 system. There is extensive documentation available onlineL-Users - Technical Documentation For IFS

Neil GuildSidekick (Customer)

asked in Upgrades & Updates

Updating user profiles after migrating from APPS8 to IFS Cloud

Hi All, I have added two base permission sets, FND_CONNECT and FND_WEBENDUSER_MAIN to the IFS user concerned and that has enabled me to log on to IFSCloud successfully. So it seems that the answer was simply to add these two permission sets to the user. Cheers,Neil.

Neil GuildSidekick (Customer)

asked in Upgrades & Updates

Updating user profiles after migrating from APPS8 to IFS Cloud

Hi, @a.hutchingsthanks for your response but I’m still inclined to think that it is a Permissions problem as I have already tried the approach whereby I have granted all projections to a particular Permission Set and allocated that Permission Set to a particular user which is then able to log on with full application availability. It seems that it is a problem with identifying the correct subset of projections that apply to a particular user. Cheers,Neil.

Neil GuildSidekick (Customer)

asked in Service (Touch Apps, MWO, MRO)

Enumeration LOV only visible for IFSAPP

Hi, You can ignore this problem as it has been ‘solved’ in the meantime.My suspicion was that it was something to do with permissions and I have made the changes mentioned while logged in as a different BASE_PROFILE user and the LOV became visible for ‘ordinary’ users.It seems that this base profile solved the ‘permissions’ problem. Cheers,Neil.

Neil GuildSidekick (Customer)

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

Creating CSV files when printing Invoices in IFSAPP8

Thanks for your suggestion @Charith Epitawatta :-). I haven't had time to test anything out yet, having been diverted onto a different LIVE problem! Cheers,Neil.

Neil GuildSidekick (Customer)

asked in Supply Chain

Adding an item to work order cost/revenue analysis screen

Hi all, again, I got distracted by working on something else for a few days but I’d like to pursue this question again. I would really like someone’s help to give me a pointer to how I can go about getting this added piece of information on the Work Order Cost/Revenue Analysis screen, see below:- As I’ve explained, I’d like to add the status of the Work Order to each line of information to save having to exit the screen to go and find the status of each work order each time it was required. It would be much better to have this information available on each line of the display above.I have already added columns to other displays, but they have already been set up within a Custom Logical Unit and I've just added a custom field CF$_new_field to the appropriate VIEW in these instances.I have added WO_STATUS_ID to the WORK_ORDER2 view from which the above display is populated but can’t get IFS to see this new column. I have used the Debug Console to get the PL/SQL statement used to retrieve

Neil GuildSidekick (Customer)

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

Cache refresh after custom field modification

Hi @Charith Epitawatta, Yes , this clears everything up for me :-). Thanks for your help. Cheers,Neil

Neil GuildSidekick (Customer)

asked in Supply Chain

Synchronise Custom Field in IFS 8

Hi @Charith Epitawatta, Perfect! That is the answer :-). Thanks for your help. Cheers,Neil.

Neil GuildSidekick (Customer)

asked in Supply Chain

Table population

Hi,I have been able to use the Debug Console and viewed the SQL that creates the table. A couple of columns were missing and hence no population of those in the database.Implemented the correct SQL and the columns are populated correctly.Cheers,Neil.

Neil GuildSidekick (Customer)

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

IFS version 8 interface to Crystal Reports

Hi, The answer to this little problem was that the SQL that was used to create the table was missing references to a couple of columns, hence the field on the report being blank!The SQL was initiated by clicking on the Print function within the relevant IFS screen. Cheers,Neil.

Neil GuildSidekick (Customer)

asked in Assets (Asset Management)

Date format in IFS Active Work Order screen

Hi @anmise and anybody else out there who might be interested ;-). It seems that IFS SQL Statement cannot ignore the : character and always interprets it as a bind variable indicator. So, I had to manipulate the SQL statement to reformat the date that was held on the database as yyyymmdd hh:mi:ss. Here is the SELECT statement showing this manipulation:SELECT SUBSTR(COALESCE(MIN(SUBSTR(old_Value,1,8)), MIN(SUBSTR(New_Value,1,8))),7,2) ||'/' ||SUBSTR(COALESCE(MIN(SUBSTR(old_Value,1,8)), MIN(SUBSTR(New_Value,1,8))),5,2) ||'/' ||SUBSTR(COALESCE(MIN(SUBSTR(old_Value,1,8)), MIN(SUBSTR(New_Value,1,8))),1,4) ||' ' ||SUBSTR(COALESCE(MIN(old_Value), MIN(New_Value)),10,8) FROM TABLE_NAME.old_Value and New_Value are the database columns with the date in yyyymmdd hh:mi:ss format. And so this is solved, thanks. :-). Cheers,Neil.

Neil GuildSidekick (Customer)

asked in Assets (Asset Management)

Date format in IFS Active Work Order screen

Hi @anmise , I have seen that the text turning blue is simply an indication that the SQL statement has been modified. I tried clicking on the Published checkbox and the text turned black. So I am happy with that, however the SQL statement (with the to_date functionality in my previous post) which works in PL/SQL developer causes the message ‘Not all bind variables have a corresonding argument’ to be displayed when clicking on Finish in the Edit Custom Objects dialogue. Very frustrating. Do you know why IFS is complaining about bind variables in the statement which includes the to_date functionality? Cheers,Neil.

Neil GuildSidekick (Customer)

asked in Assets (Asset Management)

Date format in IFS Active Work Order screen

Hi @anmise , Thanks for your reply :-). Further investigation has revealed that they are indeed custom fields. The SQL statement is returning a string value directly from another table which is in that format (i.e. yyyymmdd hh:mi:ss)SELECT COALESCE(MIN(old_Value), MIN(New_Value))FROM history_log_tab aJOIN history_log_attribute_tab b ON a.log_id = b.log_id WHERE REPLACE(REPLACE(a.Keys, '^',''), 'WO_NO=','') = :Wo_NoAND a.history_type = 2 AND b.column_name = 'PLAN_F_DATE' I suppose that I need use a to_date function to convert this string to the correct date format (i.e. ‘dd/mm/yyyy hh:mi:ss’) but I’m not sure where to try to put it.I have tried to convert the old_Value/New_Value directly in the SELECT statement.TO_DATE(COALESCE(MIN(old_Value), MIN(New_Value)),'dd/mm/yyyy hh:mi:ss')FROM history_log_tab aJOIN history_log_attribute_tab b ON a.log_id = b.log_id WHERE REPLACE(REPLACE(a.Keys, '^',''), 'WO_NO=','') = :Wo_NoAND a.history_type = 2 AND b.column_name = 'PLAN_F_DATE' but th

Neil GuildSidekick (Customer)

asked in Assets (Asset Management)

Date format in IFS Active Work Order screen

Hi Guys,Is there anybody out there who can help with this little problem, please?I would appreciate any help :-).Cheers,Neil.

Neil GuildSidekick (Customer)

asked in Supply Chain

Table population

Hi @Avindu Hendawitharana , Thanks for your suggestion.I haven’t been able to use the debug console yet - still struggling with the implementation here at work.I have managed to find the procedure which I think is populating the table, so progress has been made :-).Cheers,Neil.

Neil GuildSidekick (Customer)

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

IFS version 8 interface to Crystal Reports

Ooops, dO I need to use @Shardha Weeratunga so that you are notified or something?I’m new to this forum!

1
2

Page 1 / 2

Badges

PREKNAPCZYKhas earned the badge 1st Topic
Hildebranthas earned the badge 1st Topic
yrosobihas earned the badge 1st Reply
HubertZhas earned the badge 10th Topic
Charana Udugamahas earned the badge 25th Answer

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