GL post无法成功

现象:

   在过帐时,提示App-Sqlgl-08046: The batch you selected is either not postable, already selected for posting, or being posted.

   在post form界面batch status显示:funds check or reservation in process;

 

检查:

   1>SOB上有开启budget功能;

 

   2>没有定义预算及预算组织;

 

   3>Fund check level均为none;

 

   4>检查gl_je_batches(BUDGETARY_CONTROL_STATUS为I,表示In process)

 

 

    5>检查gl_bc_packets(STATUS为P,此处表示pending)

 

 

措施:

  严格意义上讲,这个预算功能根本没有被启用.此处的问题给人感觉有点莫名其妙.  在无招的情况下,咱就来个datafix;

 

1>

update gl_bc_packets

 set status_code='S'

where je_batch_id=12709;

 

2>

update gl_je_batches

  set BUDGETARY_CONTROL_STATUS='P'

where je_batch_id=12709;

 

3>Commit;

 

4>重新在POST FORM下过帐,一切OK.