Author Archives: wendlerb

About wendlerb

I didn't drown.

Engineering Proposal

Code     Desc 333      Pre-Chemical Engineering 303     Chemical Engineering   336       Pre-Civil Engineering 306      Civil Engineering   337       Pre-Computer Engineering 308      Computer Engineering   342      Pre-Engineering Physics 312      Engineering Physics   345      Pre-General Engineering 827      General Engineering   351      Pre-Mechanical … Continue reading

Posted in Uncategorized | Leave a comment

SFRENRL

NC students are showing withdrawn from university in certain terms in time status.  Investigating this showed the message was coming from a combimation of shrlgpa and shrtmst.  NC courses give 0 hours earned and 0 hours attempted

Posted in Uncategorized | Leave a comment

Indirect cost encumbrance

Temp table that posting uses is fgtidce

Posted in Uncategorized | Leave a comment

Tracking down reason why no approval queue

You need rule class to get the rule group on the record. FTVRGRC is xwalk table. You need document type number on record which you can get from forappl.lis Look in table FORAQRC which has doc type and rule group

Posted in Uncategorized | Leave a comment

Payroll encumbrance feed

Got a call from SOU wanting to know why an encumbrance jv was stuck at Incomplete and wouldn’t post.  The was no seqno marked as an error in FGAJVCD so I had them complete it and then ran approvals.  No … Continue reading

Posted in Uncategorized | Leave a comment

Finance 8.10 Upgrade Notes

FGRTRNI modified with 2 new parameters.  Feed scripts have to be modified to reflect the new parameters.  There is seed data that can be added to ftvsdat to bypass whatever choice is selected for the two parameters but you still … Continue reading

Posted in Uncategorized | Leave a comment

FPPPOBCA Issue

WOU’s process to close POs failed leaving them unable to post the affected POs I had to : delete fpreoca where fpreoca_code like ‘%0002xxx’; delete fpbeocd where fpbeocd_code like ‘%0002xxx’; delete fpreocd where fpreocd_code like ‘%0002xxx’; Then they were able … Continue reading

Posted in Uncategorized | Leave a comment

Bypassing approvals for problem Z docs

Insert record into fobappd Delete record from fobuapp update fabinvh to set approval ind to Y run posting

Posted in Uncategorized | Leave a comment

AP Check Issue

FABCHKA was giving the error: ORA-01400: cannot insert NULL into (“FIMSMGR”.”FOBAPPD”.”FOBAPPD_DOC_NUM”) WRN-ORACERR: Error occurred in file “fabchka.pc” at line 1,040 WRN-ERRSTMT: Following statement was last statement parsed: insert into fobappd (fobappd_seq_code,fobappd_doc_num,fobappd_bank_num fabchka terminated with error. I wrote some print statements … Continue reading

Posted in ACH | Leave a comment

Payroll check

Got a call that shared services could not print two checks running pwpchkp. Check print ind on table pwrchck for the two doc codes which I got from table pwrcnpb.  Print ind was set to Y so they had to … Continue reading

Posted in Uncategorized | Leave a comment