My Oracle Support Banner

EAR9.2: Email ID Not Populated In The PS_AR32001_TMP Table. (Doc ID 2485361.1)

Last updated on MAY 04, 2023

Applies to:

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

Symptoms

Issue:
-------
EMAILID IS NOT GETTING POPULATED IN PS_AR32001_TMP TABLE when the STATEMNT job is run.


Steps to Replicate:
---------------------
1. Navigate to Main Menu > Accounts Receivable > Customer Interactions > Statements > Create Customer Statements
2. Provide a customer ID in the customer field, corresponding business unit and set ID
3. Run the STATEMNT job
4. After the process runs successfully, please query PS_AR32001_TMP for the corresponding statement ID or process instance


Actual Behavior:
------------------
You will see that the EMAILID field is not populated – that is a consequence of
CNTCT_SEQ_NUM being set to 0 – the steps that does this part has been marked in
the Service Request


Expected Behavior:
-------------------
EMAIL ID filed should be 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.