Has Anyone Played with Custom Fields in an Aurena Native App?


Userlevel 4
Badge +11

So typically whenever I have implemented mWo, I always get the question about creating No Part Purchase Requisition Lines from Mobile.  And I always say it is not supported.  

What I have always implemented is creating generic Purchase Parts (NONSTOCK and SERVICES) and I create a custom field on the Work Order Purchase Requisition Line Called “mWo Part Description” which would allow the tech to properly describe what it is they actually want so they backoffice would know what to truly buy.

In the Apps10, what I have noticed is that the Part Requisition Line for a Work Task is now a completely different LU then the one in mobile.  So I have done the following:

Created a Persistent Text Custom Field in the WorkOrderRequisLine LU

Added it to the entity WorkOrderRequisLine

Published it.

 

Then went over to Aurena and added it to the new requisition step in the Aurena Page Designer

 

Then Reinitialized in mWo Service 10 and I see my new custom field.

But since the IEE Work Task Part Purchase Requisition Line uses a different LU, I create another custom field on the PartWoRequisLine LU which is read-only and using a SQL expression to read my custom field value from WORK_ORDER_REQUIS_LINE_CFV

In Mobile I create the new purchase requisition, use of my generic purchase parts and add a value to the custom field and click finish.

 

Upon writing back to IFS from mobile I get the following failed Transaction:

Null value not allowed. (ORA-01400: cannot insert NULL into ("IFSAPP"."WORK_ORDER_REQUIS_LINE_CFT"."ROWKEY")
ORA-06512: at "IFSAPP.CUSTOM_OBJECT_RUNTIME_SYS", line 175
ORA-06512: at "IFSAPP.WORK_ORDER_REQUIS_LINE_CFP", line 205
ORA-06512: at "IFSAPP.WORK_ORDER_REQUIS_LINE_CFP", line 385
ORA-06512: at line 1
ORA-06512: at "IFSAPP.CUSTOM_OBJECT_RUNTIME_SYS", line 171
ORA-06512: at "IFSAPP.CUSTOM_OBJECT_RUNTIME_SYS", line 179
ORA-06512: at "IFSAPP.CUSTOM_OBJECT_RUNTIME_SYS", line 84
ORA-06512: at "IFSAPP.CUSTOM_OBJECT_RUNTIME_SYS", line 96
ORA-06512: at "IFSAPP.CUSTOM_OBJECT_PROXY_SYS", line 427
ORA-06512: at "IFSAPP.CUSTOM_OBJECT_PROXY_SYS", line 435
ORA-06512: at "IFSAPP.SERVICE_ENG_APP_SVC", line 34552
ORA-06512: at "IFSAPP.SERVICE_ENG_APP_SVC", line 34565
ORA-06512: at line 2)

 

Why is the CFP trying to write a NULL to Rowkey?

If I unpublish and unapproved my custom field in IEE (PartWoRequisLine LU) and delete the failed transaction, I see the created mobile purchase part requisition line in IEE (minus the value from my custom field)

 

Any thoughts?  How is everyone else handling No Part Purchases from Mobile now in Apps 10?

 

 


4 replies

Userlevel 7

I’m seeing the same thing. I’d recommend logging a support case for this.

Userlevel 1
Badge +2

Possible reason for this behavior could be an overridden Crud_Create, by passing the super call where custom fields are handled.  Report this to mWO team.

Userlevel 4
Badge +11

IFS RnD has identified this as a bug in the core application and working on a fix as of Aug. 13, 2020

I will let all of you know as soon as I know the release date.

Userlevel 4
Badge +11

BUG ID was 155204

Reply