PRC: Update Project Summary Amounts ends in error ORA-01400

PRC: Update Project Summary Amounts ends in error ORA-01400

On a Test instance where the issue exists please apply the steps below:

1) Backup the data:

Create table CDL_BLP as select * from pa_cost_distribution_lines_all where
project_id in (305,307);

2) Update the CDL records:

Update pa_cost_distribution_lines_all set GL_PERIOD_NAME = PA_PERIOD_NAME,
RECVR_GL_PERIOD_NAME = RECVR_PA_PERIOD_NAME
where EXPENDITURE_ITEM_ID in (118676, 118677, 118683, 118684, 118685, 118688,
118680, 118674, 118689, 118675, 118686, 118679,
118681, 118682, 118678, 118687) and GL_PERIOD_NAME is null and
RECVR_GL_PERIOD_NAME is null;

COMMIT;

3) Now run the PRC: Update Project Summary Amounts and confirm the results.

4) Migrate the solution on the appropriate environments
   
     

  • January 4, 2018 | 21 views
  • Comments