This feels like a n00b question... I'm writing a report in SQL. What is the best JOIN clause from the inventory transaction history (INVENTORY_TRANSACTION_HIST) to the customer order invoices (CUSTOMER_ORDER_INV_JOIN)? I want to see the inventory transaction history so I can see all the cost elements on an invoiced order line. I need a solution capable of handling multiple deliveries on the same line. The closest I've gotten so far is to use the proximity of the invoice and delivery dates, but that doesn’t feel completely right. I don't think I need to handle credits (yet).
Hi GuysI’ve created a Custom api (using PLSQL Developer) and trying to setup a Database Task Schedule using same. Normally, i create DB task using PLSQL developer only but this time change of approach and thought of trying Schedule DB task.Following below process:Created a Package and made sure it got Module_ and lu_name_ declared within header (as suggested by @durette )Step 1: create or replace package CB_MS_LEVEL_1_API is module_ CONSTANT VARCHAR2(25) := 'FNDBAS'; lu_name_ CONSTANT VARCHAR2(25) := 'CbMsLevel1Api';Step 2: Refreshed the Dictionary CacheStep 3: Granted access to ifssys as well as to public GRANT EXECUTE ON cb_ms_level_1_api TO ifssys;Step 4: Granted access to FND_USER BEGIN security_sys.grant_package('cb_ms_level_1_api','FND_ENDUSER'); END;Still when re-logged into IFS and checked Task Name within New Database Task Schedule i can’t trace the api.What am i missing, any suggestions? Thanks in advan
Has anyone had a custom background job killed by a schedule Light Cleanup? The job is marked as “Exclude from Cleanup,” we did this after it happened the first time and thought it would keep it from happening again. This background job was executed at the exact time listed in the error of the above background job. These are in two different queue’s as we’ve moved a majority of our custom jobs into their own to keep jobs processing. On another note, how often are you running the Light Cleanup job? What’s the suggested time frame?We are on IFS10 UPD10.
We have a custom logical unit with a list of tasks that need to be handled. It works well, but we overlooked the need to know who is assigned to each task. We could simply create a freeform text field for the employee’s name that is assigned to handle that task, but that opens up a host of issues and inconsistencies that could create issues down the road. We would prefer to create a custom enumeration so the field becomes a drop down list of specific users. I could do this manually, but we don't want to create something we would have to manually maintain in the future.Ideally, we would like to see the list populated with all users that are assigned to specific roles that have permission to update the form. Can that be done?
Hi, It seems that IFS is set up more for global purchasing where supplier settings (Buyers, Delivery & Order confirmation reminders, etc.) apply to the group and cannot be set differently for different sites if the same supplier ID is used. Often sites in our business have slightly different approaches to managing and expediting suppliers, and site buyers want the autonomy to apply their own settings for suppliers. I am reaching out to see if anyone has experience, thoughts or suggestions on how this should be resolved? Thanks in advance.
Hi Community, I have found below installation error below when deploying UPD12.!!!Error occurred while executing Plsql BlockBEGIN Object_Connection_SYS.Refresh_Active_List__(5);END;ORA-20105: Assert.IS_LOGICAL_UNIT: "CounselingPlan" is non existing logical unit. But I can't find a logical unit called "CounselingPlan".So do I need to follow any manual steps to fix this? Thanks,Kalana
Hi everyoneI am new here and I have recently started playing with IFS 9. Unfortunately, I do not have a very good introduction to the meanders of the system. Recently I found a nice thing, the possibility of using the API (for example: approval_routing_api.check_exist) when I do procedures / functions in PL SQL (SqlDeveloper).For now, I am extracting information about the API options that I can use with the debugger and the tests in the test environment in the application.Would you be so good at telling you where I can look for leads, or a list of API options with a description?Thank you very much for help :)
Hi,On the sales part it is possible to set a minimum sales qty, but is it also possible to set the sales qty as a fixed multiple. For example, you can only order multiples of 100 (100 - 200 - 300 -...) and not 250 for example?I would think there would be a standard field for something like this but I can’t seem to find it. Best RegardsRoel Timmermans
I want use sinhala font in crystal reports. we entered data using Sinhala Font(iskoola pota) to IFS application. In both ‘SQL’ and ‘crystal report preview’ the data shows in Sinhala. But When try preview in IFS application , it is not working. I installed the iskoola pota sinhala font in IFS Application server and re-started it. but it is still not working
Hi all, We experience a slower performance on our Test Environment, and when looking into what could have caused this, we ran into below query: SELECT 1FROM (SELECT M.APPLICATION_MESSAGE_ID,XMLCAST(XMLQUERY('$mb/*:Envelope/*:Body/REPLICATION/SENDER_MESSAGE_ID' PASSING XMLTYPE(B.MESSAGE_VALUE, NLS_CHARSET_ID('AL32UTF8')) AS "mb" RETURNING CONTENT) AS NUMBER)SENDER_MESSAGE_ID FROM FNDCN_APPLICATION_MESSAGE_TAB M, FNDCN_MESSAGE_BODY_TAB B, FNDCN_APPLICATION_MESSAGE_TAB QWHERE M.STATE = :B2AND M.APPLICATION_MESSAGE_ID = B.APPLICATION_MESSAGE_IDAND Q.QUEUE = M.QUEUE AND Q.APPLICATION_MESSAGE_ID = :B1AND B.SEQ_NO = 1ORDER BY M.APPLICATION_MESSAGE_ID DESC FETCH FIRST 100 ROWS ONLY)WHERE SENDER_MESSAGE_ID = :B3 Anyone having any idea what this query is doing? We see this query on our two environments that have UPD9 installed, not on the environments that are still on UPD7.
Hello, everyone!Is anyone familiar with using a scanned barcode value as an input to an Aurena page field?Is it feasible for the barcode scanner to take the order number as a field input and display the accompanying image in an Aurena image viewer?Thanks
Hello IFS community, I created a custom API using the following information:module_ CONSTANT VARCHAR2(25) := 'EJUANL';lu_name_ CONSTANT VARCHAR2(25) := 'ZPURCHARSEAPI';lu_prompt_ CONSTANT VARCHAR2(25) := 'ZPURCHARSEAPI';When I try to create a database task, I am only able to see the name “eJUAN Sol”. I do not have (+) symbol displaying the custom API (see example below highlighted in yellow). What do I need to do to make all the procedures and functions in my custom API available to create a task?FYI - I already refreshed the cache.I was expecting to find something like the custom API => eNYNC Solutions, where I can click on (+) and see all the procedures and functions. You can see what I have in my custom APIcreate or replace package Z_PURCHASE_ORDER_API ismodule_ CONSTANT VARCHAR2(25) := 'EJUANL';lu_name_ CONSTANT VARCHAR2(25) := 'ZPURCHARSEAPI';lu_prompt_
Hello,I have an idea for creating a custom note on an LU and populating it with history log data.BUSINESS NEED: We want to log the changes of certain fields on Purchase Orders, and want that information to be assembled in a note that can be attached to the Purchase Order. We do not want to use the Purchase Order note for this, we want a special field (so will add it as a Custom Attribute of the PurchaseOrder LU). ELEGANT PATH: Use History Log to store changes to the Purchase Order for just the fields we want. Then add a Custom Event to the PurchaseOrder LU, “after” save, linked to a PL/SQL Action that grabs History Log data related to a recent time-frame, the current purchase order, and the current user. Append new History Log information to the custom note we added in Step 1. CHALLENGE: Timing and avoiding redundant data. Does IFS write data to the History Log, synchronously and completely, before an “after” Custom Event fires for the LU? How can we determine what changes just occurre
Hi,I hope someone can help.I have created two custom fields, one for Region and the other for Description. The fields will sit side by side, however, I would like to hide the label from the second Custom Field (Description). For Example: currently I have “Region: Description: *Field* *Field*”I would prefer to amend the Region label to include Description, so would like “Region Description: *Field* *Field*”So to omit the unwanted colon after Region.Is this possible?
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.