I am facing a strange problem in a pricing application. I am unable to find approve a SPA request. I checked that the data for the draft SPA and its list records is available in the ozf_offers, qp_list_headers, qp_list_lines, qp_qualifiers tables. But the approval transaction fails for some vague reasons. Can you please give me some pointers on how to go about debugging such a problem?
Assuming that this could be because of invalid request data or invalid static data within the database. So, tried to look for the validation code. But, I am unable to locate the PL/SQL procedures that performs validations - most of the code that was visible, has tons of calls to WF_Engine API's.
Any pointers on how to proceed with this would be helpful.