Skip to main content

When 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?

 

 

 

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

 

 

Thank you very much! 😀 It solved the problem!.

Terms & ConditionsCookie settingsAccessibility statement