Our company are currently going through an upgrade from app9 to Cloud 22R2. We currently use Crystal reports and I am in the process of reviewing the crystal templates that are not working in the cloud environments.So far I am unable to connect the Crystal reports software (2020) into the cloud DB. - Does anything else need to be granted? I am trying to connect into the DB with my IFSdbreadonly credentials given to me to be able to use sql developer.
Our IT department are trying to install Business Analytics for a new user but are coming up against error due to the certificate not being trusted. - Screenshot attached. Is any one aware of any issues? We are on APP 9.
Hi, My org has a kaba clocking in /out system integrated with IFS which is subsequently used in conjunction with H&S / Fire alarm reporting via Crystal Report which is using the IFS report designer Alarm report held in the system.The Org is / has moved onto a secondary shift pattern and I am being advised that at some point overnight that the data is resetting so people who are clocking in are not showing on the report that should as they had not clocked out - however I can’t see any formulas or criteria being applied in crystal or the report designer template (admittedly I have never used report designer but the only formula fields I can see are text strings / concatenated fields).I have spent some time running the detail overnight to see the ‘reset’ and can confirm that when I ran the report at 1am and then at 6am that there was a difference (I had some users that had not clocked out the prior day so i would expect them to still show on the report if there is no additional criter
I have a custom field on the Inventory Transactions History Screen which I want to use as Criteria within a lobby datasource. (Product Family=’1000’) however I am getting error of Invalid Identifier. When I select * in SQL Developer or in the SQL query tool this custom field also is not available. What would be the best way for the custom field to effectively show in the database so I can use the needed criteria? Many Thanks Kirsten
Is it possible to change the character length’s in the basic data fields? I am specifically looking to increase the Commodity group code that sits in inventory part. Many Thanks Kirsten
I am trying to create a lobby data source using an intersect query.Effectively the query is pulling from the same view but using different criteria to match the records.The query works perfectly in SQL developer but I am having issues being able to make it work in the data source.Alternatively is there a way in a lobby to display quick report results rather than a link to the quick report? Many Thanks
I have a user who has managed to save the chart view (from the toolbar) as a default on the Supplier invoice analysis screen. So they always have to either select the chart button or F8 shortcut to revert to the correct default screen.Any ideas how to revert this?
I have added in a custom field (Commodity Code 3) into the inventory part screen, this is a LOV field and works fine. (Pulling from Commodity_Group)I have been attempting to add another field which auto populates the description from this LOV based on the selection made. I have tried using a reference (both persistent and read only) and an expression but so far everything I have tried does not populate - what’s the best way to achieve this? I am assuming that a select or expression statement would be best but the correct syntax is escaping me.
Our org is trying to enable SSO in App 9 - Our existing FND user string is user Initials and Employee ID - but the mapping for these areas is not supported in the AD attributes when mapping the fields in the Active Directory user integration Config screen. What’s the best way to enable SSO and retain the existing FNDUSER string? All other attempts so far have created duplicate user / Person. I have managed to get to a point of using another AD field that is supported to hold the FNDuser and map to it - but the user still can’t log in - aside from selecting “connect with your current windows credentials” in the IFS app login screen is there anything else that needs to be switched on? (Also not really the cleanest way to do it either)
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.