HiWhat would be the best way to take on Customer Owned Stock priced at zero cost?We manage serialised inventory and equipment and need a method of enabling our users to enter inventory where they stumble across it without any Req or PO.Is there a good API to use in an Excel Mig Job? Is there an IFS screen that I haven’t yet found 😀We are using Apps 9 SP11
HiWe have changed our licensing agreement recently and I’m developing a report to show our full user licence holders. I also wanted to add a column to show employees that utilise the Time Clock CTU lincence in IFS Apps 9.My guess was that it looked for a tick in the box for ‘Time & Attendance’ in the Person Terminal Data tab of the Employee Admin screen AND that the employee needs to be currently employed. I get an extra 400+ records of the reported licence usage with this SQL…select * from terminal_personwhere TIME_AND_ATTEN = 'TRUE'and EMP_NO IN (Select EMP_NO from PERSON_PUBLIC_HR_INFO);Any idea what other criteria the licence management area applies to further reduce my results?
HiI created a very simple IAL (Apps 9 SP11) with the following SQL...select * FROM DBA_SCHEDULER_JOBSThis view is SYS owned and is set as a public synonym. The view has been granted privs to SELECT to IFSINFO. The IAL is named MT_SYS_DBA_JOBSWhen I execute the following SQL from SQL Developer all is well…select * from IFSINFO.MT_SYS_DBA_JOBSYet, when I execute from a Quick Report or the SQL Query Tool I get this error…Cannot convert JDBC type -101 to PlsqlType Any ideas?
I’m trying to configure an Excel Migration Job to act on an API that accepts a single attribute, which is a string of keys. I wondered if anyone has had any experience in doing this or something similar.This is the string I get from debug (without the carriage returns) that uses the POSITION_UTIL_API.Modify_Pos method… p0_ VARCHAR2(32000) := 'STRUCT_ID'||chr(31)||'16'||chr(30)|| 'POS_CODE'||chr(31)||'500042162'||chr(30)|| 'VALID_FROM'||chr(31)||'2023-05-22-00.00.00'||chr(30)|| 'VALID_TO'||chr(31)||'9999-12-31-00.00.00'||chr(30)|| 'OLD_POS_CODE'||chr(31)||'500042318'||chr(30)|| 'SUP_POS_CODE'||chr(31)||'500042319'||chr(30);I’ve tried many variations in Excel like replacing the || with & and double-quoting like “’STRUCT_ID’”.
HiDoes anyone know if there is any other way to update the Supervisor / Parent Position ID of a Position other than by using the drag & drop method in the Graphical Position Structure form?We are using Apps 9 SP11. Many thanksPaul
HiIs anybody automatically matching rental lines to invoices in IFS. We have done it with PO lines but we are looking for a solution to do it with Rental lines that would feed into accruals for period-end reporting
We are experiencing very poor performance on our live system and trying to understand what is causing it.We can see that at database level users are logging in but we see many users are getting a collection of sessions, maybe as they move around screens and such like. We see that their 1st session appears to be locking their 2nd session and this manifests as a screen that freezes with the little ‘processing’ pop-up upon saving a record.We also see one user’s session is locking out another user’s sessionsI wondered if anyone on here has experienced this and if it is possible to manage it We’re on Apps 9 SP11 - 2 X Windows App Servers with 3 X Linux Oracle Database servers. All load balanced
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.