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

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

I created a custom page based on a projection in Aurena. I added it to the Navigator using Navigator Designer. The entry shows up in Navigator and when I click it the page shows the page title but without any content. If I go into Page Designer I see my page content. If I make a change, save, publish, revert change, save, publish, and exit Page Designer the content displays. I am on IFS 10 update 9. Is this a known issue or is there a workaround? This only applies to a custom pages and I don’t see this behavior with Standard pages.

Hi All,  I’,m having the error above? any reason why? and how can I fix this? Regards

Hello, my name is Oskar Conde and i have a problem with crystal report and IFS. When I use a condition in a box format the crystal report shows the correct result, but IFS print job show the default format. In IFS the format dissapears, like the condition is not true 

Is there a place where user login alerts are logged in APPS10?Seems like it is no longer available in the server alert log (previously database alert log)

Good Morning, i am trying to see if it is possible to get a column that would tell me my total percent to count for a month, example would be i have 4500 records and need to count 10% for this month the result in the column would give me 450. Below is screen shot of my SQL Data. Thank you for any help  

Good day madam or sir,I am figuring out how I can make a connection with IFS through OData.Environment SetupIt is a IFS APPS 10.6 demo license, installed on a VPS. I have created a user with full admin level, just like the ifsapp user. Windows Server 2016 Standard, version 1607. Windows Firewall: The port 48080 inbound and outbound rules are open / set to allow. There is no IIS installed. It is accessed via an IP address. And it is accessed via the same address that is added to the Windows hosts file with a name like: “https://aname-vps:48080”.Test ResultI have been able to create a new access token with help of Postman when I access it via the hosts file entry. When applying the token, I am receiving “Error 401--Unauthorized” or “403 Forbidden”.The request requires user authentication. The response MUST includea WWW-Authenticate header field (section 14.46) containing a challenge applicable to therequested resource. The client MAY repeat the request with a suitable Authorizationheader

Hi, I am trying to add history to Customer Order when the step approved. The problem is I can't take information from approval routing. History API new is working. I want to add a description of the step to history. Is there a way? DECLARE order_no_ VARCHAR(32000) := '&KEY01'; info_ VARCHAR2(32000) := NULL; objid_ VARCHAR2(32000) := NULL; objversion_ VARCHAR2(32000) := NULL; attr_ VARCHAR2(32000) := ''; mesaj_ VARCHAR2(1000); desc_ VARCHAR2(1000);BEGIN SELECT description INTO desc_ FROM approval_routing WHERE key_ref = ifsapp.client_sys.get_key_reference('CustomerOrderLine', 'ORDER_NO', order_no_) AND step_no = ifsapp.approval_routing_api.get_current_step('CustomerOrder', (ifsapp.client_sys.get_key_reference('CustomerOrderLine', 'ORDER_NO', order_no_))); mesaj_ := desc_ || ' verdi!'; FOR rec IN (SELECT * FROM customer_order WHERE order_no = order_no_) LOOP BEGIN attr_ := 'ORDER_NO' || chr(31) || rec.order_no || chr(30) || 'DATE_ENTERED'

Hello All,    Could we set permission set in Particular part number?   If yes ,please let me know .  

Dear Code experts, Currently we have granted all sites access to our spare part users in order to see the available stock in each site.  I have a requirement from business that this authorization must be controlled as below; we have to divide all stock Clerk into 2 groups;Group 1 : they can only maintain their default site’s inventory Group 2 : They can maintain their default site’s inventory + other sites inventory    In order to achieve this,  I created a custom event on Inventory_part_in_stock_tab,below is the code and it works for group 1. but for group 2 event doesn’t allowed to do transaction.I am not a developer so Am I missing something in below code ?    DECLAREDEF_ VARCHAR2(10);MULTI_ VARCHAR2(100);CURSOR C_ALLOW_multi_  IS SELECT CONTRACT  from USER_ALLOWED_SITE_CFV where userid = '&FND_USER' AND CF$_ALLOW_MULTI_SITE_DB = 'Y';BEGINOPEN  C_ALLOW_multi_;FETCH  C_ALLOW_multi_ INTO MULTI_;CLOSE  C_ALLOW_multi_;IF ( '&NEW:CONTRACT' <> '&DEF_USER' ) OR ( '&NE

Hi,Please can you provide information on the below issue we are seeing across our estate while rolling out Microsoft Edge.We are using IFS Apps 8.IFS Users use Edge to open IFS with ClickOne and are now seeing this additional pop up: We would rather that a User not be forced each time to go through this step and click Open.Our infrastructure engineers have confirmed that the GPO settings that manage the Microsoft Edge browser are compliant with Microsoft Security Guidelines and have tested to the limit their solutions. Any information would be greatly appreciated.RegardsShaun

Hiwhen trying to login to Aurena we received the attached error. Has anyone had this issue before? Regards Gary  

How to increase the time out on external load balancer or the ELB parameters to increase?

Working with the existing LU EngPartRevision, we added some custom fields to extend the LU in a centralized testing environment.  After standing up a new development environment, we created the custom fields by exporting an Application Configuration Package (ACP) and importing it into the new environment.  The fields validated and imported into an Approved state.  When I attempt to publish and synchronize the custom fields, I receive the error “COMPILE_ERROR2:  Error during compilation of LU [EngPartRevision]” that looks like it is related to extended the custom view (CFV).    

We are having issues with users trying to change their password. We in Apps 10 and we were asked by IFS to navigate to the database object “Change_Password_Dbip_” and grant that to our base functionality permission set. When I go there and try and grant it I RMB and there is no option to grant this. Does anyone know why this is happening?  

I am trying to configure the ChangeRequestHandling projection to add the existing ApprovalRouting entity to the existing Change Request page. After setting ApprovalRouting as the Configured Entity and setting the Entity Associations I expected to be able to find the Approval Routing entity in Page Designer when configuring the Change Request page after adding ApprovalRouting to the projection but don’t see it there.If I add the projection to an ACP I get the error message:Dependent objectsINFO: This item uses other configurations. The followingwere also added to the package: “ApprovalProcess”Custom Logical Units “”The Custom Logical Unit “ApprovalRouting” which is usedby the Projection Config”ChangeRequestHandling” wasnot automatically added to the package because theCustom Logical Unit definition was not found. Why is Aurena looking for a Custom Logical Unit instead of the Standard LU?This is with IFS 10 update 9.

As I create custom fields, I would like the column header text to word wrap to preserve page width. I see that IFS does this natively for some of the column headers. Is there a character I can place in the column prompt that will word wrap to two lines?

I have created a custom page with different tabs and View Page option shows data correctly.Then I added this page to navigator using Navigator Configuration, saved and published. But when viewing the page from the navigator, it gives an error. How can I fix this?Thank you. 

Rather than using the Forward option or manually selecting report distribution group when ordering a report, is there any way of automatically making a report available to pre-defined distribution groups? (Something similar to user access control in Doc Mgt perhaps)

I have been asked to display an information message to give a reminder to users where there are attached documents. The user will be in Shipment Lines and will RMB on a Shipment Line and open the associated Shipment.  When the Shipment opens, if there are attached documents an Information Message is required to be displayed as a gentle prompt to users. As there is not a trigger at this point, how do I go about firing the custom event? At the moment the custom event is as follows: Custom Attributes:Name:    ATTACHED_DOC_NO Server Method PL/SQL: IFSAPP.Doc_Reference_Object_API.Get_Object_Connection_Count__('Shipment','SHIPMENT_ID='||'&OLD:SHIPMENT_ID'||'^')Data Type: Number Conditions for performing action:ATTACHED_DOC_NO > 0 Action Details:BEGIN     Client_SYS.Add_Info('Shipment', 'ATTACHED_DOCUMENT:  This Shipment has Attached Documents.');END;  Thanks.

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.

Hi,I would like to share some useful SQL codes of mine. You can share yours in the comments.  Remove DECLARE info_ VARCHAR2(2000);BEGIN ifsapp.language_sys.set_language('en'); FOR rec_ IN (SELECT * FROM /*Table*/ p /*WHERE p.*/) LOOP ifsapp./*Api*/.remove__(info_, rec_.objid, rec_.objversion, 'DO'); END LOOP;END;New DECLARE info_ VARCHAR2(32000) := NULL; objid_ VARCHAR2(32000) := NULL; objversion_ VARCHAR2(32000) := NULL; attr_ VARCHAR2(32000) := '';BEGIN ifsapp.language_sys.set_language('en'); FOR rec IN (SELECT * FROM /*Table*/ t /*where*/) LOOP BEGIN attr_ := 'ORDER_NO' || chr(31) || rec.order_no || chr(30); --Fill the attr ifsapp./*Api*/.new__(info_, objid_, objversion_, attr_, 'DO'); END; END LOOP;END;ModifyDECLARE order_no_ VARCHAR2(32000) := 'I1510'; line_no_ VARCHAR2(32000) := '1'; rel_no_ VARCHAR2(32000) := '1'; line_item_no_ VARCHAR2(32000) := '0'; ne

I have simple migration job on customs_statistics_number view. Simply insert and modify three fields of this view. When I ran the job it inserts all fields to table successfully. However when existing row is updated, the migration job do not update Description field. This seems very weird as insert works but update of this particular field does not happens. All other fields are updated without any problems. Has anyone experience this issue in apps 9 before I raise this as a bug with IFS?  

I am trying to insert the history row to customer order while inserting the date is converting wrong. I tried many ways but still the same. How should I write? SELECT client_sys.attr_value_to_date(to_date(SYSDATE)) FROM dualSELECT client_sys.attr_value_to_date(to_date(SYSDATE, 'dd/mm/yy HH:MI:SS')) FROM dual   

I would like to be able to embed a map or video in a Lobby Web Element.  At the moment I can load a page but it loads the entire page which is very cumbersome in a lobby element.  It would be great to be able to just load the embed codes that you get from video hosting or map sites.