Since the cloud managed services options are limited to Oracle file storage (no network) what would be the option of integration via text/csv files with other systems (i.e. HR, Payroll, Projects, Shipping you name it, also cloud managed)? Setting up drop-zones for various integrated systems as Oracle paths brings up another question. How does one post files there, and how does one extract results? There are further limitations in using reverse proxy authentication for that, which does not offer access to oracle port .. and thus any oracle hits will need to come via local network or VPN. Since I can’t have a VPN with every 3rd party solution providers, how do I bring them to the local network?Hope it makes sense. If it doesn’t, I’ll rephrase :) Please let me know.
How might one create a barcode image as a custom field in Apps? (I found this unanswered on OpenIFS.)
Hi,We currently have an issue with one of our FTP servers that we use for DOCMAN so I moved all repositories to the other FTP server we use..I’ve moved all the existing files to the new FTP and created new repository, but now we still can’t view the existing documents so I’m assuming IFS is still looking at the ‘old’ location. Do I need to run the ‘Change Document Repository’ utility so IFS will look at the new location? Thanks,Mick.
Hello,We are converting Database Processes to Scheduled database Tasks, IFS8.I have few tasks that checks batch log and send emails accordingly, when i created in schedule database tasks, its sending same info again and again… how do i check the logs in Database Tasks or in Background Jobs , if any to accomplish this task. the query to modify is following, or any other way to achieve same resultSELECT lag(actual_start_date,1) over (order by actual_start_date) last_date FROM batch_job bj, batch_job_log bjl WHERE action = 'Temporay_API.Generate_Report' and bj.job_id = bjl.job_id and bjl.status = 'SUCCEEDED' order by actual_start_date desc; Thanks.
I have a customer that has a customer agreement for a part in Apps10: Part Min QTY Price 1 0 200 1 5 100 1 10 50 If a customer order is placed with three line items each with seperate Wanted Delivery Dates or Addresses with a quantity of 10 shouldn’t the system give them the $50 price? Customer Order Lines: Part QTY Date 1 5 2/1/2021 1 5 3/1/2021 Right now the system is giving each line item the 100 price instead of the 50 price.
We have need to calculate the number of hours between 2 dates, minus weekends. We’re using the OrderHistory tab’s rows.I have it working for just the number of days between 2 dates, and then did it for the number of hours (I simply removed TRUNC() around the 2 dates).But that included weekends and now the team wants just business days. I was able find a solution for 2 dates, but it doesn’t include the hours.I’m thinking the solution is to add HH24:MM:SS to the to_date() function but am receiving errors.How do I format to_date() to include hours in the calculation? SELECTSite,OrderNo,status,lag_status,dt,lag_dt,TO_CHAR(to_date(dt,'YYYY/MM/DD'),'DY','nls_date_language=english') as DT_DAY,TO_CHAR(to_date(lag_dt,'YYYY/MM/DD'),'DY','nls_date_language=english') as LAG_DT_DAY, (to_date(dt,'YYYY/MM/DD') - to_date(lag_dt,'YYYY/MM/DD') ) - ((((TRUNC(to_date(dt,'YYYY/MM/DD'),'D'))-(TRUNC(to_date(lag_dt,'YYYY/MM/DD'),'D')))/7)*2) - (CASE WHEN TO_CHAR(to_date(lag_dt,'YYYY/MM/DD'),'DY','nls_date_
Can someone help me rectify this query? Using Oracle 12CTrying to Pick Latest Activity date for each Customer Per state to use as subquery to gather rest of the dataHere is example data Customer_no State Activity_date 110913 CT 8/2/2019 110913 MA 9/22/2020 110913 MA 11/23/2020 110913 MA 11/23/2020 Desired result Customer_no State Activity_date 110913 CT 8/2/2019 110913 MA 11/23/2020 The query I write is following: looks like max() can’t pick one from same activity_dateDistinct is also not working… select customer_no,tax_State,max(activity_date) from table where customer_no ='110913' group by customer_no,tax_State and it bring this data Customer_no State Activity_date 110913 CT 8/2/2019 110913 MA 9/22/2020
I am trying to use the CC_CASE_API.Accept__(p0_, p1_, p2_, p3_, p4_)Is there a way to accept the case on behalf of another user? Currently using Apps 10 v8
Dear All, Could we add some columns in Default LOV in IFS 10 like In purchase order have Supplier column and data comes from LOV ( IFS LOV). I want to add column in this LOV. Is this possible , If Yes, then how can add columns. Kindly assist us. Thanks in advance.
Maybe a simple question, I want to transfer a database task from our test environment to the production environment. An export file (.ins) has been created.Should this be deployed via PL SQL and if so with which command?This is the 1st time I have to do this.
Am seeing the following error in the DB alert log when the event fires. -4091: ORA-04091: table IFSAPP.FNDCN_APPLICATION_MESSAGE_TAB is mutating, trigger/function may not see itORA-04091: table IFSAPP.FNDCN_APPLICATION_MESSAGE_TAB is mutating, trigger/function may not see itI have seen people getting around this with an autonomous pragma - but cant insert as am not executing an SQL block but sending an email. Any ideas?
Has anyone seen this Exception before? System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
HelloIFS8 -Can anyone assist me with using filter in the page ‘Grant Permission Set to User’, how can get multiple columns (Permissions sets).I tried semi colon and comma to separate them but that’s not working. which separator should i use to filter my columns.Thanks
Hi,I have Created a SEQUENCE and wanted to use within CUSTOM MENU with PL/SQL Block, but it’s raise Error:“Illegal SQL rejected: ifs.fnd.services.plsqlserver.service.security.RejectedSqlException: Illegal column IFSAPP.MY_SEQUENCE_ID.NEXTVAL” when i execute command using Custom Menu.Kindly help me to solve this issue.IFS Application 8Thnaks
Hi, We have recently copied our database, App9 first time in Oracle 19 and had an error message. Before we go down Support route has anyone else had this error message: ORA-04031: unable to allocate 48 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^f5f698ce","idndef : qcuAllocIdn")Use ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.2020-11-30T09:50:39.145808+00:00Errors in file C:\APP\ORACLE\diag\rdbms\ifscst\ifscst\trace\ifscst_j006_5824.trc (incident=296980):ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","select audit$ from tab$ wher...","SQLA","tmp")2020-11-30T09:50:39.145808+00:00Errors in file C:\APP\ORACLE\diag\rdbms\ifscst\ifscst\trace\ifscst_j008_4428.trc (incident=297005):ORA-04031: unable to allocate 48 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^f5f698ce","idndef : qcuAllocIdn")ORA-04031: unable to allocate 272 byte
Hi all, What is the Synchronize Application Search Index doing?We had run the Optimize Application Search Index in a test environment, which took around 2 hours to execute. There after we ran the Synchronize one, but that one took forever and we needed to kill it.What exactly is being synchronized and to what?
I would like to create a quick report on the Customer Order History which basically lists: Order NoDate AddedDate ReleasedDate Order Conf PrintedDate Delivered UserIdetc., The problem is that there can be many Order Conf Printed rows for the same order no.I have tried using Order No, MIN(history_no), Message Text, State etc., but would also want the UserId displayed but as different users may have printed the order confirmation then I could still end up with multiple rows being reported for the same order with the message_text ‘Order confirmation printed’. I did try:SELECT c1.order_no, c1.date_entered entered_date, c1.userid entered_userid, c1.hist_state entered_state, c2.date_entered released_date, c2.userid released_userid, c2.hist_state release_state, c6.date_entered conf_printed_date, c6.userid conf_printed_userid, c6.hist_state conf_printed_state, ABS(to_date(c1.date_entered,'dd/mm/yyyy') - to
Hi Can anyone has an idea how can I check the APIs Explorer in IFS 9?Thanks,
Hi all,sorry, this is more of a general SQL question. I have to find the next higher sequence-number depending on certain where-conditions:Table-example:╔═══════╦══════════════════╦═══════════════════════════╗║ Seq ║ Start_Time ║ Queue ║╠═══════╬══════════════════╬═══════════════════════════╣║ 34962 ║ 28.07.2020 17:06 ║ PQ_NEW PRICE REQUEST GMDM ║║ 35393 ║ 29.07.2020 11:03 ║ ║║ 35394 ║ 29.07.2020 11:03 ║ ║║ 42886 ║ 04.09.2020 14:16 ║ PQ_NEW PRICE REQUEST GMDM ║║ 42887 ║ 04.09.2020 14:16 ║ PQ_NEW PRICE REQUEST GMDM ║║ 42888 ║ 04.09.2020 14:16 ║ ║║ 42889 ║ 04.09.2020 14:16 ║ ║║ 42890 ║ 04.09.2020 14:17 ║ PQ_COST SWEDEN ║║ 42891 ║ 04.09.2020 14:17 ║ PQ_COST SWEDEN ║║ 42892 ║ 04.09.2020 14:17 ║ ║║ 42893 ║ 04.09.2020 14:17 ║ ║║ 42894 ║ 04.09.2020 14:17 ║ PQ_NEW PRICE REQUEST GMD
Hi all, I’ve created a new draft Purchase Order Crystal report - it pretty much got it’s design refreshed and re branded - all schema, data, report rules have been unchanged. I’ve given it different name to the original (added _v1 at the end). I’ve put it into correct folders on the server and I have also added new info in Report Definitions but yet I’m still getting typical error:Any ideas what else I’m missing? This is so far within test instance of IFS.
Hi, Does Apps 10 let you change the standard column names at the Presentation level (not database)? If the answer is no, are there any easy workarounds besides requesting a customization from IFS? Thank you!
Hi, I have tried to enable the Rowkey ProjectResourceSpread. After almost 2hrs the background job failed, please see screenshot below. Any pointers will be much appreciated. The Oracle related error message is: ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1632 ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 683 ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1226 Many thanks Miguel
Hi guys, I have a question about permission set.I created a new method, and after refreshing the dictionary i found that this method has been added in serveal permission sets.Could you please tell me why is it granted? Thank you!
We have a list of IFS document names in Sharepoint. Each document name has a link to IFS, which then opens the document. The link works when the user’s browser is Internet Explorer or Microsoft Edge. It fails when the user’s default browser is Chrome, Mozilla, Firefox, etc. That’s because the link must first open IFS 10 (which it can’t do) before IFS can open it for viewing. Requiring all our users to set their default browser to either IE or Edge is NOT an option.How do I force a document link to open with a specific browser? For example, if the user has Chrome as the default browser, how do I force the link to open IFS 10 in Microsoft Edge?
As of March 31, 2020, Transport Layer Security (TLS) 1.0 and 1.1 will no longer be supported. Do we support TLS 1.2 for APP8 version?customer is in Apps8 SP1 F1 SP2resource : https://support.umbrella.com/hc/en-us/articles/360033350851-End-of-Life-for-TLS-1-0-1-1-#:~:targetText=Answer%3A%20TLS%201.0%20and%201.1,to%20officially%20deprecate%20both%20protocols.
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.
