Hi allI’m trying to run an anonymous block from an event - however, I want to trigger to be weekly, not when a record is inserted/update.My method is to create a simple Static IAL, which I schedule to run weekly. Then I created an event to trigger on IAL_OBJECT_TAB on update when RowVersion is changed - also tried other updated fields. The event action is set to run if the name of the IAL is that created above is updated. If the action is a simple email output, it runs once each time I update the IAL (Update Now button in IAL configuration). As soon as I introduce an Execute Online SQL action, it seems to run twice as I get double the output (my SQL reads records in Project data - which includes the Project Manager, in a for Loop, then sends out details to each PM individually within the For LOOP).Any thoughts? Is this a known issue? (this is APPS9) Yes, I know I could create a Package, but as it is hosted, we are reliant on IFS all the time - I want more freedom to develop this. Grate
Hello IFSers This is an Apps9 problem. I have an event & event action to create a Man Supp Invoice. I’m struggling with the Posting Proposal (PP). The debug tool doesn’t seem to reference it at all!I’ve had to guess and have created the Invoice and PP header thus:ifsapp.MAN_SUPP_INVOICE_API.NEW__(v_info,v_objid,v_objversion,attr_,'DO');ifsapp.MAN_SUPP_INVOICE_ITEM_API.NEW__(v_info,v_objid,v_objversion,attr_,'DO');ifsapp.Posting_Proposal_Head_API.New__(v_info,v_objid,v_objversion,attr_,'DO'); ..but this last step errors:ifsapp.Posting_Prop_Inv_Item_UTIL_API.New__(v_info,v_objid,v_objversion,attr_,'DO'); with : This is how I build attr_: Client_SYS.Clear_Attr(Attr_); -- Client_SYS.Add_To_Attr('COMPANY' , v_company , Attr_); Client_SYS.Add_To_Attr('PARTY_TYPE' , 'Supplier' , Attr_); Client_SYS.Add_To_Attr('IDENTITY' , 'AP0000' , Attr_); Client_SYS.Add_To_Attr('INVOICE_ID
APPS9We have been advised that XLR_REPORT_RESULT_TAB is consuming a large amount of disk space on our database.It looks like this is added to when a BA report is scheduled or manually run.How can we flush out/delete records from this table? We can see records going back to 2020 which we don’t need. Thanks
We don’t seem to be able to get System Info from IFS (APPS 9) or use the Debug tool, when in Admin-type screens - for instance Solution Manager > Security > Users > Create UserIs there a way to “switch this on”? It works in other screens. As a by-product of this, does anyone know which table the Base Profile and Personal Profile is held? Thanks in advance
In Apps9, (and going forward with our upgrades) would be good to conditionally alert users when emails from IFS advise if they are from our TEST database. Coming from PROD should be the norm and therefore nothing needed to alert the user. Just adding DB_SID would not work, as users would ignore it - as it would be present for both PROD and TST. Ideally something like: if #DB_SID# like ‘%TST’ then ‘ This message generated from TEST’ Else NULL and add this to Subject line. Thanks
We have just had our hosted DEV database refreshed (cloned) from PRD. APPS9 Does anyone have a comprehensive list of activities to be performed post-refresh? For instance, stopping & changing Scheduled tasks. Does anyone have any clever ideas on how to automate any of this (for instance diverting/rebranding emails when NOT sent from PRD to be clear these are not LIVE messages). Thanks in advance.
I have exported an Event & Event Action form APPS9 DEV environment, I now want to Import. How do I do this? I have a .INS file created for each (Event and Event Action). Thanks
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.