The customer name is available but it does not pick it when new order line is created. i need to find any dependency which will not return the customer name but i am not able to find anything yet.
@lydwre Base Price are linked to Sales Price Group. Which are linked to the Price List. Each part will have a base price under a price list and the price list will be linked to the Customer Price Group, Then the base price will be picked in the Customer Order line.
Have you tried generating a TAB delimited text file instead of a Comma separated file. I had same problem with customer addresses and it was fixed with TAB delimited source file then change column separator too.
Hi @FPayab the query looks good. Did you put the columns in the lobby element? It is a Timeout issue. I used IALs to make it efficient.
Hi @Link No I don’t have any screenshot. My problem is about the time of loading data from source on my element.(Lobby Element Time out) Hi Armaghan,I have same issue, the data loading times out in the element in the lobby. Did you find any fix?
I am using superuser.The DataSource displays the max 40 records, but it does not show in the element
This is still unclear case. But I have got some hints it could be related with Load balancer , and it’s parameters. Hi all, Was any fix found for this? We are also facing the same issue on APP 9.
Hi, I have customer who is into an Upgrade project from IFS Apps 8 to IFS Cloud. How do we manage the Data Migration of the existing data into IFS Cloud? For Example: We migrate the Inventory Parts, Inventory Stock etc. How about the LotBatchMaster, LotBatch History or Part Serial History windows? Does this needs to be migrated as a part of the Upgrade project? Hi Manjunath, How did you migrate Inventory part in Stock with different statuses? e.g. reserved stock, issued Stock etc
If they are out of sync to start, you will need to do a migration job to update each of them. Three separate migration jobs is probably quicker and easier than trying to do it all in one. If trying to do initial setup and want them to be synchronized, there is a tick box on the Description tab of each part that indicates that the Master Part Description should be used on all display views. It is also a good idea then to remove the permissions from the secondary part views to prevent most users from being to update the descriptions at all. The descriptions are out of sync, Can i use an expression to pick Master Part description in the migration job to update the value.
@ShawnBerk Thanks for the info. I thought the same and i was wondering if there is a automatic functionality for it.
Thanks to @Charith Epitawatta and @Technical Outlaws for the help.
When you publish a custom field you are merely generating the database objects i.e. custom field table, view & package. You need to make the custom field available to the users by modifying the layout of the screen, typically this is done against a base profile and rolled out to the relevant users. Yes i have modified the layout of the screen using the SuperUser but how do i roll it out to all users?
Hi,i am facing something similar in IFSAPP9, i have checked the route order for bin, bay and tier and nothing is null. Server error messages:c8b6e065-0b26-4aa8-b8e2-750b5f2a1003Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01400: cannot insert NULL into ("IFSAPP"."INVENTORY_PART_AVAIL_STOCK_TMP"."BIN_ROUTE_ORDER")Null value not allowed. (ORA-01400: cannot insert NULL into ("IFSAPP"."INVENTORY_PART_AVAIL_STOCK_TMP"."BIN_ROUTE_ORDER")ORA-06512: at line 13) at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions) at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions) at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody) at Ifs
If ‘0’ dollars is the limit, the order will credit block every time. You can leave the limit blank if you want no credit hold. Hi Cperdue,When i set the Credit limit to Blank, and when recalculate the Customer Credit Analysis, it will set the Used/remaining credit to “Not Defined”. Is this standard functionality?
Hi @FPayab if I remember in App9 is the same process like in App10. That's what i thought but is there a documentation for this?
Hi, just to clarify, the default location is used to facilitate the receipt handling of a part when registering the arrival and not the reservation process. I believe in APPS 9 the basic principle is FIFO with the added priority of expiration date where these are defined i.e. earliest expiration date, any durability days/rules defined per part / customer, and where these are not used then standard reservation will be based on FIFO. As mentioned above there are some additional controls in later versions to handle reservations, but I think based on the above the only option you have is to ensure that all other locations than the one you want to be able to reserve from are set with an Availability control where auto reservation is set to ‘not allowed’ therefore forcing the system to only use the location(s) with no controls. This could become a maintenance nightmare unless you have some logic/process to stock being replenished in the location stock should be reserved from. I think in App
I don’t think that it is explained well, it is somewhat random based on the most recent transaction for that part in that site. Other than keeping all of the inventory always in one location and only reserving from that location, I don’t think there are any controls to restrict the reservation in V9. There are some additional controls in V10, but not based on location. If you have locations that you want to restrict from providing a part reservation, you have to use Availability Controls to block auto-reservation from those locations. I have tried the availability controls on both location and inventory part in stock. The system auto reserves the ones with the nearest expiration date. And even if the expiration dates match for all locations it still doesn't auto reserve using the location with set availability control. Am i missing something?
After revoking Is_Report_available, this only removes the “Reprint Original from Archive” option.How do i restrict “Reprint Modified” and “Reprint Original Duplicate” ?
You may be able to disable the RMB options for a specific user by removing the access for those RMB options from the permission set assigned to the user. I have the following options in RMB, i want to restrict users from using these Options. Are there db objects or components which i disable in Permission sets?
Here is a sample Quick Report query that asks for a wildcard-able User ID parameter (case-insensitive), and accounts for the user not entering anything (grabs everything in that case): SELECT HLA.New_Value AS "User ID", MAX(TO_DATE(HLA.ObjVersion, 'YYYYMMDDHHMISS')) AS "Last Login" FROM History_Log_Attribute HLA INNER JOIN History_Log HL ON (HLA.Log_Id = HL.Log_Id) AND (HL.LU_Name = 'FndClientLogon') WHERE (HLA.Column_Name = 'DIRECTORY_ID') AND UPPER(HLA.New_Value) LIKE UPPER(NVL('&UserID', '%')) GROUP BY HLA.New_Value Works great! This makes sure you are only looking at History data for the FndClientLogon LU history, and only going after the DIRECTORY_ID field. Appears to run fairly quickly even though History_Log_Attribute is a bit sparse on indexes… You can modify the above to join to FND_USER, or just use as-is to see all logins. Not sure if you want to see active users who have not recently logged in. Let me know if this helps or if you have questions!
Hi Gents,Did any of you came up with a solution for this. Would appreciate if shared.
Found the problem. There was a functional Role which was causing the permission object rights.
@Randini Jayasundara Yes i have refreshed the cache.
How do i access Conditional Formatting? is it available in IFS 9
i want to check for the format of the Mobile number i-e length and number of entry , for example if a user inserts an invalid mobile number or more than one mobile number. Same for Email ID if a user inserts an email id with @ or inserts more than one email id. i want to restrict user to single valid mobile no and email id.
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.
