HI
Im creating a job in app9 to read in a purchase order through migration job, which calls many methods.
What every method is surposed to do is:
-Create a part & supplier for Purchase part via assortment if Part does not exists on the site
-Create purchase order header
-Create Custom tab “retail info”
-Read in data in CF in retail info
-Create line(s) in Extension table “box lines” on Po
-Read in data to a Cf on box lines tab on PO
-Create multiple charges (per line)
-add a history logging
the only method that is not working is method 32 RETWHO_PO_BOXES_CFP.Cf_New__
I get an issue when trying to insert data into the CF on RETWHO_PO_BOXES stating:
ORA-01400: cannot insert NULL into ("IFSAPP"."RETWHO_PO_BOXES_CFT"."ROWKEY")
when i compare the CFV insert for the “Retail info” tab Vs the Box ID Tab, they have the same input in the method attribute lists…
Retail info CFV method attributes:
Box lines CFV method attributes:
(i use OBJID@30 due to the method 30 is reading in one line per line in the input file, thus giving it different OBJID than the PO itself).
in the method list, im stating that the field “DUMMY_NET_PRICE” must have value for the method to be executed, and in the source mapping, i give the DUMMY_NET_PRICE a value from the input file, so that should be ok. (this is the same way that i did for the CF on the retail info tab)
Other on the source mapping, it looks like this:
The CFV looks like this
and the CFT looks like this (the “C box price curr” is the only persistent Cf in that view, hence the small amount of records)
does anyone know how i can do to get around the error: ORA-01400: cannot insert NULL into ("IFSAPP"."RETWHO_PO_BOXES_CFT"."ROWKEY")? i thought the two methods for the CF’s would work exactly the same, but it does not look like it can handle the find a value for the ROWKEY?
appreciate all kinds of input!
br, viktor