Solved

Hi AllIm trying to create a custom event which needs to use the Time portion of a DATE field, in this case to run a check against Holiday Request records.  When I put the event code in as follows, it only seems to bring through the Date itself with the Time always being set to 00.00.00.  This is despite the Debug Console showing that the time being put into the database is something else such as 11.30.00.Has anyone had any success with the use of Date and Time in custom events?My event code currently is DECLARE   TIME_TO_         TIMESTAMP := TO_TIMESTAMP('&NEW:TIME_TO', 'YYYY-MM-DD-HH.MI.SS');BEGINerror_sys.Record_General('',TIME_TO_);END;The error shows that only the Date part is filled.  I have tried DATE instead of TIMESTAMP with the same resultCheersGareth

Hi,Very often we see background jobs in status ERROR with the message “...object is locked by another user.“.How can I handle this in my PLSQL procedure? There is a lock_sys package and oracle has a v$lock table.The lock_sys takes lock_name_ as a parameter. I don’t know what that is.The second includes an ADDR column. I don’t know what that refers to. Can any of this be used to handle this error, by fx postpone the execution of the job if the object is locked?BR Kresten

Hi, I have a doubt here:A part has a stocking unit of measure of “EACH”. A case is made up of 12 each. Scene 1: Customer ABC orders 4 eaches, and the order is shipped for 4 eaches. Scene 2: Customer XYZ orders 1 case and the order is shipped for 1 full case. In this situation, the system should ship a complete case and not split it into eaches. Is this possible? How do the parts need to be setup? Is there additional setup need for parts like unit of measure etc.

I am accustomed to creating tax reports using tax codes.  I created a tax structure to test the report function but the tax structure tab is not an option.  Am I missing a base setup item?  The company setup is on Address and the customer has the tax structure listed.  Thank you!

I have a project set up that has related work activities.  Note that this activity field is a custom field.  When I want to search for an activity to attach to this particular project, the search brings up every activity in the database, for “all” projects.  Is there a way to customize this activity field or the Search to only populate the activities for the project I have assigned in the line?Just looking for a way to possibly speed up the search.

Is it possible to link to another lobby from a lobby. I tried creating a link element with the page ID of my sub lobby but that didn’t seem to work

at IFS 10 UPD8I want get user login history  When did the user log in and when did they log out?the info of under history 1,login user name 2,The user login time 3,The user logout time4,Best if possible to see what the user did in login timethank you!setup it in under table? 

We want to copy all the configuration from PROD to Preprod like resource creation,shift creation, skill,division etc. Please advise how to do this if anybody knows.

Hi, I am trying to perform the printing of a report automatically after some event. Can anyone explain how this works?I found the mpm ‘perform_get_report_pdf’ and passed that name to a newly created Value Custom Process by defining this MPM as the ‘Perform Name To Call’ in the process parameters. When I define my business rule I will find myself the parameters of this MPM.However from here I am not sure how to proceed and how I could pass the right value to the parameter ‘report_parameters’? Thank you in advance!

Hello,We are in the process of upgrade from IFS 8 to IFS 10. I noticed Customer_Info_Comm_Method_Api is no more available in IFS 10. I am looking for function get_default_phone(customer_no),before i rewrite it in IFS 10 for our internal use, i wanted to check if someone knows whether IFS added this function in some other API or any replacement for Customer_Info_Comm_Method_Api.If someone have some document where IFS disclose such db changes, that might be helpful too.ThanksUzma 

Hi everyone How can I add new person to” Executed By” section in Separate PM Action tabs

Looking for feedback on an easy method to view and copy access from one user to another.  For example, when a new employee is created they need added in many different areas of the IFS system before they can perform their job.  I’ve listed a few as an exampleDocument Management Basic Data Approvals Quality  Shop Floor Employee Basic Data Users per User Group Purchase Requisitions user Site Settings WADACO processes Maintenance Resource Time Clock TerminalIs there a method in IFS to run a report that shows you where a user ID is used in these areas so if there is a new hire, or role change - you can make the necessary changes in the system?  I imagine you could get this data from the User Security Report or Object Security Report with the right criteria.

Hi all,We are running a production with a considerably amount of programming (cad/cam/dtp) between operations. We need to register the time used. For that we have created a the work center, Programming. The routing can look like this:This leaves us with some challenges. The main one is that programming can finish before and after the other operations. E.g. operation 20 can finish before operation 10 (not possible in IFS) and the other way around.We suspect that we should do this in another way. Any suggestions? 

Hi,Last sunday we cloned the PROD database to our TEST enviroment. After that the TEST enviroment is not working anymore. When I start IFS test the following error pops up:  THE URI: https:"LINK_OF_IFS_TEST_AS”:58080/fndext/clientgateway/ cannot be found. Please contact your sys admin. Error 404 - Not Found. Does anyone recognized this problem or knows the solution? Best regards,Bram

Hello, I have created a saved search that uses Sum and Grouping. I’ve built the Lobby element, and it is rendering correctly. However, I’ve updated the Navigation to give the user the ability to be taken to the saved search data when they click the Lobby element. When I click the Lobby element, it takes the user to the IFS screen, however, it seems to be dropping the Sum and Grouping. Is this simply a limitation of the Lobby navigation, or is there additional configuration that is needed on the Lobby element? Any help would be greatly appreciated. 

Hello I would like to check how the AR/AP netting functionality can be applied for intercompany netting.Scenario: Companies with in same group and the same instance of IFS, trade with each other and generate intercompany balances(AP in one company will be AR in another company).For the current netting functionality to be used, both AP and AR balance should be in the same company.Is there a way to net and close these AP and AR balances in different companies instead of making the remittance. ThankYou.

When trying to create migration job for method  Invent_Part_Quantity_Util_API.Move_Part and it’s not possible to save the job but you get error :Error making attribute and references - IntfaceMethodList.ILLARGTYPE:Arguement VALIDATE_HU_STRUCT_POSITION_ has illegal type. Only datatype DATE VARCHAR2 NUMBER allowed Same with Inventory_part_in_stock_API.Issue_Part_with_PostingReason seems to be that there are boolean arguments and this is not supported in data migration. Is there a way around this issue?

We use transaction based parallel currency where accounting currency is in GBP and parallel currency is in USD. Currency rates for both accounting and parallel currency are updated monthly. In this scenario, transaction and accounting currency are the same (GBP). When posting receipt of goods in Month1, Inventory is debited and GRNI is credited.  In Month2, the supplier invoice debits GRNI and credits AP, however, the GRNI amount in parallel currency is different due to a new currency rate, thus the amount in the GRNI account is not fully reversed in parallel currency.  What is the recommended solution to manage these balances when this can potentially affect thousands of transactions?  A gross month-end adjustment? There is concern this creates another set of books to reconcile every month, adding more work for the users.

Afternoon,We are looking at options around flexible working for our engineers, and need to understand the art of the possible.  Currently PSO/360 takes into account holidays and doesn’t allocate work orders in this scenario but we are wondering whether TOIL could work in the same way? Idea being that employees could accrue TOIL and then with management approval use that to work a shorter day or have a day off.We are currently on IFS Apps 8 and version 5.8.2.22 of 360/PSO.Any experience others have or suggestions would be appreciated RegardsShaun

    Server error messages:96e44bfa-30b5-4251-b4a4-1ecbad98b48fIfs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01031: insufficient privilegesFailed executing statement (ORA-01031: insufficient privilegesORA-06512: at line 21ORA-06512: at "IFSINFO.IAL_OBJECT_SLAVE_API", line 144ORA-06512: at line 1ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2993ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2997ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2151ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2195ORA-06512: at line 14)   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)   at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation,

Microsoft Report Viewer is not installed in the FSM. What is happening here, when I m clicking the report in FSM smart client, a new chrome window is opening and  it is redirecting to SSRS report server and the report is displaying in report viewer of SSRS. But the same thing is not happening with FSM web client. 

I have a custom Field in the Sales Price List part window. Now i am trying to update/insert using a Migration Job. Using usual migration job using procedure (Insert/Update from File) gives error (ORA:01003: No Statement parsed.) But i did go through the Migration data into CF but i was not able to get it done. What i understand is that First the data from the file must insert into a TABLE and then migrate into the custom field LU using (Migrate Source Data procedure.) This Excel Migration Guideline document only show EXCEL Migration method but after creating the Mig Job i am not able to execute or start it. I guess it works using Excel Add-ins. Any help would be appreciated.

Hello Guys, I hope all of you were fine. Can someone give me a tip about the error message on attached image? Happens for most of rdl files when I try to open some file. The strange is: I’m already appoiting to the the RD to correct version required on prompt:     BR

Hi All,Does anyone knows if there any limitation on number of rows we can add under DB/Client value within Custom enumeration please?I know it’s not advisable to use lengthy lists but just wondering about the limitation. Started getting below after certain rows:  ThanksDinesh

I am looking to Add a new output channel so that it goes straight to a excel spreadsheet and not in a CSV format. I am wondering if its possible to set it up so that it outputs to a .xlsx format?I have tried doing it but it wants me to click ‘csv’ , ‘xml’, ‘txt’ or HTML even once I have clicked ‘use other extension’. Anyone got any ideas on whether this is possible or not ? ThanksCameron