Solved

Hello - looking for any Oracle database experts out there….We use a database backup tool named Unitrends to backup our instance of IFS.  The tool basically leverages RMAN to backup Oracle using the ARC archive files created.  We are having an issue when trying to run the process, has anyone ever seen the following error? We are using Windows Server 2012 R2 as our database server:I am struggling to understand how to grant a Windows user account DBA privileges?  Any ideas on this?Many thanks!!

This seems like it should be easy but I cannot figure it out.  I want to create a custom event for the purchase_order_line_tab using  the execute online sql action.  The goal is when a PO line is entered, use the value from one field, use that in a function to return a value and insert that value into another field for the same PO line.  For a test I can just hard code the value for now.  If I was just creating a trigger I would do something like below.  Any suggestion on what I need to do to get this to work. declare  a_ varchar2(20);begin  a_ := 'Test Result';  :NEW.part_revision := a_;end; ThanksPhil

Hi Everyone, I was wondering if anyone could guide me this, I wan to print customer order confirmation when an order is released I also want it to be printed to a specific printer  Thank you in advance 

Can someone educate me of the hierarchy where the Price on the PO line is fetched? Say, when we have an active Supplier Agreement, a Blanket PO, Supplier for Purchase Part record, etc. Not sure what are the other price fetching windows are, but let’s say all are active.  Also if you have an F1 Documentation link to explain further about the above hierarchy, please send that too. Thanks. 

Could someone kindly assist me with the below questions of a customer. They have been in APPS7,5 before and now are in APPS9.“ #1 Does Apps9 German Central Bank Reporting replace the German Localization GDPdU?(Please be explicit of all delimitations, and advise whether or not German Localization GDPdU exists for the Apps9 Track).#2 Where do I find instructions in the Online Documentation to configure and execute the IFS Connect Outbound Routing Rules German Z4 Proposal and German Z5 Proposal?(German Localization GDPdU output 3 files of type DAT, XML and DTD) ”

Hi all, We have a requirement from our client where we need to control fields visibility based on Request Type. Using client script we can easily do this, our problem is that some fields appear on two different tabs (for the same request type it should be visible on TAB A but not on TAB B).  Do you know if it is possible to control the visibility on a specific tab? Or if there is any event we can use to trigger the script (we tried the GotFocus event, but nothing happened)? We also tried to use the name to register property of the field at UI Designer, but it seems the setcontrolvisibility function only accepts the “real” DB field name on the DB… Thanks in advance,João Oliveira

How to create a user with unlimited password expiry?     I want to create a user ,whose password should not be expired.    

We are currently outputting to CSV from the manual supplier invoices screen.The invoices often have documents attached.I would like the output CSV to contain a hyperlink to the attachment so user can select the link and open a click 2 run session to see the attachment.Is that possible? If so.. how?

 I am trying to connect an IAL definition to a Data Source Designer Element, but when I click the preview button I get an “SQL command not properly ended”.  Here is a screen shot of my IAL Object Developer, below that is a screen shot of my report designer and below that is a screen shot of the error I am getting.IAL Object DeveloperData Source Designer 

Hi, I've got a question with regard to IFS Aurena. In the time registration UI, in the side bar of the list of employees, the employee's name is not visible on each list item. However, an icon is visible denoting the initials of the employee. Is the is the default behaviour? How can I make the names visible? I also noticed the same behaviour in other UIs such as expenses to manage. That's why I'm uncertain if I have set up the system correctly. Can you give some hints to fix this?

Help please, We bring in the field VENDOR_NO on the DEMAND_LINES, SCHEDULE LINES,However when I look at the incoming customer schedule I can not see this field or the data. Does anyone know where is kept? I am asking as we need to put this detail on our out going ASN message.Thanks in advance for your help, Sarah

We have a customer in Germany that requires .xml reporting for invoices.  We tried using a .rdl report from IFS to generate the .xml successfully.  However, the report shows our Parent US company name on it and not our subsidiary from Europe.  Even though the invoice is for the other Company (FR200)in IFS.  How do we update/fix the .rdl to have the Europe company name on the report instead of US? 

Hello,We are using IFS 7.5, I know it’s a little old.  Anyways, I have a couple questions. Sometimes I need to enter/voucher invoices without a PO so I enter everything manually such as the account and cost center.  I have noticed that sometimes when we pass the plan pay date the payment does not go out.  It kind of seems like it gets stuck in the middle between me vouchering an invoice and payment being made.  Can anyone answer why this happens?  When I pull up the entry and I want to cancel the entry and re-enter it I get an error saying that the “invoice is used in payment order” which leads to my second question.   Is there an option on the payments side that can push the invoice payments through.  As of right now the only way I can try and fix this is by someone on the payments side going into the system and searching for the supplier ID that didn’t pay out and cancel the payment.  Then on the invoice entry side I can cancel the invoice and re-enter it and hope that payment goes

Have made changes to a data source, then the applicable element, cleared server cache and lobby cache (URL) with no luck.I know I must be missing something simple, but I do not know what it is. Sincerely,VK

What step of the Supplier Agreement flow that we enter a Project ID? In the planned state or after in the Agreement, IFS won’t let me enter a Project ID either from the LOV or manually. I was wondering if a Supplier Agreement can be used for a Project based purchase at all? The business requirement is, the project needs to release a PO through an active agreement.   

Hi, we would like to be able to enter time cards on behalf of other employees.We know already how to do it if we are in the same project team. But how to do the same if we are NOT in the same project team? We systematically get this error message: “You are not allowed to enter Project Time/Cost Reporting for this Employee of company XXX.I guess there could be a way via Access Attribute, but i can’t figure out what should be changed to grant this right.Thanks to help if you have any clue ...

When trying to refresh 3 data mart sources either individually or together  we receive the following message:Error while refreshing Data Mart Source (CONSOL_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expiredError while refreshing Data Mart Source (CONSOL_PER_DET_BAL_MVT) - resource busy and acquire with NOWAIT specified or timeout expiredError while refreshing Data Mart Source (CONSOL_PERIOD_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expired At the time of refreshing I was the only one logged int. Regards John

Hi,Is it possible to convert normal table row to a table header in Report Designer? Or move existing table to Repeating Header section?Thank you. 

For some reason Search with Keywords does not functioning in APP10 Customer database. Is there any specific setup? 

From Document Class Management > Persons and Groups user NETKLK is enabled to create documents from doc class : PO-S1.But not from doc class PO-S2. Therefore when searching for document class when creating a new document revision with criteria PO-% user will get only the doc class PO-S1.But when user is trying to attach a document he/she will get document revisions created from doc class PO-S2 as well. It is also possible to attach a created documents from doc class PO-S2 . How to restrict attaching documents from document classes that user does to have permission to create new revisions?Thanks In Advance

What is the max size limit for uploading attachments to transactions in IFS10 / Aurena?E.g. Purchase Orders, Requisitions, Projects, Work Orders etc Thank you, 

Hi  Attached is an example of unexpected results in apb.Shop order 903 is the parent shop order 1000 Disc and spindle is the child wanted for operation 10 of 903Both parts are finiteResult from APB puts shop order 903 finish date ahead 1000, This is a physical impossibilityWhat do we need to do to make sure the parent SO uses the child part for its planning?Thanks

Hi, We have installed IFS7.5SP6 on a machine with OS win2008R2. The connect and batch services are coming done with below error in the log:=============================================================================2020-09-24 12:44:22,152 1 ERROR [Integration] StaServer.__AW_init(): Fatal error!ifs.fnd.ifw.sta.UnauthorizedAccessException: POST error #401: Unauthorized accessat ifs.fnd.tc.http.HTTPClient.__AW_doPost(HTTPClient.java:420)at ifs.fnd.tc.http.HTTPClient.doPost(HTTPClient.java)at ifs.fnd.tc.http.HTTPClient.__AW_post(HTTPClient.java:240)at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java)at ifs.fnd.connectserver.setup.ParameterList.fetchConfig(ParameterList.java:179)at ifs.fnd.connectserver.setup.ParameterList.<init>(ParameterList.java:101)at ifs.fnd.connectserver.setup.ConnectorLoader.<init>(ConnectorLoader.java:128)at ifs.fnd.connectserver.ConnectorServer.initializeServer(ConnectorServer.java:79)at ifs.fnd.ifw.sta.StaServer.__AW_init(StaServer.java:83)at ifs.fnd.

Can anyone help me with what transaction triggers the Posting Controls of GP22 - GP25?  I can’t get these transactions created in the application.  What process creates these?

Hi, I want to use the Information Sources Supplier/Customer Open Balance, but Business Reporter is not showing data when I run the report. I tried adding various data items, but not one is showing data. Has anyone else experienced this problem and/or knows what the issue is and how to solve it?  Kind regards,Simon