The background job Generate Authority for User has just started failing - can anyone help me identify what the issue is please ? ORA-04098: trigger 'IFSAPP.LOG_DATAFILE_CREATION' is invalid and failed re-validationORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5588ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5580ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5405ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 2652ORA-06512: at "IFSAPP.DATABASE_SYS", line 2252ORA-06512: at "IFSAPP.DATABASE_SYS", line 5012ORA-06512: at "IFSAPP.DATABASE_SYS", line 4511ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3917ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3922ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3705ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3785ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 2523ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 2537ORA-06512: at line 1ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1831ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 278 ORA-06
When I create the persistent field as a date format I am not given the option to add a default value, is there a reason for this ?
Hello,I have some warranties setup on serial objects, the valid until date has passed but the status is still active. How do I get this to auto update to closed when the date has passed ?
Hello all, I have just started using the IFS Cloud data migration tool, I am struggling to find out to set a concatenation rule on a column in the input container. I have tried doing as it suggests but the results are not correct. Hoping someone can advise.
I am trying to run a migratin job to update the contacts on a business opportunity -I keep getting the error message: ORA-20110: BusinessObjectContact.CUSTADDRNOTEXIST: Customer address does not exist. Please enter a valid customer address.I have set a default of 1 for all contacts but it just does not like it. If I update the opportunity manually that is the value that gets populated.Does anyone have an idea what I am doing wrong ?
Hi, I have created a survey and added users as participants. When I navigate to My Surveys in Aurena the survey is not displayed. Can anyone advise why this would be please.
Hi,I set the Shrink log segments job to run last night @04.30. When I check it has errored because of the following: What is the best way to resolve this please ?
Hi, I am trying to create a custom event to write a history record when a contract is created However, when the record is created it only shows1. -281041 not the digits in frontAlso, I am not able to get the status from the variables ROWSTATE - the event does not like it. What else can I use to record the status.Thanks
Hello all, When I try to export to excel my report I am getting the following error - what does this mean please ?
I have created the following quick report, but get this error when I try to run it. select part_no, ifsapp.Inventory_Part_API.Get_Description(CONTRACT,PART_NO) part_description, Contract, Case When Contract like Nvl(Upper('&Site'),'%') Then 'Y' Else 'N'End Rqdfrom ifsapp.Inventory_Partwhere contract Not In ('CPH','CTM','VMS','CGP') --and part_no='WMPI10067'and Nvl(Substr(ifsapp.Inventory_Part_API.Get_Accounting_Group(contract,part_no),1,2),'Y') Not In ('IS','PH')), PartsInStock As (Select part_no, Sum( Case When contract like Nvl(Upper('&Site'),'%') and Substr(warehouse,1,4) like Nvl(Upper('&Warehouse'),'%') Then ipis.qty_onhand Else 0 End ) End_Qty, Sum( Case When contract like Nvl(Upper('&Site'),'%') and Substr(warehouse,1,4) like Nvl(Upper('&Warehouse'),'%') Then ipis.UNIT_COST * Nvl(ipis.QTY_ONHAND,0) Else 0 End ) End_ValueFrom ifsapp.Inventory_part_in_stock_uiv ipiswhere contract Not In ('CPH','CTM','VMS','CGP') and Nvl(Substr(ifsapp.Inventory_Part_API.Get_Ac
I have a scheduled report task set up as follows: One of the jobs fails every week with the following error message: I cannot find the print job number it mentions, any clues please ?
I have written a procedure to finish work orders, however if there is an error when calling the api to close I want it to log the problem but continue with the rest of orders. How do I complete this in the code please ?Sample code:objversion_ varchar2(200); wo_objid_ varchar2(200); wo_objversion_ varchar2(200); null_ varchar2(32000) := NULL; error_message_ varchar2(2000); t_ date; CURSOR Cur Is Select wt.state, wt.objid, wt.objversion, wt.task_seq, wo.objid as wo_objid_, wo.objversion as wo_objversion_, wo.wo_no from ifsapp.ACTIVE_SEPARATE_UIV wo inner join ifsapp.JT_TASK_UIV wt On wo.wo_no = wt.wo_no where wo.mch_code='MATERIALS' and trunc(wo.reg_date) <= Trunc(sysdate)-30; BEGIN FOR cur_chief in cur loop If cur_chief.state In ('Released','New') Then Transaction_SYS.Log_Status_Info('Work Order: '||cur_chief.wo_no|| ' has been finished.' , 'INFO'); IFSAPP.JT_TASK_API.START_WORK__( null_ , cur_chief.objid , cur_chief.objversion , null_ , 'DO'
Hello - I am new to IFS and am after some help with the following. I would like to create an event that when a user creates a new supplier or customer record that IFS should alert the User to input the customer ID/Supplier ID if they have not already done so instead of allocating the customer/supplier a system generated number
I am using the following code in an event but the deferred job is erroring:DeclareAttr_ Varchar2(32000);Sql_Msg_ Varchar2(32000);Block_ Varchar2(32000);TRANSLATION_TEXT_ varchar2(2000);BeginBlock_ :='Declareinfo_ varchar2(200) := null;title_ varchar2(50);Beginselect title into title_ from doc_issue_reference where doc_no=''&NEW:DOC_NO'';If title_ = ''Delivery Note No'' ThenBegin ifsapp.doc_issue_api.New_Revision2__(''&NEW:DOC_CLASS'',''&NEW:DOC_NO'',''&NEW:DOC_SHEET'',''2'',''&NEW:DOC_SHEET'',''TEST'',1,1,1,''DELI''); End;Endif ;End ;';--Transaction_Sys.Is_Session_Deferred; Sql_Msg_ := Message_Sys.Construct('UPDATECOLINE');Message_Sys.Add_Attribute(Sql_Msg_, 'SQL', Block_); Client_Sys.Clear_Attr(Attr_);Client_Sys.Add_To_Attr('SQL_DATA_', Sql_Msg_, Attr_);Client_Sys.Add_To_Attr('MSG_', '', Attr_); Transaction_Sys.Deferred_Call('Fnd_Event_Action_API.Action_Executeonlinesql','PARAMETER',Attr_,Language_Sys.Translate_Constant('Event', 'Delivery Note Revision', Null,
I am trying to update CUST_ORDER_TEMPLATE_LINE but am getting the error message ORA-20121: CustOrderTemplateLine.INSERT: Field [LINE_NO] in Cust Order Template Line may not be specified for new objects. How do I rectify this please ? I have also removed the field from the update but it is not creating any new records just updating the records.
I have a report rule that checks in a document but the system does not allow for the format column to be updated - what is the best way to do this please ?
The background job Generate Authority for User has started failing with the following, can anyone help me identify what the actual issue is please ?ORA-04098: trigger 'IFSAPP.LOG_DATAFILE_CREATION' is invalid and failed re-validationORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5588ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5580ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5405ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 2652ORA-06512: at "IFSAPP.DATABASE_SYS", line 2252ORA-06512: at "IFSAPP.DATABASE_SYS", line 5012ORA-06512: at "IFSAPP.DATABASE_SYS", line 4511ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3917ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3922ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3705ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3785ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 2523ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 2537ORA-06512: at line 1ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1831ORA-06512: at "IFSAPP.TRANSACTION_SY
Hello all,I am wanting to capture when the revision status is changed, I have created the following event but it is not being fired, can someone point me in the right direction.
Hello,Is there a way to find out where an IAL is being used (quick report, package etc etc ….)Thanks
Since moving to Apps 10 from Apps 8 this feature does not seem to work. When you try to generate the document the following error is givenIfs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) at System.Activator.CreateInstanc
Hello all, Is it possible to have a RMB that takes the values from my search criteria.The following search displays 5 invoices. I then would like to RMB and write some code to email the required info. I have the code written to email the info but it only emails the details for the invoice that is currently active not all of them. Is this at all possible ?
Hello,I am trying to pass the following search criteria to a custom menu but the results is only giving me 1 record not the 5 as expected.Search screenMy custom menu is as follows :select msi.Identity , msi.Invoice_no, dr.doc_class, dr.doc_no, dr.doc_rev, dr.doc_sheet, edm.file_data, edm.doc_type from ifsapp.Man_Supp_Invoice msi Left Outer Join ifsapp.doc_reference_object dr On dr.Lu_Name='ManSuppInvoice' and dr.key_ref = 'COMPANY='||company||'^INVOICE_ID='||invoice_id||'^' Inner join ifsapp.edm_file_storage edm On edm.DOC_CLASS= dr.doc_class and edm.DOC_NO = dr.doc_no and edm.dOC_SHEET=dr.doc_sheet and edm.DOC_REV=dr.doc_revwhere msi.identity= Nvl(:i_hWndFrame.frmManualSupplierInvoice_Ext.cmbsIdentity ,'%')and invoice_date >= to_date(:i_hWndFrame.frmManualSupplierInvoice_Ext.dfdInvoiceDate , 'DD/MM/YYYY')and invoice_no = Nvl(:i_hWndFrame.frmManualSupplierInvoice_Ext.dfsInvoiceNo ,'%')and project_id = Nvl(:i_hWndFrame.frmManualSupplierInvoice_Ext.dfsProjectId ,'%') ; Can anyo
Already have an account? Login
No account yet? Create an account
Enter your 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.
