My Oracle Support Banner

EAM 9.2: A Few Columns in PS_LEASE_SCHED Table Are Not Populated for the Converted Asset Leases. (Doc ID 3064298.1)

Last updated on DECEMBER 23, 2024

Applies to:

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

Symptoms

Leased asset data for the asset leases are interfaced in the interface tables and the transaction loader process is run.

It was that few fields in PS_LEASE_SCHED were not populated by Transaction Loader, causing lease payments not being able to interfaced to Accounts Payables(AP):

LEASE_INTFC_AP_SW
BUSINESS_UNIT_AP
VOUCHER_ID
LEASE_INTFC_STATUS

Steps to Replicate:

1. Populate PS_INTFC_FIN, PS_INTFC_PHY_A, PS_INTFC_LEASE with asset lease data.

2. Run Transaction Loader AMIF1000.
     Menu > Asset Management > Send/Receive Infromation > Interface Transaction > Transaction Loader.
 
3. Query the table PS_LEASE_SCHED for the asset create: the 4 mentioned columns are not populated.

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.