Best Of
Re: Advisor Webcast - PeopleSoft 1099 Update for 2021 Get your Copy B’s out on time! on 30th Nov 2021
Chat Questions/Answers from the Advisor Webcast
Q: Are there any plans to include 1042 reporting?
A: No, 1042 Reporting will not be supported. The following are the supported IRS 1099 forms:
1099-MISC (Miscellaneous Information)
1099-NEC (Non-employee Compensation)
1099-INT (Interest Income)
1099-G (Government Payments)
-------------
Q: Just confirming there will be no changes to the Post Withholding AP_WTHD process?
A: Correct, Post Withholding was not changed in the 1099 Update for 2021
-------------
Q: Will Box 6 Taxable Grants on form 1099-G have the amount threshold enforced?
A: Yes, as long as the Min Amt to Rpt box on the Withholding Entity is populated for Type = 1099G, Class 06, the threshold amount should be enforced.
-------------
Q: Clarification on Box 6 1099-G questions. Minimum is $600 per IRS instructions but 1099 G is reporting all amounts. Royalty is reported for less than $600
A: If Form 1099-G is reporting Box 6 regardless of the Min Amt to Rpt, please create a Service Request with Oracle Support to look into this issue further.
-------------
Suggestion: Now that the current Financials PUM images are on Tools 8.59 and have the new Automated PRP Download feature in the Update Manager, you may want to consider adding some slides to these kind of presentations showing how the PRP can be applied to the PUM image with that new functionality instead of the old manual download and apply steps. The Automated PRP stuff is fantastic! So much easier.
A: Will consider this suggestion for next year's 1099 presentation
-------------
Q: Should I just search on Oracle support to find Image 41 in order to apply it to our native OS or virtual box?
A: Suggest to display Patch 33421289 in My Oracle Support. Under the Prerequisite Patches, will show PEOPLESOFT FSCM UPDATE IMAGE 9.2.041. Click on the appropriate line to display Image 41
-------------
Q: Is there any update scripts along with this patch, just like last year.
A: No, there are no update scripts that came with the patch this year.
-------------
Q: Can you explain each 1099 PS jobs from process scheduler? There are many 1099 jobs there, I found it is confusion.
A: The 1099 Job (AP_1099) consists of the following processes:
1099 Report Post (1099_RPT_PST) -- This process will take data from the PS_WTHD_TRXN_TBL and populate the PS_WTHD_1099_TBL
1099 Report (AP_APY1099) -- This process will take data from the PS_WTHD_1099_TBL and populate the PS_WTHD_1099_COPYB and PS_WTHD_TO_SND_DTL. This process will also generate the IRS Tax file.
1099 Copy B Sort (AP_COPYB_RPT) -- This process prepares the data in order to generate the 1099 Copy B's
Withhold Reports for 1099M, 1099N, 1099I, and 1099G created using BI Publisher -- Prints the 1099 Copy B's for 1099M, 1099N, 1099I, and 1099G
-- The 1099 Post, Report, & CopyB Sor (RPT_1099) consists of the following processes:
1099 Report Post (1099_RPT_PST)
1099 Report (AP_APY1099)
1099 Copy B Sort (AP_COPYB_RPT)
-- The Print 1099 Copy B (APCOPYB) consists of the following processes:
1099 Copy B Sort (AP_COPYB_RPT)
Withhold Reports for 1099M, 1099N, 1099I, and 1099G created using BI Publisher
-------------
Q: Do we require to do set up changes in PeopleSoft 9.2?
A: No setup changes are required. However, if you did not transition to the 1099-NEC changes that were added in 2020, you will need to manually change the Withholding setup, which include the new Withholding Types 1099-M and 1099-N. Instructions were provided in Bug 31114646 -- AP: NEW 2020 IRS REQUIREMENTS FOR REPORTING 1099-NEC/MISC, to help with these manual changes. In addition, your 1099 Suppliers, Vouchers, and Withholding Transactions will need to be updated. See Doc ID 2725427.1 -- EAP WTHD20: Are Generic Scripts Available to Update the Suppliers, Vouchers and Withholding Transactions With the New 1099 2020 Changes?, for further information. The sample scripts are to be used as a guideline and at your own risk and discretion.
If you need to report Box 11 for a Supplier, please see Doc ID 2826213.1 -- EAP WTHD21: What is Required to Populate Box 11 (Fish Purchased for Resale) on Form 1099-MISC Copy B?
-------------
Q: If the NEC setup is not done to suppliers and withholding records, users won’t be able to create reports? what specifically changed to suppliers
A: Correct, if the Withholding setup, Suppliers, Vouchers, and Withholding Transactions were not changed to include the new Withholding Types 1099-M and 1099-N, the 1099 information will not be reported correctly to the IRS or your Suppliers. See Doc ID 2725427.1 -- EAP WTHD20: Are Generic Scripts Available to Update the Suppliers, Vouchers and Withholding Transactions With the New 1099 2020 Changes?, for further information.
-------------
Q: What are steps to generate prior year 1099 form like for 2019, 2016. After changing fiscal year to 2019 do I run withholding jobs again and Copy B? Previously crystal reports was used how will 1099M be generated?
A: If need to generate Corrections for Fiscal Year 2019 or prior, will still need to run the 1099 processes in order to generate the Corrections. Should run the 1099 Job to generate the Corrected IRS Tax File and Corrected 1099 Copy B's. Crystals Reports are not supported in Release 9.2 or 9.1 when generating the 1099 Copy B’s. BI Publisher is used to create the 1099 Copy B's for 1099M, 1099N, 1099I and 1099G.
-------------
Q: How do we verify that withholding was run for the prior year?
A: Check the PS_WTHD_SENT_DTL table and verify that data exists for FISCAL_YEAR = 2020 for your various Suppliers.
-------------
Q: Is there a way to get notified when a new patch/fix becomes available for 1099s after the original Patch? Instead of constantly checking the website.
A: No, there is no way to get notified when a new patch/fix becomes available for 1099's after the original 1099 Update for 2021. Suggest to add Doc ID 2812159.1 -- EAP WTHD21: 1099 Reporting IRS Changes for the Year 2021 (PeopleSoft Enterprise Payables) as a Favorite and check it periodically. If any new 1099 issues for 2021 are reported, Doc ID 2812159.1 will be updated with this information.
-------------
Q: Are we anticipating any further updates, or can we start testing with the updates for 9.2 that are available?
A: You can start testing the 1099 Update for 2021. If any 1099 issues are reported after applying the 1099 Update for 2021, these issues will be updated in Doc ID 2812159.1 -- EAP WTHD21: 1099 Reporting IRS Changes for the Year 2021 (PeopleSoft Enterprise Payables)
-------------
Q: Do we need to run an update on all suppliers to add the new box 11?
A: If you need to report Box 11 for a Supplier, please see Doc ID 2826213.1 -- EAP WTHD21: What is Required to Populate Box 11 (Fish Purchased for Resale) on Form 1099-MISC Copy B?
-------------
Q: Are there any new setup changes for 2021, if we have already updated suppliers with 1099M & 1099N? Or is it just downloading the tax updates?
A: If already updated the Withholding setup, Suppliers, Vouchers, and Withholding Transactions with Withholding Types 1099M and 1099N, just need to apply Bug 3421289 -- 1099 Update for 2021. If you need to report Box 11 for a Supplier, please see Doc ID 2826213.1 -- EAP WTHD21: What is Required to Populate Box 11 (Fish Purchased for Resale) on Form 1099-MISC Copy B?
-------------
Q: Are there any manual steps that need to be performed to the supplier 1099 configuration (for instance, something similar to last year's steps)?
A: If you need to report Box 11 for a Supplier, please see Doc ID 2826213.1 -- EAP WTHD21: What is Required to Populate Box 11 (Fish Purchased for Resale) on Form 1099-MISC Copy B?
-------------
Q: Last year we had number of SQL updated for 1099 update & we have made the changes last year. This year for 1099 NEC Do we need to make any setup changes or need to run any SQL Scripts.. If yes then any documents available?
A: No SQL scripts need to be run. If you need to report Box 11 for a Supplier, please see Doc ID 2826213.1 -- EAP WTHD21: What is Required to Populate Box 11 (Fish Purchased for Resale) on Form 1099-MISC Copy B?
-------------
Q: Box 11 is not applicable to us, but do need to do any configuration in order for it appear on Copy B form? or will the box 11 automatically appear on Copy B even if we do not use it with blank values?
A: No configuration is necessary for Box 11 to appear on Form 1099-MISC Copy B. It should appear automatically.
-------------
Q: One last question...what about the change reviewed regarding fish proceeds, etc.? My understanding was that was a 2021 change to 1099 reporting...is that correct?
(to clarify...that should impact the vendor and 1099 reporting setup, right?)
A: Correct, the IRS added Box 11 - Fish Purchased for Resale, to Form 1099-MISC Copy B. If you need to report Box 11 for a Supplier, please see Doc ID 2826213.1 -- EAP WTHD21: What is Required to Populate Box 11 (Fish Purchased for Resale) on Form 1099-MISC Copy B?
-------------
Q: What elements are in Bug 33421289 for the 12/6 update versus the one that is out on 11/19?
A: The PRP for Bug 33421289, which was posted on 11/19, is the same Bug that will be included in Image 42, which has a Target Post Date of 12/06. Once Image 42 is posted, Bug 33421289 will no longer be available as a PRP and there is no option of trying to request it is as a PRP. Bug 33421289 will need to be extracted from Image 42.
-------------
Q: We have applied the Nov 19 patch in our database. Do we need to apply Dec 06th patch as discussed just now. What is the difference between Nov 19th and Dec 06th patches?
A: If you applied the PRP for Bug 33421289, there is no need to apply Bug 33421289 which will be included in Image 42, Target Post Date 12/06. The patch posted on Nov 19 is the same Bug that will be included in Image 42.
-------------
Q: Can you discuss again the impact of Image 42 to be release on Dec 6 - you noted that the bug would no longer be available after this date.
A: Bug 33421289 will only be available as a PRP until Image 42 is posted. Once Image 42 is posted, if you never downloaded the PRP for Bug 33421289, and still need to apply Bug 33421289, you will have to apply Image 42 to a Virtual Box or Native OS, create a custom change package to extract Bug 33421289 from Image 42, and apply the custom change package for this Bug to your Target database.
-------------
Q: We just upgraded to PUM 041. Do we need to download the patchset?
A: If you want to apply the PRP for Bug 33421289, will need to apply it to a Virtual Box or Native OS on Image 41 then create a custom change package to extract Bug 33421289 from Image 41, and apply the custom change package for this Bug to your Target database. If the PRP for Bug 33421289 if no longer available, please see the previous question on how to apply Bug 33421289 with Image 42 applied to the Virtual Box or Native OS.
-------------
Q: Do we have to download the PUM41 PRP before December 6? What happens if we don't?
A: Bug 33421289 will only be available as a PRP until Image 42 is posted. Image 42 has a Target Post Date of Dec 06. Once Image 42 is posted, if you never downloaded the PRP for Bug 33421289, and still need to apply Bug 33421289, you will have to apply Image 42 to a Virtual Box or Native OS, create a custom change package to extract Bug 33421289 from Image 42, and apply the custom change package for this Bug to your Target database.
-------------
Q: Do you support the Update Withholding for tax year 2021?
A: Yes, we support Update Withholding for Tax Year 2021.
-------------
Q: Is piggyback functionality for state filings is still supported by 1099 reporting through IRS submission?
A: 1099 processing supports the Combined Federal/State Filing Program for 1099-MISC and 1099-NEC.
-------------
Q: If we didn't apply the bug to Virtual Box/Native OS with PUM 41 and applied it on our current PUM (which is not 41), can we continue by applying it to OS on PUM 41 and continue or we need to refresh the environment?
A: If you want to apply the PRP for Bug 33421289, will need to apply Image 42 to a Virtual Box or Native OS, create a custom change package to extract Bug 33421289 from Image 42, and apply the custom change package for this Bug to your Target database. If Bug 33421289 was applied directly to a Target database without going through the previous steps mentioned, to be on the safe side, it is advised to refresh the Target environment prior to applying the PRP for Bug 33421289 the correct way.
-------------
Q: Is there a plan to support 1099 Dividends from Oracle anytime in near future?
A: No, there is no plan to support 1099 Dividends.
-------------
Q: Bug 33617751 - is it genetic for all platforms or only Solaris? If on all platforms - when will it be fixed and is it going to be PRP.
A: Bug 33617751 -- AP: 1099-NEC COPY B FORM DOES NOT SHOW FULL RECIPIENT'S NAME USING TAX DOCUMENT ENVELOPE, should be available for all platforms. Development is still in the process of analyzing this issue.
-------------
Q: Bug 33617751: AP: 1099-NEC COPY B FORM DOES NOT SHOW FULL RECIPIENT'S NAME USING TAX DOCUMENT ENVELOPE 23 - Oracle Solaris on SPARC (64-bit) Is this bug needs to apply to our database?
A: If Development confirms that this is an issue, then Bug 33617751 will only need to be applied if you experience this issue.
-------------
Q: Please go over the IRS new changes.
A: Please see Doc ID 2813986.2 -- Advisor Webcast Recording: PeopleSoft -PeopleSoft 1099 Update for 2021 Get your Copy B’s out on time! on 30 November, 2021 [video]. Access the PDF of the presentation. Information about the IRS changes start on Slide 6.
-------------
Q: Do you have a flowchart(s) of the tables and flow of jobs impacting each?
A: Please see Doc ID 637632.1 -- EAP WTHD: Setup and Troubleshooting document for 1099 / Withholding Process, and download the attachment for "1099 for Rel 9.2 after 1099 Fix for 2016".
-------------
Q: Give us the link for trouble shooting again please
A: Please see Doc ID 637632.1 -- EAP WTHD: Setup and Troubleshooting document for 1099 / Withholding Process, and download the attachment for "1099 for Rel 9.2 after 1099 Fix for 2016".
-------------
Q: we are currently on PUM35 in our Production environment. Just the patch is sufficient for processing the 1099s? or do we need to pull things from other PUMs prior to 41?
A: If applying the PRP to a Virtual Box or Native OS on Image 41, when creating a change package for Bug 33421289 using Change Assistant, Change Assistant should flag any additional Bugs that are needed in order to apply the 1099 Update for 2021 (Bug 33421289).
-------------
Q: Hello, at the beginning of the call, you did mention that Form 1099-NEC, Nonemployee Compensation, is part of the Combined Federal/State Filing (CF/SF) Program. What update was made to include this since last year it was not included
A: This update was included in the Bug 33421289 -- 1099 Update for 2021 since it is a mandatory requirement from the IRS.
-------------
Q: You mentioned the Form 1099-NEC, Nonemployee Compensation is part of the Combined Federal/State Filing (CF/SF) Program at the very beginning.
May you explain how this update is included this year
A: This update was included in the Bug 33421289 -- 1099 Update for 2021 since it is a mandatory requirement from the IRS.
-------------
Q: Problems with correction files for 3rd year back trouble shooting missing txt records for IRS file where the form was printed.
A: If you are having issues with creating a Correction file, please create a Service Request with Oracle Support to look into this issue further.
-------------
Q: Is there a document that details the technical changes? Name of program and related changes to App Engine / SQR / BI Pub, etc? Thanks
A: Unfortunately, there is no code changes document available for Bug 33421289 -- 1099 Update for 2021.
-------------
Q: can we get a compare for changes in bug. or a differences document for the changes in code?
A: Unfortunately, there is no code changes document available for Bug 33421289 -- 1099 Update for 2021.
-------------
Q: Not sure if you covered in detail what happens if the Virtual Box is not on Image 41.
A: The PRP for Bug 33421289 must be applied to the Virtual Box on Image 41 prior to trying to apply the change package for Bug 33421289 to your Target database.
-------------
Q: When is the PRP available for 2021? Dec 6, 2021?
A: The PRP for Bug 33421289 was posted on Nov 19, 2021. Bug 33421289 will be included in Image 42, which has a Target Post Date of Dec 6. Once Image 42 is posted, this Bug will no longer be available as a PRP.
-------------
Q: Is Dec 6th a confirmed date for Image 42 release for 9.2 customers?
A: Dec 06 is the Target Post Date for Release 9.2 Image 42
-------------
Q: Between step 4 and 5, something was mentioned regarding making all changes/corrections to suppliers and vouchers before running a process. Can you clarify? was this before running the 1099 Job or a different process.
A: The changes to the Withholding Setup, Supplier Withholding and Withholding Transactions to include the Withholding Types 1099-M and 1099-N, need to be completed prior to running the 1099 Job.
-------------
Q: We have already applied the 1099 in non prod. But after testing only, we can apply that in PRD which will be apply Dec 6. Does it have any impact if we do it from image 42 in PRD?
A: You can either apply Bug 33421289 -- 1099 Update for 2021, as a PRP to your database or from Image 42 once it is posted to My Oracle Support. It is up to you how you want to apply it. If you already applied Bug 33421289 as a PRP to the Test database and tested the 1099 processes with the PRP applied, then the PRP for Bug 33421289 should be applied to PRD. If you decide to apply Bug 33421289 from Image 42, then you should apply Bug 33421289 from Image 42 to your Test database, test the 1099 processes, and then apply Bug 33421289 from Image 42 to PRD.
-------------
Q: When should a user enter a withholding adjustment or override?
A: Withholding Adjustment can be added if the 1099 amount for a Supplier is incorrect.
-------------
Q: Has anyone sent IRS test files to the FIRE test site and got the response on the status?
A: At least two customers have confirmed that they were able to successfully submit the 2021 Test IRS Tax file to the IRS.
-------------
Q: We are on 9.2 image 9, how to get latest updates for tax files and reports
A: Will need to apply Bug 33421289 as a PRP or from Image 42 once Image 42 is posted to My Oracle Support. Image 42 has a Target Post Date of Dec 06.
-------------
Q: Are there any post-reqs to PRP?
A: No, there are no post-reqs to the PRP for Bug 33421302 -- 1099 Update for 2021.
-------------
Q: What's the projected date that Image 42 will be available?
A: Image 42 is targeted to be posted on Dec 6, 2021
-------------
Q: Why there is discrepancy in field default values. Some Numeric fields are having default vales as '0' where as it is BLANK for some fields in the file generation
The states follow the federal guidelines and if it should be populated, the states will reject is. But the IRS will accept it. The feds don't enforce their own rules, but the states do.
IRS 1099 Publication. It shows Record type B: column 735-746 is local withheld tax. Shall be padded with zero. Currently the delivered process AP_APY1099 generates file with BLANK spaces. Not able to upload 1099-NEC to state of Mississippi for electronic filing as validation kicks in.
(19) Payee “B” Record -Record Layout Positions 544-750 for Form 1099-NEC
Field Position Field Title Length Description and Remarks
544 Second TIN Notice 1 Enter “2” (two) to indicate notification by the IRS twice within three calendar years that the payee provided an incorrect name and/or TIN combination. Otherwise, enter a blank.
545-547 Blank 3 Enter blanks.
548 FATCA Filing Requirement Indicator 1 Enter "1" (one) if there is FATCA filing requirement. Otherwise, enter a blank.
549-722 Blank 174 Enter blanks or carriage return/line feed (CR/LF) characters.
723-734 State Income Tax Withheld 12 State income tax withheld is for the convenience of the filers. This information does not need to be reported to the IRS. The payment amount must be right justified and unused positions must be zero-filed. If not reporting state income tax withheld, this field may be used as a continuation of the Special Data Entries field.
735-746 Local Income Tax Withheld 12 Local income tax withheld is for the convenience of the fi
Reference Only - Pls review from community posting - SR 3-25687564401
A: If there is a discrepancy in field default values per the IRS 1220 Publication, please create a Service Request with Oracle Support to look into this issue further.
Re: Cannot find link to PeopleSoft 1099 update webinar
Hello @User_69P5N,
Welcome to the Financial Management - PSFT (MOSC) Community and thank you for posting your question!
For a PDF of the presentation, please see Doc ID 2813986.2 -- Advisor Webcast Recording: PeopleSoft -PeopleSoft 1099 Update for 2021 Get your Copy B’s out on time! on 30 November, 2021 [video].
To access the PDF in Doc ID 2813986.2, click on the 'here' link seen in line 'For the PDF of the presentation used in this webcast click here.'
I hope the information provided has helped. If your question has been successfully addressed, please mark this reply with a YES on the question listed at the bottom of the post ('Did this answer the question?'). Only the user who created the initial question can perform this action. This will enable other Community Users to quickly identify the solution suggested, and see that this post has been successfully answered.
Thanks,
Missy
Re: 1099 For the Financial year 2021
Hello,
sharing with community that we submitted a test file to IRS and it was accepted.
Tedy