+1When I try to create and Approve a new Read Only Custom Field Attribute on the
PurchaseReqLine PURCHASE_REQ_LINE_ALL view I get the error message “The column PART_NO refered to in table t is not approved persistent Custom Attribute” .
Argument:
v.part_no
Select Statement:
select PART_MAIN_GROUP from ifsapp.PART_CATALOG where PART_NO = :PART_NO
Can someone help me?
Best answer by SimonTestard
Part_No isn’t a column that exists in the base view for PurchaseReq Line, so you can’t use that.
I’d do it like that, where the parameters are requisition_no, line_no, release_no:
select
part_catalog_api.get_part_main_group(purchase_req_line_part_api.get_part_no(:requisition_no, :line_no, :release_no))
from dual
Part_No isn’t a column that exists in the base view for PurchaseReq Line, so you can’t use that.
I’d do it like that, where the parameters are requisition_no, line_no, release_no:
select
part_catalog_api.get_part_main_group(purchase_req_line_part_api.get_part_no(:requisition_no, :line_no, :release_no))
from dual
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.