fms release90 fin esa alm bundle26 release notes

Copyright © 2009, Oracle. All rights reserved.

U.S. GOVERNMENT RIGHTS

The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.

The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.

If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:

Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are “commercial computer software” or “commercial technical data” pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.

The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.

The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Copyright Oracle Corporation, 2009. All rights reserved. of 31

Oct-09

PeopleSoft Enterprise Release Notes - 90 Bundle 26For FMS, ESA AND ALM ProductsThese release notes reflect application updates for PeopleSoft FMS, ESA and ALM products since the FMS 90 Bundle 25

Product Functional Category Incident ID Report Problem Description Resolution Description

Depreciation 1785869001

1895474002

1907224002

1913156001

Functionality 1794479001

1883007001

1898557001

1899924001

Asset Management

Depreciation with Limit code is not calculating correctly after adjusting the asset

We modified the Depreciation process so that Depreciation with Limit Code is calculating correctly when the asset is adjusted.

AM :DPR rows are not created in the accounting period, when the depreciation is resumed on the asset

We modified the Depreciation process to use the AM convention instead of MM/MQ convention when an asset's depreciation status is resumed.

AM:Accum Depr is dropped when adding asset with DB method calculated monthly

We modified the Depreciation process to prevent deletion of the accumulated depreciation entry when Depreciation option of Monthly is selected.

Assets created in last period of the year getting Over Depreciated

We removed the hard-coding of the MM convention in the Depreciation process; hence, it produces the correct depreciation results when the custom Mid-period convention is used.

Fair Value functionality back port to prior releases.

The 9.1 feature - Fair Value was backported to release 9.0 from release 9.1.

Define Allocation for Assets search button includes all asset statuses

We modified the PeopleCode so that the search option displays assets based on the asset status selected on the page.

AM:Error at ADJUST_WRK.PROCESS_ADJUSTMENT.SaveEdit Loop_Thru_CostBal

We modified the code to prevent a hard PeopleCode error when the Cost Adjustment page is saved without any changes to it.

No warning message, if the adjusted accumulated depreciation is more than the cost and accum depr.

We modified the PeopleCode so that the system issues a warning message if the adjusted accumulated depreciation plus the accumulated depreciation is greater than the cost of the asset.


Oct-09



Functionality 1906368001

1906683001

1907676001

1907840001

1912092001

1917722001

1919454001

Impairment Test 1899099001

Asset Management

Bonus depreciation is not calculated when it was RCT and IUT.

We modified the PeopleCode that prevents deleting the RESUME row of the original asset from the book history table. This produces correct depreciation entries when the retro process is used on this asset.

Indian Tax Depreciation - Depreciation amount not calculated correctly

We modified the India Tax Depreciation process so that the depreciation amount is calculated correctly.

AM:DEPT ID not defaulting to Custodian page when interfacing from AP/PO to AM

We modified the AMIF1000 Transaction loader program so that the department is populated in the custodian page when interfaced from other modules to AM.

AM:AMPS1000 not processing Voucher linked Serial Receipts where "Next Asset ID" used

We modified the AMPS1000 process so that it processes the voucher-linked serial receipts for which Next Asset ID is used.

Cannot Change 050 (Property) Asset Type within Basic Add

We modified the Basic Add page to enable you to edit the asset type when its value is Property and the product Real Estate Management is not installed.

AM:Asset Class Add gives Data Conflict Error

We modified the Asset Class page so that you can add the new asset class successfully.

Upon an IntraUnit TRF, the new asset not receiving the new asset type

We modified the PeopleCode to supply the correct asset type, asset subtype, and asset class when 'Use Profile' switch is selected during an InterUnit Transfer.

Search options error out : Fatal people code sql error

We modified the PeopleCode so that the search option in the impairment worksheet and the CGU Impairment page works correctly.


Oct-09



Inter/IntraUnit 1905508001

Interface 1920029001

Leases 1895659001

Parent-Child Processing 1912756001

Performance 1879084001

1910008001

Reports 1892129002

1894727001

1908381001

1909173001

Asset Management

AM:AMDPCALC Error ORA-01407 due to blank UOP ID after Interunit Transfer

We modified the PeopleCode to populate the field Units of Production ID on the transferred asset.

Asset Management

AMIF1000 is not creating all books when profile book effective dates are different

We modified the AMIF1000 Transaction loader program so that the process creates all the books when its effective dates are different in the asset profile.

AMDPCLOS is not creating accounting entries for some lease assets when there are transfers.

We modified the PeopleCode so that the system does not allow transfers with a transaction date which is earlier than the last transfer.

AM: Inappropriate error message (Haiku) when retiring child asset thru parent.

We modified the PeopleCode to display the following message when retiring child assets: "Transaction is saved, but no retirement has been performed on the selected asset(s)."

AM9 - AM_DPCLOSE runs much slower in 9 when compared to 8.4

We modified the Depreciation Close process AMDPCLOS to improve the performance.

AM:AMIF1000 Transaction loader process running slow after applying bundles 14-22

We modified the AMIF1000 Transaction Loader program to improve its performance.

EAM: Report AMLE2310 Results Are Based On Calendar Year End (12/31/xxxx), Not Fiscal Year End

We modified the Footnote Disclosure Report so that the report prints based on the calendar year of the specified business unit.

AM: AMTX3620 Informix error (SQR 5528) after applying bundle #17

We modified the SQR to the Report AMTX3620 to resolve the error in the Informix database.

amrt2010 In service Period printin problem.

We modified the Report AMRT2010 so that the values for In-service Period is printed correctly.

AM:AMASHIST does not load assets with ADD & ADJ in the same year

We modified the Asset History Report so that the report loads the correct asset information.


Oct-09



Reports

1918535001

Payment Processing 1917057002

Payment Transformations 1816931005

1922857002

Contracts Billing 1916659001

1917299001

1917608001

Contract Entry 1909485001

Asset Management

EAM: Report AMLE2300 Result doesn't show the "Total" when the report runs for 1 BU

We modified the Lease Footnote Disclosure Detail Report so that the report prints Total when the report runs for one business unit.

Cash Management

After applying Bundle # 23 BPR 04 is getting populated as SWT for USD Wires

We modified the PeopleCode in the application package TR_FORMAT to populate BPR04 as FWT for USD Wires.

Support payment format International ACH transaction of NACHA

We modified record PMT_ADDRESS_TBL, by adding new objects and modifying objects to support payment format International ACH transaction of NACHA.

SEPA_CT XML file misses <Dbtr> tag information.

We modified the PeopleCode in the application package TR_FORMAT to display debtor information in the SEPA_CT XML file.

CA 9.0: CA_BI_INTFC abends at CA_BI_INTFC.RC-20400.InsTA3 - ORA-00001: unique constraint (PS_CA_BI_RC_TA34) violated

We modified the application so that the Contracts Billing Interface runs successfully even if the distribution code is missing on the Contracts Accounting Distribution page.

CA 9.0: Bill To Customer Address not displayed when setid User Preferences different than customer setid

We modified the Customer Address subpage-related work record so that the subpage displays the customer address correctly based on the setID of the customer and not from the user preferences definition.

CA 9.0: running BIIF0001 for event reversal goes into ERR 0799 (Adjustment Err by Association)

We modified the Contracts to Billing Interface process (CA_BI_INTFC) so that the billing plan notes are sent to Billing when billing plan events are reversed.

ECA:9.0:Error message received when doing Amount Allocation which cannot be corrected as prepaid balances page shows not records

We modified the application so that an error message is issued when the user tries to delete the last rate-based contract line of a contract having prepaids.


Oct-09



eSettlements Invoice Presentment 1908821002

Expenses Accounting - General 1874419004

Approvals 1768971012

1909335002

1912991001

1913721001

1915790001

1915922002

Attendees 1918351003

Supplier is able to view invoice ID's created by other suppliers to which he is not authorized

We created a new view to display correct invoices for the prompt.

EX: Expense Report Distribution Line Accounting Detail ignores Set ID value from Record Group FS_08 (Projects)

We modified the system to use the correct setID for project prompting when Projects is not installed.

EX8.9: When there is high volume, getting Expense Report xxx could not be Approved

We modified the code to avoid the time-out on Expenses Approval processing.

EX 8.9: Expense Report routed to EX MGR while it should not. conti of SR #3-896602046

We changed the approval program to correctly route the expense report to the correct approver when the user receives a returned report and changes the expense type and the line value before resubmitting the report.

Error while trying to approve Time report entered for personal related hour-Sumit for Partial month

We modified the code to approve Adjustment Time Reports successfully.

Time sheet is going to the terminated approver

We changed the code to not have time sheet assigned to a terminated approver.

exp reports are becoming pending upon submission if there is a refinemnt template tied to approver

We changed the approval's refinement routine to correctly process transactions in a refiniment scenario with Project Expenses, expense types, or both enabled when the approval level is set to the header level.

EX 9.1: Effective dating for Transaction Definition is not being picked up for Expenses

We modified the code to process Expenses approval transactions according to the proper setup.

Empty Attendees lines are being allowed to add to an Expense Report

We changed the code to prevent empty attendees lines.


Oct-09



Expenses

Auto Mileage 1910985001

Expenses Cash Advances 1901932001

1905346001

Exchange Rates 1905733002

1918628002 Rounding Issue in EX 8.9

Expense Report - General 1906117001 We provided a correct version of the script.

1914784001

Global - Per Diem 1913575002

1916222002

Global - VAT/PST/GST 1880270004

1905659002

Update Totals Not Updating for Mileage Expense Types - Expense Entry

We modified the code to update totals correctly for Mileage expense types. We also fixed the issue in the Copy Selected function for Mileage expense types.

EX9.0:'Field does not exist' error when attempting to delete a cash advance.

We modified the system so that the Delete Cash Advance page opens properly when document sequencing is enabled.

Incorrect Balance/Totals Applied when reapply CA from prepaid auditor role

We modified the program to display the cash advance balance properly.

Expense report amount and AP payment amount are not in sync

We modified the code to calculate the expense amount to be reimbursed correctly.

We modified the code to calculate the expense amount to be reimbursed correctly.

EX9.0: FSCM 9 MP 10 Delta has errors in UPD786958_01.dms script

Exception Icon not pointing to correct line with CAN USER/ location

We modified the system to properly control the Exception Icon display.

Expenses reports - using start of season/end of season rates and incorrect rates are retrieved.

We modified the code to retrieve the correct rate for each period.

EX9.0: System is not calculating the time between 2 Per Diem ranges of period.

We changed the code so that the system calculates every period defined by the user properly.

EX: Out of balance accounting entries created in vat locations

We modified the code to populate VAT-related fields properly.

Integration - Corporate Cards

EX 8.9:Mastercard Transactions not getting loaded.

We modified the program to load credit card transactions properly.


Oct-09



Expenses

1909582001

Integration - Projects 1887912001

Expenses Performance 1900493002

1917662002 EX : PAGE SECURITY BREACH.

Templates - Public/User 1914259001

Time Reports - General 1903463002

1907595002 Project ID Validation Incomplete

1912548001

1918047002

Integration - Corporate Cards

Cardmember name not getting displayed on review credit card errors page for Diners card

We modified the system to properly load the card member information for Diners card so that it can be correctly displayed in the Review Credit Card Errors page.

TimeSheet Analysis type from PC Integration not defaulting correctly in EX_TIME_DTL.

We changed the Time Report process to correctly supply the Analysis type per the PC integration definition.

EX8.9 - EX_TRAN_PRCS process running slowly for canceling of payments.

We modified the code to improve the time response of Expense Transaction processing.

Security - Expenses & PTools

We changed the code to prevent SQL injection attack.

EX9.0: 'From' email id is not correct for Expense Report Submit Error and Approval Error Emails

We changed the software to get the correct sender email ID.

EX 9.1 D3 > User is able to submit a Time Report with Project hours but NO Project information.

We modified the system to not allow project hours to be entered without project information.

We modified the system to use all the necessary keys to validate the Project ChartField against the correct project.

In Time Reports ,if PC not installed the prompt behind Project field message: no prompt values available for that field.

We modified the code to enable prompt values for the Project field.

PC 9.0: Time Report cannot be saved - error "PC Business Unit - Project - Activity combination is not valid (13100,710)"

We changed the code to allow Time Report be saved properly.


Oct-09



Expenses

Travel Authorizations 1908729003

Allocations 1874786001

Allocations 1899723002

1910791002

1917885003

1920441001

ChartField Configuration 1916542001

1914036001

T Auths- system is returning only the first row of expense type rates configured with various rates

We modified the code to return the correct expense type rates.

General Ledger

EGL: Allocations creating secondary translation ledgers out of sync

We modified the Allocation App Engine program to create Translation Ledger Journal lines properly when the target ledger group contains secondary/translation ledgers.

General Ledger

ABENDED at Step FS_ALLC_BCUR.uBCBus.uBC when running processes in parallel

We modified the App Engine SQL so that the allocation process can run in parallel.

Rounding issue in Target amount after running FS_ALLC

We modified the Allocation App Engine program so that the rounding adjustments for table-to-table allocation with mapped target fields are created correctly.

Since applying bundle 37 for 8.8sp1 budget copy process does not generate output to ledger_budg

We modified the Allocation App Engine program so that Budget Copy works correctly when one (but not all) of the amount fields has zero.

Rounding difference with allocation rounding option 'Round Down' & Distribute odd cents to 'Last target line' or 'Largest target'

We modified the Allocation App Engine program so that the rounding adjustment works correctly when the Round option is Round Up or Round Down.

Affiliate CF does not have Business Unit as Interunit Related CF

We modified record PeopleCode so that when we again activate the Affiliate ChartField, Interunit related ChartField has Business Unit.

Consolidation and Equitization

Equitization: Undo Previous Process was not requested but previous process found

We modified the Equitization COBOL program so that the Undo feature works correctly.


Oct-09



Federal 1916015002

General Tables 1901950002

Inter/IntraUnit 1903077001

Journal Post 1902912002

1912859002

KK-Budget Checking 1882064002

1909066001

1911961002

KK-Budget Closing 1896777002

General Ledger

Page "SF1219 Transaction Update" does not allow to update lines 4.1 & 4.2.

We modified the 1219 line prompt so that lines 4.10, and 4.20 also appear for update via the SF1219 Transaction Update page.

In german the alt acct is shown in the wrong language

We modified the record so that the alternate account description is shown in the correct language.

Interunit balancing lines not being properly summarized for Allocation Journals

We modified the IU Processor program to reduce the number of IU balancing lines generated on multicurrency allocation journal lines with missing rate types.

General Ledger

Journal post does not generate reversal jounral entries for reversals created during journal process

We modified the COBOL file GLPPINWK.cbl so that the post process does not post primary journals when reversal is set for this and reversal journal cannot be created.

Unable to post reversal journal separately.

We modified the Post process so that the user can also post reversal journals separately from its base journal.

Journal Edit poor performance issue. Process hangs at FS_BP_PROC.uLStatus.Warnings (SQL).

We added new section uStats for program FS_BP_PROC to update the table statistics for the temporary table that stores the exceptions.

Deleting non-base cur document that has been valid budget checked creates an integrity issue in ledger kk

We modified sql in fs_bp_post del to use the correct currency code field.

FS_BP gives performance issues at FS_BP_EDITBJ.ComboEd.LogErr SQL Step

We modified Application Engine SQL Step: FS_BP_EDITBJ.ComboEd.LogErr; we removed KK Source Header from the subquery.

GL8.9: Error in budget closing when there is an inactive project in the period.

We modified the budget processor to omit the ChartField edits and also omitted Parent/child checking for Budget Closing-generated entries.


Oct-09



KK-Budget Definition 1895000002

KK-Budget Inquiry 1890752001

Reports 1920826001 Error in the grouping in GLS8020

Spreadsheet Journal Import 1895028002

Standard Budgets 1908286001

Forms 1904818002

Subrecipient 1915752001

General Ledger

Performance Issue when opening a budget definition with large number of rows in kk_cf_value

We modified record PeopleCode KK_WRK.FUNCLIB (Field Formula) to correct the performance issue.

Budget Overview Results displays incorrect budget status rows

We modified the Budget Overview inquiry to correctly display budget rows corresponding to the budget status selected by means of the Commitment Control hierarchy levels.

We modified the report GLS8020 so that a single line grouped with another ChartField group must be separated by a blank line.

General Ledger

Copying sheets with Stat Amt column removed in JRNL1.xls causes unexpected messg

We deleted Name referenced for the column when a field (column) is deleted from the template.

EGL: Detail Budget Maintenance Accounting Period and ChartField Scope errors

We modified PeopleCode so that Detail Budget Maintenance updates correct rows depending on the ChartField values specified.

Grants Management

The Federal Financial Report (FFR) form 425 does not match the U.S. Government's layout.

We modified the Federal Financial Report to have the correct layout.

NAME1 on GM_AWD_PRJ_VENDOR does not populate from GM_AWD_PRJ_VNDR1 page

We modified the application so that the system displays the subrecipient's name in the Award Subrecipient Misc page.


Oct-09



Work Order 1902881001

Payables AP/AM -Interface 1912989002

Bank Maintenance 1902031002

Payables Document Tolerance 1905882002

ERS/RTV/SBI 1903291001

Federal Payment Schedule 1916391001

Maintenance Management

Hardcoded label in WM_TSK_ATTACH_SBP page when logged in in other language than English.

An invalid message catalog entry (message set number 18206, message number 10038) for the File Name column label text was referenced in application classes WmWOHandler and WRAttachmentsHandler. In both these cases, we modified the code reference to use the correct message set number 18205 (that is, not 18206).

AP > 9.1 > S134 > French VAT Recoverability - INTFC_PRE_AM process goes to error for unpost voucher with VAT information

We modified the AP/AM Interface process to French VAT Recoverability so that when the voucher is unposted with VAT information, the process finishes successfully.

Advice on how to set up payment type letter of credit

We added some Record PeopleCode that leaves FORM_TYPE = 'LCA' so that it can be used as a form type for Payment Method = LC (instead of changing it to 'ADV').

AP: Document Tolerance generating exception E100 for PO Voucher with negative line.

We modified the Document Tolerance process so that it doesn't generate an incorrect E100 exception for a PO voucher with negative line when the ChartField value defined for the tolerance does not match between the PO line and the voucher line.

EAP:Voucher Build does not create ERS vouchers when Packing Slip # is entered

We modified Application Engine SQL so that receipts are selected for processing when a packing slip number is entered on the receipt line.

AP: Alpha numeric invoice number is not supported on Treasury SPS Offline system

We modified PeopleCode so that a warning is issued when a voucher is entered for a Federal vendor with an alphanumeric invoice number.


Oct-09



Payables

Inquiries 1894056001

1903123001

1908294002

Payables Inquiries 1908961002

Integration - Others 1909645001

1912948001

On Payment Inquiry, discount taken is incorrectly populated with manual payment.

We modified PeopleCode so that when a voucher is paid either through a manual payment worksheet or by recording the payment, the discount taken field is not selected on the Payment Inquiry panel.

AP: Payment Inquiry does full fetch based on the criteria ignoring the MAX rows.

We modified the record PeopleCode so that if the criteria returns more rows than the maximum rows specified, a message appears asking the customer to either risk a slow retrieval or cancel the search.

AP - Voucher Inquiry Search Timeout (AP_VOUCHER_INQUIRY)

We modified the view INVOICE_ID_VW by removing the nested query to improve the performance of the View.

AP_SCHD_PYMNT.GBL component is really slow

We modified the views AP_SCHD_INQ_VW and AP_SCHD_INQ_VW2 so that all the keys are joined. We also modified Component and Record PeopleCode to modify the WHERE clause constructed to resolve the slowness in the component AP_SCHD_PYMNT.

AP9.0: Double-byte characters were garbeged when importing AP Voucher records from Excel Voucher

We modified the Visual Basic code so that double-byte Japanese characters are correctly processed and posted to PeopleSoft Payables.

EAP: unable to load vendors with VAT information using excle to ci

We modified the Component Interface VNCDR_ID_EXCEL to allow a VAT country to be entered so that a vendor with VAT information can be created by means of the ExcelToCI utility.


Oct-09



Payables

Integration - Others

1920253001

Matching 1897689003

1915758001

Payables Matching 1919231002

1910787001

1918731001

1920392001

The Full Data publish rules created in resolution 776755 did not make it into 9.0 Master DB during Bundle #21 build.

We re-created the Full Data Publish rules to import script that was originally delivered in resolution 776755.

Activity summary page not showing the correct matched QTY

We modified the Matching Application Engine (AP_MTCH_FUME) so that a PO having multiple receivers is matched to one voucher. The matched quantity is displayed correctly on the PO Activity page.

System allows same receipt to be copied to more than one voucher and they get matched.

We modified the Matching process so that when different vouchers are created from the same receiver with the quantity of receiver, the process generates the corresponding exception.

AP: Match Workbench not checking Voucher IN_PROCESS_FLG.

We modified the Match Workbench Exceptions page so that updates cannot be saved if the voucher is selected for batch processing after the exceptions page is launched.

Paycycle/ ACH/EFT Processing

PS_PAYMENT_TBL.PREFERRED_LANGUAGE not updated when Preferred Language is specified on the Pay Cycle

We modified PeopleCode and the Application Engine program (AP_APY2015) so that Vendor Preferred Language is taken into account in the pay cycle.

Manual Positive Payment - Descr too long for insert

We modified PeopleCode so that it truncates the translated description to 30 charactors before inserting it into the table.

AP: Invalid First Payment displayed through Paycycle Approval page

We modified the Application Engine process so that the first payment listed in the Paycycle Approval page is valid.


Oct-09



Payables

Posting - Voucher 1907042001

1908160002

1911180002

Payables Reports 1914363001

Vendor 1907786002

1923678001

Voucher 1806766014

1899573002

EAP: AP_PSTVCHR run status in Process Monitor is 'Success' although voucher hasn't been posted

We modified Application Engine AP_PSTVCHR to change the process status to Warning when a voucher hasn't been posted.

Monetary amount on expense line for Primary ledger in VCHR_ACCTG_LINE is incorrect

We modified the Voucher Posting process to calculate the foreign amount on the expense line for ledger correctly.

EAP:Rounding Suspense Account (RSA) entry is generated by AP_PSTVCHR during Voucher Closure

We modified the Voucher Posting process to generate the correct accounting entries for the voucher closure.

EAP: When opening the APY1408- Crystal report (Vendor Open Liability) the Informative message: 'The saved data will be discarded since one or more formulas failed to compile' is showed.

We synchronized the Crystal Report (APY1408) with the database.

AP: VNDR_IMPORT process abends at step VNDR_IMPORT.VENDOR7.Step01

We modified record VNDR_LOC_FL_VW in such a way that Application Engine VNDR_IMPORT finishes successfully.

Date fields at PS_VENDOR are not being updated when they are NULL

We modified the Voucher online process to update the last activity date with the current date when the date fields at Vendor are NULL.

AP8.8SP1:Address labels are not displayed in Single Payment Vendor Page

We modified the Record PeopleCode of VCHR_VND_BANK.BUSINESS_UNIT.FieldFormula to display the address labels in the Single Payment Vendor page.

AP 8.9: Speedchart: distribution sequence numbering incorrect

We modified the PeopleCode so that the distribution sequence numbers are correct when Speed Chart Codes are used.


Oct-09



Payables

Voucher

1899821001 EA: Issues with opening large vouchers

1901032001

Payables Voucher 1912659002

1914666001

1915931001

1919763001

1920674001

We modified the Voucher Approval component to not automatically fetch voucher and distribution lines when you access the component.

AP: When changing vendor to non-withholding vendor on a voucher, receiving 'No matching buffer found for level (15, 26)' error

We modified Record PeopleCode so that a loop is used to delete withholding rows to resolve the issue.

AP: After applying bundle 23 unable to save vouchers which are created for control account

We modified the Voucher Build Application Engine program and Voucher Online PeopleCode so that if the control account is inherited from the PO, the voucher can be saved..

Discrepancy between the voucher accounting line table and the voucher accounting VCHR_ACCTG_LINE table

We modified PeopleCode to select the Description field from the distribution line record just for the Expense Distribution accounting lines.

AP: Currency and GL Business Unit fields are not populated on voucher when using session defaults

We modified the Record PeopleCode to override the defaults that the system applies using the PeopleSoft Payables control hierarchy when ad hoc session defaults are used and blank values are entered on the session defaults page.

Hitting save button on the voucher without modifying any information is updating the modified and modified by fields

We modified the voucher online component so that when a closed voucher is opened with different sign-in and saved, the information does not get modified.

AP 9.0 Session Default page prompts an irrelevant Error message

We modified the Voucher Entry page to fix the error message when you enter the vendor information in the Session Defaults subpage.


Oct-09



Payables Voucher

1921843002

Voucher Build 1905790002

Payables Voucher Build 1908626001

1909810001

1916918001

Voucher Maintenance 1919447001

Withholding 1901902001

Cursor focus changed after applied 8.9 MP11

We modified the Record PeopleCode so that after you save the voucher, the cursor points to the Invoice field.

monetary/foreign amounts not calculated when recycled vouchers only

We modified the Voucher Edit Application Engine (APVCHREDIT) to also perform a proration calculation when processing vouchers in recycle status.

AP: Voucher Build process abends at step AP_VB_CNTR.MAIN.Step01 (Action SQL) -- RC = ?

We created a new SQL to resolve the Voucher Build abend issue when the process runs for multiple business units.

Voucher is recycled when Business Unit AM is populated but distribution line is not Asset Related.

We modified Application Engine SQL to valide the asset profile ID based upon the ASSET_FLG value rather than the presence of an asset business unit.

AP_VCHRBLD calculates incorrect tax amounts for Vertex Q

We modified the Voucher Build Application Engine so that it does not include tax calculated on freight in the sales tax.

EAP: Error received on Voucher Maintenance page

We modified the Voucher Maintenance page to fix the error message issued when you try to save the voucher after changing the remit vendor.

EAP:System allows TDS payment schedule to be split

We modified the PYMNT_VCHR_XREF Record PeopleCode so that the TDS Schedule is not split while the payment is being recorded.


Oct-09



Payables

Withholding

1904258001

1908082001

Payables Withholding 1908499001

1909399001

1910727001

1913809001

TDS additional components issue in case of foreign currency vouchers

We created new fields and modified the corresponding records to include these fields. We also modified the PeopleCode and SQLs in the Application Engine Program AP_WTHDCALC so that the fields that were created hold the base values when a voucher has foreign currency.

EAP: The Withholding amount is not calculated correctly when paying the main Vendor. The Withholding Entity has Apply Withholding = Payment and Round Option is NRR.

We modified the PeopleCode in Application Engine Program AP_WTHDCALC so that NRR is calculated correctly when withholding is at payment.

Withholding account is not overridden when rule is overridden

We modified SQLs in Application Engine Program AP_PSTVCHR and standalone SQL to select the correct account number.

EAP:Withholding basis amount (India TDS) includes Merchandise amount and Excise/Sales Tax amount

We modified the SQLs and PeopleCode in Application Engine Program AP_WTHDCALC so that withholding basis amount is based on the settings selected on the withholding entity page.

EAP: India Withholding - TDS amount not computed correctly: Withholding Amount (WTHD_AMT), Surcharge Amount (WTHD_SURCHRG_AMT) and Cess Amount (WTHD_CESS_AMT).

We modified SQL and PeopleCode in the Application Engine Program so that TDS amounts are calculated correctly.

Incorrect payment id generation after adding a new row in Withholdng adjustment.

We modified the Withholding Adjustment code to generate the correct payment ID.


Oct-09



Payables Withholding

1914218001

Activity General 1912944001

Manager Workbench 1901882001

Project Activities 1902770001

AR Integration 1901686002

Messages 1905694001

Pricing and Rate templates 1880392003

EAP: Withholding liability entry in Accrual Accounting Entries shows incorrect amount

We modified Application Engine Programs AP_WTHDCALC and AP_PSTVCHR by adding new steps and modifying the existing actions so that the withholding liability entry in accrual accounting entries shows the correct amount

Program Management

PGM 9.0: field "Duration (Days)" updated to '0' after outdenting a WBS ID

We modified the PeopleCode so that Duration (Days) doesn't get updated to 0 after a WBS ID is outdented.

PGM 9.0: grid "Overloaded Resources" on "Manager Workbench" not populated even though resource has been assigned to multiple activities

We modified the code so that the grid Overloaded Resources on Manager Workbench is populated when a resource has been assigned to multiple activities.

Program Management

PGM 9.0: Gantt Chart not displaying activities correctly when "Expand" set to "Level 1"

We modified code to display the activities and WBS IDs correctly on the Project Activities and Gantt Chart pages.

Project Costing

PC_AR_TO_PC set payment Write Off accounting date to the original item

We modified the SQL in PC_AR_TO_PC to pick the accounting date from the individual item distribution record ITEM_DST rather than the parent record ITEM.

System does not Display any Project ID for projects created from Templates- when 'User ID Level Security' is choosen

We added a new message catalog so that the error message displays the project ID of the newly created project.

PC_PRICING sets PROJ_TRANS_TYPE and PROJ_TRANS_CODE = blank.

We modified the PC_PRICING application engine so that it sets the source value of PROJ_TRANS_TYPE and PROJ_TRANS_CODE to the target rows.


Oct-09



Pricing and Rate templates

1905534001

Usability 1921325002

1919370001

Receivables Aging Reports 1876924001 We modified AR30001.SQR to fix layout issues.

Receivables AR Update - Posting 1875578001

1906554001

Automatic Maintenance 1880917001

1890955001

Project Costing

PC_VAR_PRICE - Variance Pricing flags are incorrectly copied when adding new effective dated rate set.

We modified code to have status flags, seq numbers reset when you add new effective-dated rows to a rate set that has already been variance priced.

Transaction Adjustment link on Transaction List page gives invalid transfer parameters error

We changed the code on the Transactions List page so that the you are transferred properly to the Transaction Adjustment page after clicking the link.

Real Estate Management

2.7 Straightln. Sched. (FASB)

REM 9.0 - Straightline period ratio is not calculated properly

We modified the Generate Straightline Schedule process to recalculate the period ratio when only one straightline period exists.

AR30001 export in CSV format inconsistent

EAR 9 Not Able to Edit Real Gain/Loss Accounting Entry Online for Maintenance Group with COMBO Error

We enabled deletion of accounting entries when a combo edit error is encountered in the Maintenance worksheet.

AR Update Errors Out- Unique Constraint error at Step:AR_PGG_SERV.MULT_RGL.REALGAIN

This resolution fixes abends in AR_PGG_SERV.MULT_RGL.REALGAIN caused in noninterunit scenarios or in scenarios with rounding in the primary ledger.

9.0 AR Auto Maintenance creates postable worksheets with items not reaching maximum number of days

We fixed the Auto maintenance process to select only items that reach the maximum number of days for write-off.

AR_AUTOMNT does not write-off if setid of rec group FS_23 is different than that of AR_15 and AR_31

We modified SQL to ensure that AR_AUTOMNT writes-off items if setID of rec group FS_23 is different than from of AR_15 and AR_31.


Oct-09



Receivables

Business Units 1892304001

Cash Control 1879661002

ChartField Inheritance 1921405001

Receivables Condition Monitor 1888733001

1913206001

Customers 1892710001

Deposits - Regular 1881809001

AR9: Existing BU saved automatically when entered as AR BU

We modified BUS_UNIT_TBL_AR.BUSINESS_UNIT_GL.FieldChange so that AR BU is not saved automatically associating it with GL BU even though the page is not saved.

AR8.9: PAY_MISC_DST rows not cleared for deposit in transit deleted payment

Cash control entries are not deleted from PS_PAY_MISC_DST after a payment is deleted when a deposit in transit is selected on the bank account

For payment entry, DEPT chartfield doesn't copy over value from Rounding Control Distribution ID

This fix reads CF values from the rounding control distribution ID

AR 9.0>>Issues on Reassign Action Page

We modified ACTION_LST.ASSN_OPRID.RowInit so that when owner type SALES PERSON is selected with the owner it is assigned to the correct owner.

Condition Monitor ABENDED at cStep AR_DUNNING.INS3300A.INS33001

We modified Application Engine SQL so that it does not end abnormally at AR_DUNNING.INS3300A.INS33001 when launched automatically by the process scheduler.

Customer Account Overview Page Times Out for Large Number of Customer Actions

To prevent the page from selecting items from PS_ACT_LST_HIS_VW before the user enters selection criteria, No Auto Select is being deactivated on page ACTION_HISTORY, ACT_LST_HIS_VW Grid.

AR9: Payment ID is gray even though worksheet is not created

We modified PeopleCode to ensure that Payment ID is available for entry when payment is in unidentified status.


Oct-09



Receivables

Direct Debit 1890174001

1889363001

1895931001

Receivables Drafts 1906994001

Dunning 1904908001

Excel Payment Upload 1825558001

Interfaces 1888711001

Item Entry 1882380001

Error: Direct debit item is going to rejected by the remit process.

We modified PeopleCode to resolve reported issue.

Direct Journal - Acctg Entries

Direct Journal Combo Edit Error Message is not populated

We modified PeopleCode at PAY_MISC_WRK.JOURNAL_COMPLETE.SaveEdit to use the AR business unit instead of the GL business unit to get the setID when you are looking up combo edit options on the AR BU options page.

Fatal Peoplecode SQL Error when generate 100+ offset cash lines for Direct Journal Payment

We modified PeopleCode at PAY_MISC_WRK.CREATE_DST_LINES.SavePreChg to enable the user to create more than 100 distribution lines for direct journals.

AR9: AR Update abends for drafts with items that have multiple distribution lines

We ensured that AR Update processes drafts with items that have multiple distribution lines.

Condition Monitor abending at AR_DUNNING.INSCNTCT.INSNCNCT with unique constraint error

We modified the AR_DUNNING program so that the dunning process does not end abnormally at step AR_DUNNING.INSCNTCT.INSNCNCT.

ExcelUploadforDeposits.xls throws error when opening

We created a new Excel Spreadsheet Object specifically for Excel 2007 - ExcelUploadforDeposits_2007.xlsm

AR 9.0 DC_PENDITEM_CI - Issue with ACCOUNTING_DT on PENDING_ITEM sequence #1

We modified PeopleCode to set the correct accounting date when importing pending item data using DC_PENDITEM_CI.

AR Item Mass update in AR in 9.0 on Item List does not have Remove dispute option

We modified Record PeopleCode to ensure that the dispute reason can be updated to no value using Multi-item update on the Item List page.


Oct-09



Receivables

Item Entry

1884628002

JFMIP 1873344003

1901671002 AR - Online IPAC Edits

Maintenance WS 1902824001

Receivables Payment Predictor 1889291001

Payment WS 1889877001

1900911001

Payment WS - Acctg Entries 1857340002

EAR 8.9+ Entry Event and Accounting Entry fields can be Updated Even if Group is Already Marked for Batch Standard.

We modified PeopleCode to ensure that Entry Event and Accounting Entry fields cannot be updated when Group is Marked for Batch Standard.

AR - Enhance AR Refund processing to support IPAC processing

We added a PeopleCode edit to the Maintenance Worksheet to verify that the item has an IPAC adjustment transaction before it can be selected for refund processing.

We modified various IPAC online PeopleCode programs.

Maintenance WS: Write off of multiple items ends in improper error on page - Exceeds write off amts

We ensured that an error message is issued only when write-off exceeds the tolerence limit.

AR>9.0>Payment Predictor>When items with different exchange rates are paid together, Payment group is not successfully posted because of ACTOB error.

We modified two SQL objects so that the predictor rounds the ITM_PAY_AMT_BASE to the payment base currency when the payment currency is different from the payment base currency, item balance currency is the same as payment currency, and item balance currency is different from the item base currency.

Fields not refreshed in Payment Worksheet

We added code to supply item details when they are manually added on the worksheet.

Getting Fatal SQL Error While Applying Payment at PAYMENT_ITEM.BAL_CURRENCY.FieldFormula

We modified PeopleCode so that the user can build a payment worksheet without receiving an error message.

Accounting Entries Out of Balance for the WAU

We changed the PeopleCode PAYMENT_ITEM.ENTRY_TYPE.FieldChange to consider rates entered by the user.


Oct-09



Receivables

Revaluation 1889403001

Statements 1892478001

Usability 1890382001

Cache Administration 1911140001

Employee Profile Module 1895236002

SC Workbench 1899323001

1911154001

Schedule Assignment 1901536002

AR_REVAL is abending because it's not using correct setid for chartfield inheritance*

We modified code in AR_REVAL section BLDACCTG, STEPS GETINSET, and INHEROBJ.

Statements process prints items from additional customers apart from one given on the run control.

We modified SQL to ensure that the Statements process does not print items from additional customers apart from the one given on the run control page.

AR9.0 : Item activity - Amount and currency truncated if group ID is long and amount is 12 digits or more.

We adjusted scroll width to accommodate larger amounts and longer group IDs.

Resource Management

RS9.0: Wrong Availability score calculated for resources with multiple assignments and appointments

We modified PeopleCode to get the correct availability score for a resource having multiple assignments and appointments.

Resource Management

EMM: The Supervisor ID is not showing up for a resource in maintenance management

We modified PeopleCode to update the supervisor ID correctly

RS: Recommended Resource retrieved multiple times Staffing Workbench if previously set to Considered

We modified PeopleCode to check whether a resource is already present in the grid after expanding.

RS9.0: Incorrect availability shown if resource has several assignments and appointment

We modified PeopleCode to get the correct availability score for a resource having multiple assignments and appointments.

PROJ_TEAM_SCHED & PROJECT_TEAM records does not get updated with FMS_LASTUPDDTTM (it is inconsistant

We changed PeopleCode to update FMS_LASTUPDDTM in PROJ_TEAM_SCHED and PROJECT_TEAM records.


Oct-09



Verity 1901486001

1902343001

Chartfields 1908656001

Treasury Deal Capture 1908786002

Resource Management

Search Index Agent is not updating the Index file.

We modified PeopleCode for Inserting/Updating/Deleting the documents in verity index by using Search Index Agent.

RS9.0: Search not working when root node is selected.

We modified PeopleCode to get search results when the buffer size is more then 3640.

Staffing Front Office

FO 9.0: Duplicate field FO_ASGN_TAO_UPG.TIME_START in FO_ASGN_TAO_UPG and its subrecord.

We removed the field TIME_START from Record Definition FO_ASGN_TAO_UPG.

EDM: Deal Paydown Abend at Step TR_POSN_LIB.PHYSCAL1.CLCYIELD

We modified the length of field YIELD_EST to calculate correct yield for a deal.

This document provides an overview and briefly describes these PeopleSoft Enterprise PeopleTools features:

Understanding Lifecycle Management Features

Application Designer’s Compare Features

Feature Description

Generate compare and reports.

Generate browser reports.

Visually compare page definitions

Visually compare and merge page definitions

Visually compare and merge text definitions.

Taking Advantage of Enterprise PeopleToolsLifecycle Management Features · Application Designer’s compare features. · Change Assistant. · Change Impact Analyzer.

Enterprise PeopleTools provides a variety of tools and utilities to aid in maintaining your PeopleSoft investment. These tools are designed to enhance installation, upgrade, and the application of software updates, or bundles. By providing a rich user interface and by automating many of the steps, the administrative tasks involved within an installation, upgrade, or update require less time and effort, all while reducing potential errors.

The features discussed in this document focus on the tools and features that would be most useful while applying a PeopleSoft application update, or bundle.

Note. The features described in this document have become available in different, incremental Enterprise PeopleToolsreleases. Whether you can use a feature described in this document depends on your Enterprise PeopleTools version.

PeopleSoft Application Designer enables you to compare the contents between two databases or between a databaseand a file. Viewing the status of each definition in each location gives you the information for deciding which definitionsto keep during an application update. The following table describes some of the key features you can use whenperforming definition comparisons.

These reports appear in the PeopleSoft Application Designer workspace immediately after the compare process completes, highlighting differences between two data sources.

These reports are written to HTML and XML files enabling you to open the report in a browser, share the report with coworkers easily, and store report data in an industry-standard format.

Enables you to view source and target page definitions side-by-side, with differences clearly marked.

Adds to the visual page compare by providing the merge feature.

This feature enables you to view PeopleCode, HTML, SQL, and XSLT definitions side-by-side, with differences clearly marked. It also enables you to merge source PeopleCode with target PeopleCode.

See Also

Change Assistant

See Also

Change Impact Analyzer

Impact Type DescriptionStructural

Behavioral

Enterprise PeopleTools 8.46 (and later) PeopleBook: PeopleSoft Application Designer, Comparing Source and TargetDefinitions, “Working with Browser Reports”

Enterprise PeopleTools 8.46 PeopleBook: PeopleSoft Application Designer, Comparing Source and TargetDefinitions, “Comparing Page Definitions Visually”

Enterprise PeopleTools 8.48 (and later) PeopleBook: PeopleSoft Application Designer, Comparing Source and TargetDefinitions, “Comparing and Merging Page Definitions”

Enterprise PeopleTools 8.46 (and later) PeopleBook: PeopleSoft Application Designer, Working With Text DefinitionsDuring Upgrades

Enterprise PeopleTools 8.44 introduced PeopleSoft Change Assistant to improve the process of finding, analyzing,downloading, and installing application patches and updates. The Environment Management hub gathers informationabout your environment (including licensed products, maintenance history, and so on) and uploads this informationto the PeopleSoft product support website. Based on your specific environment information, Change Assistant: · recommends only the necessary software updates. · verifies prerequisites and post-requisites and determines the order to apply software updates. · applies software updates with minimal user intervention. · maintains a complete history of all software updates applied to each environment.

Enterprise PeopleTools 8.44 (and later) PeopleBook: PeopleSoft Change AssistantEnterprise PeopleTools 8.46 (and later) PeopleBook: PeopleSoft Software Updates

Enterprise PeopleTools 8.48 introduced Change Impact Analyzer, a change analysis tool that enables you to exploreand understand the downstream effects of taking patches or making changes to an application—all before acceptingor making the change. Change Impact Analyzer can be leveraged in conjunction with Change Assistant to reduce thetime required to analyze and implement changes to your system.

Change Impact Analyzer is an interactive utility through which you can view the relationships of PeopleSoft definitions(such as fields, records, or pages) in a hierarchical view. Based on a set of configurable rules, Change ImpactAnalyzer determines the relationships between definitions so that you can assess various types of potential changeimpact, such as those described in the following table, with a quicker, more comprehensive approach.

These could be impacts such as how a change to a field type or its properties could affect the structure of a record. Making changes to a field without considering its effect on associated records may cause runtime errors.

These could be impacts such as changing a common library PeopleCode program that is called by numerous other PeopleCode programs. This can affect the behavior of the calling program. Or, suppose a PeopleCode program that writes to fields has changed. This can affect the behavior of the fields. In these cases, Change Impact Analyzer lists all the affected programs or fields for your analysis.

See Also

Being aware of all the relationships between definitions and the potential structural or behavioral impacts associatedwith a change helps you determine what other modifications need to be made and helps you create a testingstrategy.

Enterprise PeopleTools 8.48 (and later) PeopleBook: Change Impact Analyzer

This document provides an overview and briefly describes these PeopleSoft Enterprise PeopleTools features:

Understanding Lifecycle Management Features

Application Designer’s Compare Features

PeopleTools Release

8.x

8.46

8.46

8.48

8.48

Taking Advantage of Enterprise PeopleTools

Enterprise PeopleTools provides a variety of tools and utilities to aid in maintaining your PeopleSoft investment. These tools are designed to enhance installation, upgrade, and the application of software updates, or bundles. By providing a rich user interface and by automating many of the steps, the administrative tasks involved within an installation, upgrade, or update require less time and effort, all while reducing potential errors.

The features discussed in this document focus on the tools and features that would be most useful while applying a

The features described in this document have become available in different, incremental Enterprise PeopleToolsreleases. Whether you can use a feature described in this document depends on your Enterprise PeopleTools version.

PeopleSoft Application Designer enables you to compare the contents between two databases or between a databaseand a file. Viewing the status of each definition in each location gives you the information for deciding which definitionsto keep during an application update. The following table describes some of the key features you can use when

See Also

Change Assistant

See Also


Enterprise PeopleTools 8.46 (and later) PeopleBook: PeopleSoft Application Designer, Comparing Source and Target

Enterprise PeopleTools 8.46 PeopleBook: PeopleSoft Application Designer, Comparing Source and Target

Enterprise PeopleTools 8.48 (and later) PeopleBook: PeopleSoft Application Designer, Comparing Source and Target

Enterprise PeopleTools 8.46 (and later) PeopleBook: PeopleSoft Application Designer, Working With Text Definitions

Enterprise PeopleTools 8.44 introduced PeopleSoft Change Assistant to improve the process of finding, analyzing,downloading, and installing application patches and updates. The Environment Management hub gathers informationabout your environment (including licensed products, maintenance history, and so on) and uploads this informationto the PeopleSoft product support website. Based on your specific environment information, Change Assistant:

verifies prerequisites and post-requisites and determines the order to apply software updates.applies software updates with minimal user intervention.maintains a complete history of all software updates applied to each environment.

PeopleSoft Change AssistantPeopleSoft Software Updates

Enterprise PeopleTools 8.48 introduced Change Impact Analyzer, a change analysis tool that enables you to exploreand understand the downstream effects of taking patches or making changes to an application—all before acceptingor making the change. Change Impact Analyzer can be leveraged in conjunction with Change Assistant to reduce the

Change Impact Analyzer is an interactive utility through which you can view the relationships of PeopleSoft definitions(such as fields, records, or pages) in a hierarchical view. Based on a set of configurable rules, Change ImpactAnalyzer determines the relationships between definitions so that you can assess various types of potential changeimpact, such as those described in the following table, with a quicker, more comprehensive approach.

See Also

Being aware of all the relationships between definitions and the potential structural or behavioral impacts associatedwith a change helps you determine what other modifications need to be made and helps you create a testing


fms release90 fin esa alm bundle26 release notes

Documents

administrative

united states

french vat

copyright

commercial

rec group

federal financial

search index