Topics started by KIMKIMANDREW
I am trying to write a two part DataMig (MS_FORECAST_FILE to load the data then MS_FORECAST_MIG to schedule the import for each part) to load data using:level_1_forecast_util_api.Schedule_Import_Forecast The first job to load the data works fine and I get an IC table ready for the 2nd DataMig job.To test the SQL code for the ATTR values to pass to the API call, I have a working PL/SQL cursor...begin for ic in (select * FROM IC_MS_FORECAST_FILE IC) loop level_1_forecast_util_api.Schedule_Import_Forecast__('CONTRACT' || CHR(31) || IC.CONTRACT || CHR(30) || 'PART_NO' || CHR(31) || IC.PART_NO || CHR(
Does anyone know what PART_COST_BUCKET_HISTORY_TAB is good for?I am considering clearing down part cost history with the ‘Keep History on Part Level’ ticked (so that bucket history is cleared) but I can’t find any reference to bucket history in the system.Can you view it anywhere?
I’m trying to check the override Ship Via Code on Customer Order lines.Because Ship Via is hidden away on a RMB you can’t check it when the order line is added so I am forced to check all lines in one go when the order is released.So I’ve created an Event on CUSTOMER_ORDER_TAB and an associated custom event action.What I am trying to do is Check all of the Order lines on the order have valid ship to codes. Report each line with an error as a Streams message to the user who released the order Stop the Order ReleaseHere’s my codedeclare attr_ varchar2(4000); cursor get_order_line_ is select catalog_no from customer_order_line where order_no = '&NEW:ORDER_NO' and sales_part_api.Get_Catalog_Group(contract, catalog_no) IN ('06J', '603G') and ship_via_code <> '700';begin for rec_ in get_order_line_ loop client_sys.Clear_Attr(attr_); client_sys.Add_To_Attr('FROM_', 'IFSAPP', attr_); client_sys.Add_To_Attr('TO_NAMES_', '&USER_ID', att
I’ve got a counter lobby element that I want to launch tbwOverviewCustomerAgreement from.The screen launches fine but it’s got a company filter on it and this is not passed to the screen from the lobby element. I can’t figure out how to pass the COMPANY from the data source.Anyone got any ideas?
Does anyone have any experience of applying a material overhead cost per batch for Shop Order/Part costs?We want to apply the cost of using an adhesive to stick components together, for different parent parts have a different adhesive and hence cost.I’ve tried using Part Specific Overheads but although I can create the cost element, I can’t get IFS to recognise it on the drop down when I try adding it.There be something basic I am doing wrong - any ideas?
I have a requirement to re-print a file generated by the PDF_CREATED event.I have all this lovely data to hand:PRINTER_ID - <Original Printer>PRINT_JOB_ID - 9999999REPORT_ID - CUSTOMER_ORDER_IVC_REPREPORT_PARAMETERS - Blah BlahREPORT_TITLE - InvoiceREPORT_TITLE_TRANS - BlahREPORT_VARIABLES - Blah Blah^RESULT_KEY - 88888888STATUS - REMOTE WORKINGLANGUAGE_CODE - blahLAYOUT_NAME - Blah Blah.rdl What I want to do is post the job back into the print manager queue using the relevant API calls and change the printer_id so that I can re-direct a copy to a 2nd Printer. Anyone have an idea of the IFS PL/SQL API’s required to do this? TIA
Has anyone ever use report rules to send output to multiple printers from one print job?(Is this even possible?)I’ve got a set of report rules to save Invoices as a PDF using IFS Connect but I also want to send a hard copy to specific printers depending upon certain data fields on the invoice.There is a logical printer, ARCHIVER, that the user selects and then I have two rules, executed in the following order:If Logical Printer is ARCHIVER and certain Site code - Print To Logical Printer HARD_COPY If Logical Printer is ARCHIVER then Route to ConnectI can see both rules firing in the Print Rule Log,Rule #1 sees an entry in the print agent log file but nothing is outputRule #2 sees a file created via IFS Connect. Any ideas?
I’m adding a Yes/No custom field to a custom table to show whether or not a row is active.I’m using the default FndYesNo enumerationSo far so normal However, the field, when displayed on a custom table page is not editable.If I view it on a custom form page it is What am I missing?
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?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.