Data Migration

Please any one can tell what this error mean is. ORA-20110: InventoryPartUnitCost.N-0  

Hi database gurus,I work with the data structure in IFS for more than 20 years now.The last days I came across xxx_MV tables and wonder if there is a documentation of databaseobjects and the structure of what meaning do the single part of the names have.TMP = temporary, CFT = custom field table, CFV = custom field view, _TAB at the end of most tables in the ORACLE DB is easy.LOV = list of values, ok but I’m not shure why the IFS developers sometimes use this suffix in the table name, sometimes not. When you use “base data” every thing could be a “list of values”.Especially I’m looking for a meaning for the xx_MV tables today.Thanks in advance and have a nice day.Cu in the communityMichael 

Hi All,I’m trying to import Person records and I get this error:READ ONLY GRANTS FOR IFSINFOThis was working yesterday, so I’m confused.I’m using the view PERSON_INFO_ALL.The Users have migrated for all these records and the Company User records migrated as well.Any Thoughts?Thanks, Rob

Hi Friends!I have a simple question (I guess) related to tracing…If I have a call to the Trace_Sys.Message inside a Custom Event Action. How can I see it?

Me and my colleagues are part of a project to ingest data from IFS to google cloud platform, where we collect and curate data from ifs and other systems in order to gain insights using PowerBI.We would like to access objversion each table in the client API, so that we can load data  hourly both incrementally and idempotently.But this field is not exposed in the API.One option presented to us was to add a custom field from the objversion, but this poses another problem, because custom fields are added in the CFT tabal, which mean they are not part of any index on the table. This means that each request to a table performs a full table scan, which we do not want for two reasons:   1. It is slow and sometimes times out   2. It is too much processing on the database.Another option would be to load the entire table each hour, but that won't cut it for obvious reasons.In our estimation, exposing the objversion as a field in

Hello All,I have created a migration job to export User Grants, but I can’t get the File Mappings to populate.Any thoughts? Thanks,Rob 

Hi All, I’m trying to do same data analyses about direct/indirect hours, therefore i tried accessing data which is shown in screen “Time Registration”. View TIMMAN_JOB_TRANS.I did this by the use of PL/SQL dev. I had not all te results i expected, so i viewed the time registration for another employee in IFS. After i had checked that in IFS, that employee also showed up as result in PL/SQL. So, it seems like the data is stored in the view afther i;'ve viewed it in IFS. Does anyone have an idea how to be able to see the data without opening the time registration screen for every employee one by one in IFS?Or any suggestions for another view is also welcome 😃this is the SQL query: select COMPANY_PERSON_API.Get_Internal_Display_Name(Company_id,EMP_NO),ifsapp.TIMMAN_JOB_TRANS_status.*from TIMMAN_JOB_TRANS_STATUSwhere company_id='***'and account_date= DATE'2024-01-29'and (HOURS_DAY1 >0)

Hi All,When migrating users, I get a strange result in the Description field.  Instead of the User Name, I get the contents of all the fields:I also can’t get the Web_User to populate into the User Email field 

Evening IFS Experts!I wonder if any of you can help me with a migration challenge… In IFS Apps 10 Aurena, manually adding a line to an Instant Invoice causes the “Tax Code” field to be auto populated. Our Sales Objects have no tax code on them, and so the Tax Code is taken from “Customer (page) > Address (section) > Delivery Tax Informant (tab) > Taxes (group) > Tax Code (field)”. When we migrate an Instant Invoice line, we need to replicate this function (i.e. the migration job also needs to read the Tax Code from “Customer > Address > Delivery Tax Informant”) but I’m struggling to work out how to do that. The field help for “Migration (page) > Source mapping (tab) > Default Values (field)” explains that SQL can be used and gives the following examples…substr(SOURCE_COL,1,25)decode(SOURCE_COL _1,'Y','Yes','N','No','No')Part_Catalog_API.Get_Description(SOURCE_PART_NO)

Hello All,Has anyone had success with migrating PSO users between environments?

I am trying to import a profile from one user to another new user and keep getting the error  “The file is invalid and cannot be imported .  The user profiles are saved and stored as .XML files    

Hi All,I can’t create a migration job.  What projection am I missing? Thanks,Rob

Hello All,I’m trying to migrate users between environments and I’m missing data.Why can’t I migrate the email address?If so, what do I add to the migration job.The field seems to be part of the same table, but does not get added to the migration job. Thanks,Rob

Hi, I migrated the charges to PURCHASE_CHARGE_SUPPLIER, but I received error message:“ORA-20124: PurchaseChargeSupplier.FORMAT2: Field [DISTRIBUTE_ON_RECEIPT] in Purchase Charge Supplier has an invalid value format. The value is: "FALSE".” File string : 102517;3D;CLO;1;0;1;;;102517;;;23;;;;;;;;FALSE;FALSE;0Attribute string:VENDOR_NO=102517CONTRACT=3DCHARGE_TYPE=CLOSEQ_NO=1CHARGE_AMOUNT=0CHARGED_QTY=1PRINT_PURCHASE_CHARGE=PRINT_PURCHASE_CHARGE_DB=PRINTCHARGE_BY_SUPPLIER=102517DISTRIBUTE_CHARGE_BY=DISTRIBUTE_CHARGE_BY_DB=FEE_CODE=23INTRASTAT_EXEMPT=INTRASTAT_EXEMPT_DB=FALSECHARGE=MIN_ORDER_LEVEL=MAX_ORDER_LEVEL=VALID_FROM=VALID_UNTIL=DISTRIBUTE_ON_RECEIPT=FALSEDISTRIBUTE_ON_RECEIPT_DB=FALSECHARGE_AMOUNT_INCL_TAX=0  

Hello, I currently have an event, an event action, and a workflow. The event action triggers the workflow. I want to export/import this process between environments. I am able to add the event and action to an Application Configuration Package, but I cannot add the workflow itself. This is what my ACP looks like at the moment:  And when I try to import this ACP into a new environment, I see this:  I understand that my workflow design is not imported yet, so therefore the ACP cannot import either. My question is, how do I actually export/import the workflow? I cannot find anything on the “Workflow” page for this. Mark

I'd like to wish you all a very happy new year. I'm creating migration jobs for customer orders where I'd like them to retrieve as much information as possible automatically. At the moment, I only have 3 mandatory pieces of information to enter.   I'd like the order number to be entered automatically, based on the last existing order number. Is this possible? Where do I enter it? For the example, my last order number is "S23000005957".I'd like the order number to be automatically set to "S23000005958" when I run my job, and for the countdown to take place naturally. If I manually recreate an order, my number should be "S23000005959".

Hello All!I need to update (migration task) many lines to personal files table. Which view should I choose to update all fields of the following person views together : PERS, PERSON_INFO, PERSON_INFO_ALLThank to all advices from HCM experts.

Hi guys,Anybody here has a detail procedure how to update my TEST environment using PROD environment data?I already asked this question a long time ago,  but no good answer.Our environment is IFS Cloud 23.2.5, on premises.Thanks,Gianni Neves 

I created migration job named “PURCH_REQ_MIGRATE_MNTJ”. But the user can not see this. How can I activate the migration job to the user.  Or should I confirm the permission set?  

Hello everyone,I need to create a migration job for customer orders. My customer would like a unicity check to be performed on the field CUSTOMER_PO_NO when the job is launched.  If the value already exists on IFS, the line that should be imported by the job should be blocked.   Is it possible to add this control and blocking directly to the migration job? Knowing that, the field is optional.   

We’re implementing our first FIFO site in IFS and trying to migrate the actual Received Dates for their raw material inventory.  Seems IFS wants to always set these to the import date and not the actual date value.  Anyone faced this or have a workaround?

Hello,I have the following syntax in a procedure, but it is failing to compile with the following : Can anyone tell me what I am doing wrong please ?  

Hi .. I was trying to set-up new migration job to update CUSTOMER_INFO_ADDRESS View for changes in address and postcode values. This supposed to update around 17000+ records so i choose to use Procedure “INSERT_OR_UPDATE” from csv file.As soon as i run the job i am getting below error. I did investigated further into this and noticed actual issue is - Address column value holds multiple comma seperators, which seems to be root cause of this. Is there any way i can mitigate this issue without removing extra commas from address value ? if i add double quotes around this column value, do you think this will insert double quotes also in data ?double quotes  Start time - 19-JAN-2024 11:13:18   CS_SJCB_POSTCODE_CHANGE_MIG - Execution No 0 Insert into CUSTOMER_INFO_ADDRESS_TAB failed - ORA-20111: CustomerInfo.FND_RECORD_NOT_EXIST: The Customer Info does not exist. (Error caused by line: 2)File Path: DATAMIG (F:

Hello Community!I have the following Code-- In this block we perform the actual change.DECLARE PARTTYPEERROR EXCEPTION; [SOME_OTHER_VARIABLES]BEGIN FOR sale_part_to_update_rec IN ( [SOME_SQL_TO_PERFORM_LOOP] ) LOOP p0_ := NULL; p1_ := sale_part_to_update_rec.OBJID; p2_ := sale_part_to_update_rec.OBJVERSION; client_sys.add_to_attr(name_ => 'SOURCING_OPTION', value_ => sale_part_to_update_rec.SOURCING_OPTION, attr_ => p3_); client_sys.add_to_attr(name_ => 'RULE_ID', value_ => '', attr_ => p3_); p4_ := 'DO'; BEGIN IFSAPP.SALES_PART_API.MODIFY__( p0_ , p1_ , p2_ , p3_ , p4_ ); COMMIT; EXCEPTION WHEN PARTTYPEERROR THEN [MY_ERROR_HANDLING_CODE] END; END LOOP;

How do I get to print off a Truck Spec Sheet from IFS? I used to have a shortcut saved but it got deleted.