Solved

12992 Topics

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Hi folks,Wondering if anyone can help with an api grant issue i‘m stuck with? Created few procedures within a package on test db, one named as drop_table_ as below (meant for deleting a temporary table content, not dropping as name suggest )Create or replace package body CB_SALES_QUOTATION_API is procedure drop_table_ IS Begin EXECUTE IMMEDIATE 'DELETE FROM ifsapp.CB_NOTE_TEXT_TAB where CF$_NOTE_TEXT is not null'; end drop_table_;Executing this package via Custom menu rmb which works well with IFSAPP schema .But when i tried executing as a end user i get below message: So far:Granted Package access to the user: Grant execute on ifsapp.CB_SALES_QUOTATION_API to XXX; Also, Grant execute on ifsapp.CB_SALES_QUOTATION_API to PUBLIC;Granted table access to the user: Grant all on ifsapp.CB_NOTE_TEXT_TAB to XXX; Re-logged in as user but still getting above error message on IFS.Strangely, when i use PLSQL dev,logged in as same user i can execute the api and als

13326

5 years ago

graeme86Do Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

FSM 5.7.6 FSM Connect working with Attachments

I was wondering if someone could give me some information on how a inbound integration should be formated to handle attachments. I would like to send a Image file from another system and attach it to the task. Thanks, Graeme

1831

5 years ago

Andreas_MDo Gooder (Customer)

asked in Finance (Financials)

How to adjust file name in ISO 20022 file?

We are using ISO 20022 in file payments, The file name created is very long and strange, so we want to change that logic. How do you do that? ISO20022 is XML files and the file type have no file template or outgoing file template.

5297

5 years ago

jbernardoHero (Partner)

asked in Finance (Financials)

billing currency in voucher detail

The voucher detail currency always populates to the billing currency of the entire request. however, each NPU & PU have billing currency's on them individually. if we were to bill 1 NPU line to a USD bill to and the remainder to a CAD bill to, it will ignore those and only put what is under the request itself, not the specific line items. is there a way to adjust the voucher detail to take the currency from the line itself rather than the entire request?

1022

5 years ago

IFSmattisSidekick

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

custom menu using more than 4000 characters

Hi All,any experience of using a custom menu (PL/SQL-block) for more than 4000 characters?Perhaps there is someone around having some tipps and tricks to extend this limitation. Thanks a lot!Mattis

4843

5 years ago

ctaylor56Hero (Partner)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Remote Warehouse Address on PO

I have created a remote warehouse and on my remote warehouse I’ve setup the address to be that of one of my supplier’s address ID. I created my supplier assortment with parts and refill parameters. I run the refill parts and I get my expected Purchase Requisition. I convert that to a PO and I see the Internal Destination ID and my Register Arrival has the default location of my Remote Warehouse, but on my PO I don’t have the delivery address of my remote warehouse. Am I missing something here? What’s the point of setting the address on the remote warehouse and it cannot automatically show on my delivery address for my replenishment order?

7025

5 years ago

DevBobSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Understanding SQL Date Formatting for QuickReports, IALs, and SQL Query Tool

We’re getting run-time errors due to date logic/formatting/selections. Is there any standardized set of date formatting rules?I have numerous Oracle SQL websites detailing date functions, but we run into issues every now and then, with each case having slightly different requirements/logic.Scenarios:1.) SQL in an IAL runs fine in the quick report using it, but fails when run in the SQL Query Tool.2.) A quick report runs fine (and also runs fine with RMB Output>Save As...) but if you take Export to Excel it fails.For instance, our latest situation is this error when running an IAL’s logic from the SQL Query Tool that doesn’t occur when running a quick report over the same IAL: IAL logic:selectsoi.sub_program_id as PGM,cois.district_code as Class,omi.commission_receiver as Receiver,max(cin2.name) as Receiver_Name,max(cia.name) as Receiver_Company,omi.customer_id as Dealer,max(cin.name) as Dealer_Name,max(cois.country_code) || ' - ' || max(cia.state) as CN_ST,sum(CASE WHEN trunc(cois.i

10642

5 years ago

RutJWhalenSuperhero (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

HTTP server certificate expires in 9 days

IFS Apps 10 - Test Environment When running install of delivery update the following message appeared: HTTP server certificate expires in 9 days How do I rectify this issue?

3922

5 years ago

0guzHero (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

What Is The Prerequirements For Automatically GTIN Generate

Hello,I want to use automatic gtin generate approach on the IFS V10.8.I created a record on gtin basic data like below. I created a record on company basic data gtin prefix like below. Then i checked a catalog part for generate gtin but the option is not active.What should i do more, can somebody tell me prerequirements about automatically gtin generating.Thanks. Company/Distrubition/General

3431

5 years ago

rkurfmanSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Add Document - Document Text Administration

Is there a way in Apps 8 to add Documents to the Document Text Administration?I am looking for Instant Invoice and Interest Invoice, but do not see them in the list, so was not sure if they could be added.

77711

5 years ago

jdowneyDo Gooder (Customer)

asked in Finance (Financials)

ACH payments to suppliers

Does anyone have information they can share on setting up ACH payments to suppliers? I think I have the basic setup completed, but I’m not able to actually create a payment that shows the invoices are paid. Any help would be greatly appreciated.

6914

5 years ago

RutJWhalenSuperhero (Partner)

asked in HCM (Human Capital Management, Payroll)

Time Clock error

Apps 10. When user swiped they card on Time Clock machine they received the following message: Insufficient access rights. You cannot modify Absence Registration data for employee 62905. Any ideas?

6365

5 years ago

snarayananDo Gooder (Partner)

asked in Service (Touch Apps, MWO, MRO)

Bill Period Type in Invoice Templates

Hi, Can anyone help me understand the bill period type in invoice templates? I can see the information in the contract code tables but there is no documentation which explains what does the fields period factor & period type mean?

961

5 years ago

rkurfmanSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Report Rule for different Company - Report Layout

I am trying to create a Report Rule for Customer Order Confirmation, etc. to specify a default Report Layout for each Company, as they each have their own layout. Goal is when a User goes to print a document that the Layout designated for that Company affiliation will be what appears as the Layout. I have not been able to get this to work with Order Confirmation or Pro Forma Invoice from the Customer Order screen.

9449

5 years ago

TDCSOURABHSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Mobile Sync Rule - Initial Query

The below XML gives an error EXCEPTION Message: String was not recognized as a valid DateTime. ... Stack Trace: at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.PerformReplicationForTableAndPerson(String tableNameIn, String personIdIn, Boolean truncateTableIn, String deviceSequenceIn, SQLiteCommand sqliteCommandIn, mm_process_defRow syncRuleIn, Dictionary`2 tableColumnsDictionaryIn) at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.PerformInitializeMobileDevice(String personId, String deviceSequence, String message, SQLiteConnection theSQLiteDB, Dictionary`2 theSyncRuleTableColumnsDictionary) <hierarchy_select return_only_requested_attrs="true" max_rows='50000'> <primary_table>PERSON_CAL_EXCEPT</primary_table> <from> <table>PERSON_CAL_EXCEPT</table> </from> <attrs> <attr>PERSON_CAL_EXCEPT.*</attr> </attrs> <where> <data_constrain

2441

5 years ago

cjohnsonSuperhero (Customer)

asked in Products (Manufacturing, Products, Engineering)

Multi-Site Product Structure display issue

Hello, I have noticed an issue when using the Multi-Site Part Structure Analysis module in IFS Apps 10. The analysis does not show the full BOM in some cases. Specifically, it stop when when we hit an Inventory Part with a Part Type of Purchased (Purchased Part with a Product Structure). Unfortunately, this paints an incomplete picture when we view a Part using this analysis. Is there another location in IFS where you can view the full structure of a Multi-Site part, or is there a configuration setting that must be enabled to view the structure of a Purchase Part in this screen? Any help would be greatly appreciated. Thank you!

2011

5 years ago

hhy38Superhero (Customer)

asked in Distribution (CRM, Commerce)

How to Disable Column Chooser on Permission set?

Hi,We would like disable column chooser for users, but I could not find right permission. We will hide some price columns from user. If you know better way, you can suggest to hide price datas from user.

8934

5 years ago

HOOJEWINLSidekick (Customer)

asked in Products (Manufacturing, Products, Engineering)

grant IAL to IFSSYS

Can you tell me how we can grant a custom made IAL to user IFSSYS?We find in the documentation the following text. Own views need to be granted to user IFSPRINT and IFSSYS We are able to grant the custom made IAL’s to IFSPRINT (via IFS application – Security – Permission Sets) but we don’t see the IFSSYS user here.Maybe we have to this in PL/SQL ?

8225

5 years ago

LahiruDSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Information Source Dimension DIM_ACCOUNT_BI

Hi Community, Have you experience a situation where DIM_ACCOUNT_BI Access View in Business Reporter has multiple records for same Account and Company. Thanks

1791

5 years ago

ManishGDo Gooder

asked in Finance (Financials)

Print Payment Advice

I want to Print Payment Advice form IFS using Order Report but in Order report, there is an option to enter Order ID I don't Know what Order ID system required.

11898

5 years ago

tjhendrikseDo Gooder (Customer)

asked in Service (Touch Apps, MWO, MRO)

How do you cancel a Customer order generated by a Work Order in IFS 10

We used the metering invoicing functionality to generate invoices for customers. The process creates a Work Order, a Work Task and then generates a customer order which we could invoice off of. Unfortunately, I need to cancel some of the customer orders but cannot because they were generated from a work order. Does anyone know the process for cancelling out the work order?

5416

5 years ago

jbernardoHero (Partner)

asked in Service (Touch Apps, MWO, MRO)

PSO is overlapping calls

It seems PSO is scheduling 2 calls on top of one another when the duration and plan start times show that they cant be that close Here is the PSO ScreenPSO screenshotThe first task that was assigned was done so at 4:30PM On 8/6/20 to start on 8/7/20 @ 8:05AM. 120 Min duration At 5AM on 8/7/20 it assigned another call to the same user for 7:30AM. Even though duration is 123 minutes, PSO expects the user to complete the newly assigned task and drive to the next task within 30 mins? This has happened a few times to different users. Not all users are advising if this has happened. Any insight is apprecaited

1695

5 years ago

jbernardoHero (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

FSM Alert Business Rule - More than 1 alert

Hello, Currently we have an alert set for when a part need is entered, the alert will display the part alternatives for that original part.However, if there are 3 part alternatives, it will only show 1 Below is the business rule, how can i modify it in order to perform this?

1735

5 years ago

cjohnsonSuperhero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Changelog

Hello all, I’m curious to know if anyone has found a published changelog with details of what has been added/removed from IFS between updates? The log that comes with the notification contains a very general list of items moved to Aurena, etc. but there isn’t anything beyond that. I find that after we apply an update, there are a litany of items that have been added, some of which turn out to be very beneficial to our company. The issue is because there is no detailed log of what was updated/rolled out, we have no way of knowing unless we stumble upon it by accident. Thank you!

6959

5 years ago

jbernardoHero (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

PSO / FSM - Assign Based on Work Status

In FSM, mobile users have an "On shift" & "Off shift" option. This is located under PERSON.WORK_STATUS.Is it possible to have PSO schedule a tech only when they're ON SHIFT and when they are OFF SHIFT it does not consider them for work?Thanks in advance,

3116

5 years ago

Page 492 / 520

Solved

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded