PO approval workflow is failing with the error --Failed Activit: Get PO Attributes -- Error Stack : Wf_Engine_Util.Function_Call(PO_POAPPROVAL_INIT1.GET_PO_ATTRIBUTES, POAPPRV, 562566-638453, 265219, RUN)

Issue:    PO approval workflow is failing with the error

Failed Activity		Get PO Attributes
Activity Type		Function
Error Name		-6512
Error Message		ORA-06512: at line
Error Stack		Wf_Engine_Util.Function_Call(PO_POAPPROVAL_INIT1.GET_PO_ATTRIBUTES, POAPPRV, 562566-638453, 265219, RUN)

Solution: There might be multiple reasons. Below would be one of the issues.

The PO distribution line id is having quantity ordered ‘0’ and it is causing the issue.

I found one Metalink id Purchase Agreement Fails Under GET_PO_ATTRIBUTES Activity (Doc ID 460332.1)

After performing the below data fix. It resolved my issue.

Delete from po_distributions_all

where po_header_id = '562566'

and po_line_id=565160

and req_distribution_id=219153

Disable Self Service Personalization

Issue Description

Is there any way we could ignore all self service personalization. We want to test a scenario where we want that system should work as per standard options and effect of all personalization should be ignored?

Login to System Admin Responsibility and click on system function following the navigation mentioned in figure below

Following Screen Appears

Such option should be set at user level.

Select check box of User and enter the User Name and in the profile field enter the profile option name Disable Self-Service Personal and click on find button

As a result, following screen will appear. This profile is ‘No‘ at site level by default. Set the value ‘Yes‘ as shown below

Save it and clear global cache. You can get the steps to clear global cache from here.

As soon as cache is cleared, warning message will start appearing on the login page. Find the screen shot below to see the message appearing on login screen.

This message will appear on all self service pages in the application.

You should change this profile option again to No once your investigation is completed.