Hello,Is there a way to find out where an IAL is being used (quick report, package etc etc ….)Thanks
I have created some custom fields on the Project screen (using Apps 10 UPD17). I have added them to the Margin tab and all looks ok. However, when I go to the General tab the fields are also showing there and hiding some necessary fields, is there a way for them appearing there as well ?? Thanks
Hi all,Will the data archive objects in IFS allow objects and data to be moved to an Azure location. This option can be taken for media archiving.Thanks
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 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.
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
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
I am wanting to capture and log where the email for a PO is being sent via the Purchase Order print from RMB menu. What is the best way to do this please ?
I have created the following to attach a EDM file to an email, but I am getting this error in app messages: CURSOR get_invIs SELECT po_ref_number, invoice_id, company, invoice_no, ifsapp.purchase_order_cfp.Get_Cf$_Buyer_Name(ifsapp.purchase_order_cfp.Get_Objkey(ifsapp.man_supp_invoice_api.Get_Purchase_Order_Ref_Number(company,invoice_id))) Buyers_name, ifsapp.purchase_order_api.Get_Buyer_Code(po_ref_number) Buyers_code, dr.doc_class, dr.doc_no, dr.doc_rev, dr.doc_sheetFROM ifsapp.POSTING_PROPOSAL_INV_OVERVIEW pp Inner Join ifsapp.doc_reference_object dr On dr.Lu_Name='ManSuppInvoice' and dr.key_ref = 'COMPANY='||company||'^INVOICE_ID='||invoice_id||'^'where message_id='No Arrival' and po_ref_number='C775261';BEGIN For rec in get_inv loop ifsapp.EDM_FILE_API.REFERENCE_EXIST(f_ ,rec.doc_class, rec.doc_no, rec.doc_sheet ,rec.doc_rev ,'VIEW'); IF f_ = 'TRUE' THEN doc_type_ := 'VIEW'; ELSE doc_type_ := 'ORIGINAL'; END IF; file_name_ := i
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 ?
Hello,I have the following syntax in a procedure, but it is failing to compile with the following : Can anyone tell me what I am doing wrong please ?
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 created an event action as follows, but when I RMB and print order I get the print as expected but also get the default print. How do I stop the default one ? Thanks
I have created a the following persistent field that will be updated by an event action. Is there a way to make this field read only when viewing it on the screen. Thanks in advance.
Hello,What is the best way to capture who a PO has been emailed to. I have created a custom field to hold this information but am unsure on the best way to go about getting this info. Would I need to retrieve the print job id or result key from RMB ?Thanks in advance
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 all, Hoping someone can help with this. I am trying to schedule a quick report so the first thing I do is create the ‘Application server task’. However when I save and RMB I get the following :I select yes, then get the following:How can I resolve this issue please ?
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.
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 am wanting to schedule a quick report to run 4 days after the period end date - how is best to do this please ?
Hi,I have a field called stat_grp on the view in question but I am unable to select in column chooser - why would this be please ? select stat_grp from PURCHASE_RECEIPT_STAT_UIV
Hello - I am trying to create an IAL but it keeps failing with the following (Failed executing statement (ORA-00903: invalid table name). I can run the same code in SQL developer with no issues, can someone tell me what I am doing wrong please ?
Hello all, I am trying to do the following but keep getting the error message shown below : Any advice please ?
Hello IFS super brains,When I run the following code in PLSQL developer, I have no problems. When I try to deploy the IAL, I am getting the following error.selectro.rental_no, case when ro.RENTAL_TYPE = 'Customer Order'and ro.contract In ( 'CPH','CTM','VMS')then 'Internal' when ro.RENTAL_TYPE = 'Project'and ro.contract = 'CPH'then 'Internal' when ro.RENTAL_TYPE = 'Purchase Order'and ro.party_id Not In ( 'CPH','CTM','VMS')then 'External' end Hire_Type,NULL order_ref1 ,NULL order_ref2 , NULL order_ref3 , NULL order_ref4 , coj.order_no as Cust_order_no,coj.line_no as Cust_line_no,coj.rel_no as Cust_Rel_no,coj.line_item_no as Cust_line_item_no,DECODE(coj.CATALOG_TYPE_DB, 'INV', coj.QTY_SHIPPED, NULL) as Cust_logistics_qty,&AO..CUSTOMER_ORDER_API.Get_State(coj.order_no) as CO_STATE,ril.Location_NO,ro.contract as site,ro.part_no, '' Location, '' WAREHOUSE, ro.part_description,ro.party_id as customer_id,ro.party_name as customer_name,NULL as supplier_id, NULL as supplier_name, &AO..
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.
