{"id":237,"date":"2013-07-17T02:10:20","date_gmt":"2013-07-17T02:10:20","guid":{"rendered":"http:\/\/miguelontheweb.com\/wordpress\/?p=237"},"modified":"2013-07-17T02:22:03","modified_gmt":"2013-07-17T02:22:03","slug":"posting-to-a-closed-period-without-opening-the-period","status":"publish","type":"post","link":"http:\/\/miguelontheweb.com\/wordpress\/?p=237","title":{"rendered":"posting to a closed period without opening the period."},"content":{"rendered":"

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. \u00a0Working on\u00a0 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\u00a0a test enviroment and decided to run this.<\/p>\n

declare\njournalID varchar2(50) :='J0025552';\nbegin\n\nInsert 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');\nInsert 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');\ncommit;\n\ninsert \nINTO FOBAPPD\n          (\n            FOBAPPD_SEQ_CODE,\n            FOBAPPD_DOC_NUM,\n            FOBAPPD_ACTIVITY_DATE\n          )\n          VALUES\n          (\n            '20',\n            journalID ,\n            TRUNC (SYSDATE)\n          );\ncommit;\nend;<\/pre>\n
this is basically creating a journal entry and posting into period 01.\u00a0It is inserting into period “FGBJVCD”\u00a0and “FGBJVCH”\u00a0you must be careful to change the period to the desired period.\u00a0The period column is towards the end of the second line of the script.\u00a0Ultimatetly\u00a0I could have made more paremeters like period and other things
\nbut i was in a pinch\u00a0and cobble this together and it got me out of a JAM.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 ,<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-237","post","type-post","status-publish","format-standard","hentry","category-sungardbanner"],"_links":{"self":[{"href":"http:\/\/miguelontheweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/miguelontheweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/miguelontheweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/miguelontheweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/miguelontheweb.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=237"}],"version-history":[{"count":9,"href":"http:\/\/miguelontheweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/237\/revisions"}],"predecessor-version":[{"id":242,"href":"http:\/\/miguelontheweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/237\/revisions\/242"}],"wp:attachment":[{"href":"http:\/\/miguelontheweb.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miguelontheweb.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=237"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miguelontheweb.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}