My Oracle Support Banner

Audit History Tab in Prepaid Balances Does Not Track Actions Performed on Prepaids for Grants (Doc ID 2531371.1)

Last updated on DECEMBER 23, 2019

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Navigation: Customer Contracts > Determining price and Terms > Prepaid Balances --> Audit History tab

Audit History tab in Prepaid Balances is only showing the Status changes of the logged in user. It should show the audit history for all users.

Replication Steps
-----------------------
1. Login to the demo system using VP1
2. Create a Contract with rate based contract lines
3. Add a prepaid for the contract and make the prepaid status from "Pending" to "Ready"
4. Notice that  Customer Contracts > Determining price and Terms > Prepaid Balances ==> Audit History tab displays the status change
5. Login to the demo system using VP2 and review the prepaid history for the same contract we careted in step 2 using navigation  Customer Contracts > Determining price and Terms > Prepaid Balances ==> Audit History tab
6. Notice that the Audit History is blank.

The following SQL is seen in trace where OPRID is used in the where clause limiting the users view of the prepaid audit history

SELECT CONTRACT_NUM, CONTRACT_PPD_SEQ, DTTM_STAMP, TO_CHAR(CAST((DTTM_STAMP) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), OPRID, PREPAID_USE_SEQ, CA_PPD_ACTION, CA_PPD_STATUS, CA_PPD_UTL_DESCR, PREPAID_TRANS_TYPE, TO_CHAR(START_DT,'YYYY-MM-DD'), TO_CHAR(EXPIRATION_DT,'YYYY-MM-DD'), TO_CHAR(DEPLETED_DATE,'YYYY-MM-DD'), BI_DISTRIB_STATUS, BILL_PLAN_ID, PRODUCT_ID, PO_REF, USE_FOR_CONTRACT, CONTRACT_LINE_NUM, PURCHASED_AMOUNT, REMAINING_AMOUNT, DST_ID, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE, STATISTICS_CODE, TAXABLE_CD, TAX_CD, TAX_EXEMPT_FLG, TAX_EXEMPT_CERT, TAX_GROUP, CURRENCY_CD, TO_CHAR(CUR_EFFDT,'YYYY-MM-DD') FROM PS_CA_PREPAID_AUD WHERE CONTRACT_NUM=:1 AND OPRID=:2 ORDER BY CONTRACT_NUM, CONTRACT_PPD_SEQ, DTTM_STAMP DESC, OPRID

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.