Error Running Encumbrance Datafix Script - "ORA-20023: Projects details are invalid on this PO PA_EXP_TASK_EFF"

(Doc ID 2378560.1)

Last updated on MAY 03, 2018

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


Users are running the datafix script to fix po header 1159081 (po number 60486) "Enc_amt_fix_single_doc.sql" and an error occurs

enc_amt_fix_one_doc(p_user_name => '&user_name',
                                   p_responsibility_name => '&resp_name',
                                   p_header_id => &p_header_id,
                                   p_accounting_date => TO_DATE('&p_accounting_date' , 'DD-MON-YYYY'),
                                   p_enable_logs => 'N');


Error:
-------
Number of rows deleted 0
Checking for invalid budget account details
Checking for invalid project details
BEGIN
*
ERROR at line 1:
ORA-20023: Projects details are invalid on this PO PA_EXP_TASK_EFF
ORA-06512: at "APPS.ENC_AMT_FIX_ONE_DOC", line 936
ORA-06512: at line 2


Steps to Reproduce the Issue
-----------------------------------

1. Login to SQL
2. Run the following

SQL> exec mo_global.set_policy_context('S', &org_id);

Enter value for org_id: 83

PL/SQL procedure successfully completed.

SQL>



SQL> BEGIN
enc_amt_fix_one_doc(p_user_name => '&user_name',
p_responsibility_name => '&resp_name',
p_header_id => &p_header_id,
p_accounting_date => TO_DATE('&p_accounting_date' , 'DD-MON-YYYY'),
p_enable_logs => 'N');



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms