Solved

I had been wondering how to insert sticky notes from an api. Sticky notes use two tables: FND_NOTE_BOOK_TAB and FND_NOTE_PAGE_TAB. There is one note book for an object that can have multiple note pages. Each page is connected to the note book via a note_id. To test this I prepared the following: A script to insert a new note book (this is when you don’t have sticky notes yet on an object) A script to insert a new note page based upon the note id as prepared in step 1. Script 1: declare   info_             varchar2(32000) := NULL;   attr_             varchar2(32000) := NULL;   objid_            fnd_note_book.objid%type;   objversion_       fnd_note_book.objversion%type;   lu_name_          fnd_note_book.lu_name%type;   key_ref_          fnd_note_book.key_ref%type; begin   lu_name_ := 'SupplierBlanket';   key_ref_ := 'BLANKET_ORDER=152^';   Client_Sys.Clear_Attr(attr_);   Client_Sys.Add_To_Attr('KEY_REF', key_ref_, attr_);   Client_Sys.Add_To_Attr('LU_NAME', 'SupplierBlanket', attr_);  

Via help I have been attempting to use the graphical structure to define positions but within that structure, a position ID is required before it can save.  What am I missing?

Hi, Is there any possibilities to do calculation automatically after leaving the text box. i have two scenario.   In same page,  there are 3 text boxes text1 , text2 , text3. After entered the value in text1, text2 then sum value should display in text3. (I can do this using trigger when they saving. But is there any options avail before saving?) Same as above criteria. But difference is, text1 is avail in different page/custom page and text2,text3 avail in different screen.    Please let me know is there any option to do like this.  Thank you

I have following SQL statement which gives me the right result:   SELECT CASE WHEN PART_NO LIKE '1%' THEN 'A' WHEN PART_NO LIKE '2%' THEN 'B' WHEN PART_NO LIKE '3%' THEN 'C' END PART_TYPE,  MAX(PART_NO) PART_NO FROM PART_CATALOG WHERE (PART_NO LIKE '1%' OR PART_NO LIKE '2%' OR PART_NO LIKE '3%') GROUP BY CASE WHEN PART_NO LIKE '1%' THEN 'A' WHEN PART_NO LIKE '2%' THEN 'B' WHEN PART_NO LIKE '3%' THEN 'C' END   How would this convert to definition of a Lobby Data Source (with view Part_Catalog) regarding Condition and Group By?

Database is IFS Apps 10 UPD 7 What do I need to do to be able to create the MWS instance and bring it up to date in relation to deliveries without affecting the database.  You advise is much appreciated.  

Does anyone know the syntax to structure custom menu options? For example if I wanted to have two custom menus reporting to Customer Order as in the below example. Shop Order… Customer Order Print Customer Invoice Manual Reservation… Inventory Part In Stock I was able to get this to work before with certain syntax in the Menu Text, but I could not find the syntax in the documentation.     The expected results would look similar to Recalculate Commission below. Where Update Calculated commissions and Update All Commissions report to Recalculate Commission as the parent.  

Could someone confirm if we can see shop order load against the “Person” please? I assume we can’t because we connect the labor class to the resource group.  I guess it will be same with production schedule and CRP calculated loads too. Tried to find a documentation to check if there are prerequisites but it was not successful.  Nav. path -Resource Management\Analysis\Resource Analysis   

Hi, Can anyone tell me why the view purchase_order_line_pub_cfv doesn’t hold the same custom fields as purchase_order_line_cfv ? And how the _PUB views are generated? BR Kresten

There is a screen called Perform Definitions under Studio menu. What is the use of that screen. Can anyone suggest me.  Any sample data relating to this will be helpful.    Thanks in advance.

Can Someone tell how we can block the default pop up which is being occurred by the customized client script(baseline client script also),if we apply that script to any screen. Like in this screenshot i have applied one client script to work order screen(Request screen).Functionality wise the script is working fine but the default pop up is coming.i just want to block that pop up.How can i do that?  

I would like to record absences that are ongoing where I do not have an end date. From what I can tell, the absence registration requires both a FROM date and a TO date. I would like the not have to enter the TO date, leaving the absence open and then reporting as such. As it were, am having to record sickness in outlook, then add to IFS once I know the absence dates. Would prefer to keep all in once place.   How do you guys record open-end sickness in IFS?   Thanks   Bruce

Can anyone please help me with how Input XML FSM business rule will work.However i know the XML business rule and how its is working.But i want to know whats the use of input XML and how it is different from normal  XML Business Rule. One sample of input XML will be very helpful.

Hi,   I’m looking for a procedure to get the shipment id from the customer order lines screen. I can’t find one in shipment_api, shipment_line_api, or anything that looks like it remotely has anything to do with shipments.   Does anyone know how I can pull this?   Thanks, Mike    

We are in APPs 8 and we would like to use document management. What are the best practices if we want to attach external files (like email, pictures…) on which we do not want to manage revisions or approvals. Is it correct to create a specific class for external documents ? It is required to put this kind of document in “released” or “approved” state ? or else, is it possible to automate the “released” state for one class of document ? Thanks for your help

Hi all, Is it possible force the users to choose the application when editing a document. The equivalent to windows “open with”?

Can anybody Recommend how to Generate Request ID Sequence based on Static Value.   Like  The Request ID is been Generated from ‘1’ but I need My request ID should start from 5000 and the counter should begin from 5000.   One Sample would be very helpful.   Thanks in Advance.    

After upgrading to UPD7 company logos and report graphics seems to have been changed to require to be in the database. There is a fallback setting in Systeminformation but is it anyone else having problems with images on operational reports?

Checking our run log, there have been minimum of 2,500 mass updates within the last minute. We have our row limit to 2,500 so no idea how many more it could be at this time.   This is all being done on my username. I have done nothing in FSM today. This was happening yesterday as well.   How can i find out what is triggering these and how to stop it? There is no information to tell me what is triggering it. They all look like this:  

Hi, I am new to FSM. Is there a reason you may want to specify locations and/or bins on a place that is categorized as a customer place? I am only aware of marking warehouses or trucks with these relations.

Hi IFS Community Members,   We are using staged billing profiles in customer order lines. Due to the size and complexity of our projects, there may be more than 20 staged billing lines per profile.   Recently a customer order line was cancelled accidentally while the staged billing profile still had both invoiced, uninvoiced and open staged billing lines. Because the cancelled order line wast the last one in the order the entire customer order changed to cancelled. Instead of creating a completely new customer order, we would like to utilize the exiting customer order and the exiting staged billing profile.   What we’d like to hear is: is there a any way to reopen a cancelled customer order/order line is it possible to prevent customer order cancellation if it has uninvoiced staged billing lines   For reference, we are using IFS 9 and update 14.   Many thanks in advance, Lauri

Can we have a sample format for REST API and ODATA, how to use them in FSM6 update 4? 

My Question is a high level question : I understand that Customer is the one who calls and asks for service so we create a request in the system . the request than has a task in it.  When do we know we need to create a RMA for the customer ,  if RMA has been created to Replace the part then who goes to collect the faulty part and deliver the replacement , basically what is happening on ground when we click on Post Shipment ,  the faulty part can be replaced by the technician but against which activity this will be tracked. If my technicians are deliverying the parts to customer then where do we track it.   

I am currently working to help my company go live with IFS 10.  In attempting to unpublish an old custom logical unit that is no longer necessary, the following error comes up during the attempt: Error occured during unpublish.ORA-20105: ProjectionConfig.PROJCONFIGINUSE: The Projection “CustomProjection[LuName]” is in use by page configurations.  Unpublish the page configuration first.   Try as I may, I cannot find where the “page configuration” is or how to unpublish it.  Any help would be greatly appreciated!  

Can somebody explain how to Release the bills on monthly basis ( last Friday of every month). in contract Bill schedule.   

Has anyone adopted the V2 flight adapter yet?