Hi, If I want to change a customer order line I use this function: Customer_Order_Line_API.Modify__() Some times I need to do it it in a background job. Then I would create a new procedure that executes Customer_Order_Line_API.Modify__() and then start that new procedure with Transaction_SYS.Deferred_Call() from an event. Is there any way to perform this directly without the custom procedure? Best regards Kresten
Are we able to add specific dates as Holidays to a calendar?Our use would be quick reports that would use the work_time_calendar_api.Get_Work_Minutes API.
Hello,Working with events, I’m trying to get the value of a date type attribute and the result is a number, instead of a date.I’ve tried for different date type attributes and with different logical units and tables, and the result is always the same.For example:Logical Unit: ExpenseHeaderTable: Expense_Header_tabAttribute: CONFIRM_DATEWhen the event is executed, I get “1994” as a result, but it should be “16/10/2020”. Does anyone know how to resolve?.Thanks in advance,Amaia
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,
IFS 8 SP1 Page: Purchase Order Receipt Category: Advanced Search Function - SQL Hi all, This is my first post on these forums, so please guide me if I’m posting at the wrong area. Lets say I’m search all deliveries received in >2020. This is thousands of results. Is there a way to get a list with UNIQUE PART_NO values, where only the first delivery (ACTUAL_DELIVERY_DATE) of the unique part numbers are listed? I’ve tried: ARRIVAL_DATE > to_date( '20200101000000', 'YYYYMMDDHH24:MI:SS' ) and UNIQUE (PART_NO) Based on: https://www.w3schools.com/sql/sql_unique.asp
Is there an oracle/ifs api or function that I can invoke to get the client facing error message that I see in IFS when there is a soft error? For example when the user tries to report on a shop order operation that is closed, the IFS client will show an error message that states “Operation is closed. Not allowed to modify qty complete.” However when I call that function through PLSQL I will get the entire stack trace, such as: ORA-20110: ShopOrderOperation.OPERCLOSED2: Operation is closed. Not allowed to modify qty complete. ORA-06512: at "IFSAPP.ERROR_SYS", line 1017 ORA-06512: at "IFSAPP.ERROR_SYS", line 92 ORA-06512: at "IFSAPP.SHOP_ORDER_OPERATION_API", line 11735 ORA-06512: at "IFSAPP.SHOP_ORDER_OPERATION_API", line 12283 ORA-06512: at "IFSAPP.SHOP_ORDER_OPERATION_API", line 10169 ORA-06512: at "IFSAPP.SHOP_ORDER_OPERATION_API", line 10190 ORA-06512: at "IFSAPP.SHOP_ORDER_OPERATION_API", line 10213 ORA-06512: at line 1 Since the ORA- will be different dependin
Hi, We have often background jobs failing due to locking.There are a lot of “Please try again later” messages.“The update could not be performed since the Document Revision record is currently locked. Please retry the operation. ORA-20113: DocIssue.FND_LOCKED”. How can we find more about this? We could click on “Show Details”, which lets us know which document was involved. Would like to know why it was locked. Was it simply because someone was looking on that document? Thanks in advance! Regards,KW
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
Can someone please tell me how can I enable this media attachment option in another window?Example: This is now available in NCR window. I want make it visible in PO window. Where will these media files be saved in the application? Is it in the same DocMan repository or somewhere else? Thanks in advanceNimesh
Hi there,I’m trying to get inter site trading working where the sites that trade are in 2 different companies. I can raise and send a Purchase Order from the demand site to the Internal Supplier, this successfully creates a message in the Connectivity Outbox, however, it does not generate an Incoming Customer Order on the receiving site and there is no Connectivity Inbox message generated. I’ve got inter site trading working successfully where the sites are within the same company but not across multiple companies Any ideas? Thanks!
I would like to a quick report on the 12th of the month for the prior month. So on April 12th it will run for the month of March. On May 12th it will run for the month of Apr and so on. This report is also run manually by the users. Is there a way to dynamically set the From/To date to be the prior month or do I have to create copy of this report with the dates dynamically set in the select statement? I obviously don’t want two exact reports because of having to remember to make all changes twice. Below is the a screen shot of the server task schedule.
Hi, Does anyone know how to use the IFS Rest API’s to query for the document text associated with a Customer Order Line? Based on the debug console it looks like I need to use the DocumentTextHandling.svc API. But whenever I try to call it using the following: DocumentTextHandling.svc/NoteTexts(Objkey='{OBJECTKEY}') I get the following response from IFS: { "error": { "code": "ODP_RESOURCE_NOTFOUND", "message": "Resource not found." }} Does anyone now how to use the DocumentTextHandling.svc API? Thanks
I’ve started a project and ca new omponent recently using Dev Studio 10.82.6231.10191024. Project internals were generated with a _create_project_root.cmd script.Now the Build Home folder says an index is 11 days old, but some of original component’s entities have changed but I can’t refer to those dynamically. Clear and Refresh does not update components, but gives NRE : java.lang.NullPointerException at ifs.dev.nb.project.ui.explorer.BuildHomeNodeIx$OpenBuildHomeFolderAction.enable(BuildHomeNodeIx.java:635) at org.openide.util.actions.NodeAction$DelegateAction.resultChanged(NodeAction.java:615) at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.openide.util.WeakListenerImpl$ProxyListener.invoke(WeakListenerImpl.java:487) at com.sun.proxy.$Proxy4.resultChanged(Unknown Source)[catch] at org.openide.util.loo
Hello all,I am trying to save my lobby data source but i have and error when I hit the save button like “Please enter a one view name” But I can preview my query and it works fine.What i need to to is just save may data source but i can’t.Any hep would be appreciated.
When we are creating a generic event action and event action for a particular user to send an e-mail with a PDF report, is there any rule on what event will be triggered first? Does the system prioritize the event action which has “user” over the generic event action?
Apps 7.5 had a cool enhancement to Operational Reporting called ‘iPrinting’ which was a UK customisation. It allowed additional data to be pulled into a report layout which could then be used by Report Designer. This feature appeared to disappear by the time Apps 9 came along and I wondered whether anyone has come across this? Custom Fields offer some assistance but what they do not provide is ‘sub queries’ of data. e.g. Customer Invoices lines report the Lot/Batch Number of the invoice qty but I want to then show a break down of that quantity across the batches. This would require a sub-query of the inventory transaction history or something to show the separate lot ref and qty. I used to be able to do this using iPrinting but I can’t see way to do it with custom fields. Anyone got any ideas?
Hi All,I want to post a background job via a custom event action as app owner (needs to perform event action as a different user) without using impersonate user.’Fnd_Session_API.Impersonate_Fnd_User(‘IFSAPP’)’Does anyone know any other option in APPS 10?Thanks!
We are seeing many sessions of IFS left Active even after the individual has logged out of IFS (we had sessions that were active for over 2 weeks and had restarted the environment at least once during this window). I know what is causing this and we are working on the user community to exit appropriately (selecting the Menu when done) but I’m trying to figure out is there a configuration/setup/utility that we need to have to clear out these old sessions? I can create a process to remove them in the background, but trying to determine if there is a function that we should configure in IFS and not use a brute force deleting process.
Working in earlier with IFS Developer Studio using Marble, I do remember that I could get hints and guidance when writing code. For example, if a added an attribute to projection entity, I could easily see (by a tool tip or something alike) which settings/preferences I could use for that object. Like a reference documentation in the editor.Is this still possbile to switch on? What do I miss in my setup?/Fredrik
Hi, Im trying to give a non HR person access to training records without exposing the rest so went about creating an IAL for it with live data and then granted permission to the IAL against the users permission set. However when the user runs the quick report it only returns the data that the user has access to i.e under his position access.Previously i have done this and it has worked fine. The only thing i can think of at the moment is that because it it looking at live data and not copied/scheduled then IFS is still checking the position/data access of the user.The IAL is a union on these two views;ifsapp.pers_license_emp_profile_Ovifsapp.emp_training_history_ov Any ideas?
Is there any place we can find corresponding values attached for PDF_PARAMETER_1 - PDF_PARAMETER_10 in system event PDF_REPORT_CREATED for each report?Purchase order we currently interested in. Need to know what exactly the default values it passes when user print the report PURCHASE_ORDER_PRINT_REP.
Is there any way to use dynamic component dependency if the component I am depending on is customized component and it is not installed.If the dependent component is customized and not installed then there would not be any component_<modulename>_sys package.In this case what needs to be done?
I have a question about formatting on IFS lobby.I want to add a conditional formatting that when the Balance value is higher than the budget value it has to be red color. But how can I indicate this in the formatting tab? I am not very familiar with the formatting section.
hi All, I am getting below message when previewing a Lobby element I created.The data source was created using a Quick Information Source view.How do I get this to work? Is there any limitations to use QIS view as a Data source? Thanks!
Refer to following “Quick Report” query which is taking 10+ minutes or even timing out on some occasions. Any ideas on increasing performance of this SQL query? SELECT DISTINCT sp.activeind, sp.catalog_desc, sp.catalog_no, sp.cf$_last_modified, sp.contract, sp.gtin_no, sp.List_price, sp.List_price_incl_tax, sp.sales_price_group_id, sp.sales_unit_meas, spc.cf$_last_modified AS char_lastmodified, spl.last_updated AS SalesPrice_LastUpdated FROM Sales_part_cfv sp LEFT JOIN Sales_Part_Characteristic_cfv spc ON sp.contract = spc.contract AND sp.catalog_no = spc.catalog_no LEFT JOIN SALES_PRICE_LIST_PART_PRICE spl ON sp.catalog_no = spl.catalog_no WHERE sp.contract = '201' AND (sp.cf$_last_modified >= '&datestring' OR spc.cf$_last_modified >= '&datestring' OR spl.last_updated >= TO_DATE('&datestring2', 'yyyy-MM-dd'))
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.
