posting to a closed period without opening the period.

Recently i came upon a situation where a user was able to post to period 1 while there we were on period 12. This seemed odd to me however it happen and now , all eyes where on me to fix it. I did not want to ask the DBA’s to reopen an old period again and risk having to have something else sneak in there.  Working on  hunch i decided to give this a try, i scripted a journal entry that would post the journal into the period i wanted. Just like must things in Banner most edits are done at the form level , I went into a test enviroment and decided to run this.

declare
journalID varchar2(50) :='J0025552';
begin

Insert into fgbjvch (FGBJVCH_DOC_NUM,FGBJVCH_SUBMISSION_NUMBER,FGBJVCH_ACTIVITY_DATE,FGBJVCH_USER_ID,FGBJVCH_TRANS_DATE,FGBJVCH_DOC_DESCRIPTION,FGBJVCH_DOC_AMT,FGBJVCH_AUTO_JRNL_ID,FGBJVCH_REVERSAL_IND,FGBJVCH_OBUD_CODE,FGBJVCH_OBPH_CODE,FGBJVCH_BUDG_DUR_CODE,FGBJVCH_PROCESS_IND,FGBJVCH_EDIT_DEFER_IND,FGBJVCH_STATUS_IND,FGBJVCH_APPROVAL_IND,FGBJVCH_DISTRIB_AMT,FGBJVCH_NSF_ON_OFF_IND,FGBJVCH_DATA_ORIGIN,FGBJVCH_CREATE_SOURCE) values (journalID ,0,to_date('15-JUL-13','DD-MON-RR'),'MIGUEL83',to_date('15-JUL-13','DD-MON-RR'),null,0,null,null,null,null,null,null,'N','I',null,null,'Y','Banner','Banner');
Insert into fgbjvcd (FGBJVCD_DOC_NUM,FGBJVCD_SUBMISSION_NUMBER,FGBJVCD_SEQ_NUM,FGBJVCD_ACTIVITY_DATE,FGBJVCD_USER_ID,FGBJVCD_RUCL_CODE,FGBJVCD_TRANS_AMT,FGBJVCD_TRANS_DESC,FGBJVCD_DR_CR_IND,FGBJVCD_FSYR_CODE,FGBJVCD_ACCI_CODE,FGBJVCD_COAS_CODE,FGBJVCD_FUND_CODE,FGBJVCD_ORGN_CODE,FGBJVCD_ACCT_CODE,FGBJVCD_PROG_CODE,FGBJVCD_ACTV_CODE,FGBJVCD_LOCN_CODE,FGBJVCD_BANK_CODE,FGBJVCD_DOC_REF_NUM,FGBJVCD_VENDOR_PIDM,FGBJVCD_ENCB_NUM,FGBJVCD_ENCD_ITEM_NUM,FGBJVCD_ENCD_SEQ_NUM,FGBJVCD_ENCB_TYPE,FGBJVCD_BUD_DISPN,FGBJVCD_BUD_ID,FGBJVCD_CMT_TYPE,FGBJVCD_CMT_PCT,FGBJVCD_DEP_NUM,FGBJVCD_ENCB_ACTION_IND,FGBJVCD_PRJD_CODE,FGBJVCD_ACCT_CODE_CASH,FGBJVCD_DIST_PCT,FGBJVCD_POSTING_PERIOD,FGBJVCD_BUDGET_PERIOD,FGBJVCD_ACCRUAL_IND,FGBJVCD_STATUS_IND,FGBJVCD_ABAL_OVERRIDE,FGBJVCD_POST_BAVL,FGBJVCD_APPR_IND,FGBJVCD_CURR_CODE,FGBJVCD_CONVERTED_AMT,FGBJVCD_FUND_CODE_POOL,FGBJVCD_COAS_CODE_POOL,FGBJVCD_GIFT_DATE,FGBJVCD_EMC_UNITS,FGBJVCD_DATA_ORIGIN,FGBJVCD_CREATE_SOURCE) values (journalID,0,1,to_date('15-JUL-13','DD-MON-RR'),'MIGUEL83','APFX',4624.50,'this should have posted to per 13','-','13','360883','T','360883','08110','7200','02',null,null,'2',null,null,null,null,null,null,null,null,null,null,null,null,null,'1012',null,'01',null,null,'E','N',null,null,null,null,null,null,null,null,'Banner','Banner');
commit;

insert 
INTO FOBAPPD
          (
            FOBAPPD_SEQ_CODE,
            FOBAPPD_DOC_NUM,
            FOBAPPD_ACTIVITY_DATE
          )
          VALUES
          (
            '20',
            journalID ,
            TRUNC (SYSDATE)
          );
commit;
end;

this is basically creating a journal entry and posting into period 01. It is inserting into period “FGBJVCD” and “FGBJVCH” you must be careful to change the period to the desired period. The period column is towards the end of the second line of the script. Ultimatetly I could have made more paremeters like period and other things
but i was in a pinch and cobble this together and it got me out of a JAM.

Leave a Reply

Your email address will not be published. Required fields are marked *