{"id":53,"date":"2013-03-29T09:32:34","date_gmt":"2013-03-29T17:32:34","guid":{"rendered":"http:\/\/blogs.oregonstate.edu\/bannerfis\/?p=53"},"modified":"2013-03-29T09:37:42","modified_gmt":"2013-03-29T17:37:42","slug":"wou-pcard-am-fapcard-issue","status":"publish","type":"post","link":"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/2013\/03\/29\/wou-pcard-am-fapcard-issue\/","title":{"rendered":"WOU PCard AM  FAPCARD Issue"},"content":{"rendered":"<p>WOU fapcard report gave an error on the Mar 28 run:<\/p>\n<p>ERROR: Unable to create FABINVT record. ORA-01843: not a valid month<\/p>\n<p>ERROR: Unable to create FABINVT record. ORA-01843: not a valid month<\/p>\n<p>ERROR: Unable to create FABINVT record. ORA-01843: not a valid month<\/p>\n<p>&nbsp;<\/p>\n<p>That is a date format error.\u00a0 The table fatcard&#8217;s records get deleted when there is an issue so I couldn&#8217;t tell what was trying to be inserted into fabinvt.\u00a0 I had to run the am script manually and stop before running fapcard so I could see the records in fatcard.\u00a0 Investigating the records showed the dates were fine so wasn&#8217;t an issue from the treasury file that got loaded.\u00a0 I looked at the fapcard script and suspected the problem was with the sweep_date and pmt_due_date.\u00a0 I modified it to print out those values on the fapcard.lis report and sure enough they didn&#8217;t have a proper date.<\/p>\n<p>&nbsp;<\/p>\n<p>Those 2 variables are calculated and involve settings on FTMPCSH.\u00a0 Michele discovered a accidental gap in the dates between the end of period 9 and the start of period 10 which the post date fell in.\u00a0\u00a0 We reran after she corrected the gap and everything processed correctly.<\/p>\n<p>&nbsp;<\/p>\n<p>I removed the 2 debug lines I added to fapcard to bring it back to the 5th site code<\/p>\n","protected":false},"excerpt":{"rendered":"<p>WOU fapcard report gave an error on the Mar 28 run: ERROR: Unable to create FABINVT record. ORA-01843: not a valid month ERROR: Unable to create FABINVT record. ORA-01843: not a valid month ERROR: Unable to create FABINVT record. ORA-01843: &hellip; <a href=\"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/2013\/03\/29\/wou-pcard-am-fapcard-issue\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":4838,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[161378],"tags":[],"class_list":["post-53","post","type-post","status-publish","format-standard","hentry","category-pcard"],"_links":{"self":[{"href":"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/wp-json\/wp\/v2\/posts\/53","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/wp-json\/wp\/v2\/users\/4838"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/wp-json\/wp\/v2\/comments?post=53"}],"version-history":[{"count":3,"href":"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/wp-json\/wp\/v2\/posts\/53\/revisions"}],"predecessor-version":[{"id":55,"href":"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/wp-json\/wp\/v2\/posts\/53\/revisions\/55"}],"wp:attachment":[{"href":"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/wp-json\/wp\/v2\/media?parent=53"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/wp-json\/wp\/v2\/categories?post=53"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.blogs.oregonstate.edu\/bannerfis\/wp-json\/wp\/v2\/tags?post=53"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}