My Oracle Support Banner

ECM: View POS_XLAT_PROMPT Does Not Return All Payment Methods (Doc ID 2611389.1)

Last updated on NOVEMBER 17, 2019

Applies to:

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

Symptoms

ISSUE:

The view POS_XLAT_PROMPT only returns the payment method DRA (Draft) instead of all payment methods. This view is used as a position field type for Cash Forecast. Cash Management > Cash Forecast > Define Cash Forecast > Position Field Types. I have attached a screen shot of the Position Field Type - Payment Method

SELECT A.FIELDNAME, A.FIELDVALUE, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.EFF_STATUS, A.XLATLONGNAME
  FROM PS_POS_XLAT_PROMPT A
  WHERE ( A.EFFDT =
  (SELECT MAX(A_ED.EFFDT) FROM PS_POS_XLAT_PROMPT A_ED
  WHERE A.FIELDNAME = A_ED.FIELDNAME
  AND A.FIELDVALUE = A_ED.FIELDVALUE
  AND A_ED.EFFDT <= SYSDATE)
  AND A.FIELDNAME = 'PYMNT_METHOD')


STEPS:

1. Cash Management > Cash Forecast > Define Cash Forecast > Position Source -

2. Source is Payment -Go to the Selection Criteria -

3. Alias Name - Payment Method

4. String Value - Click on the Magnifying glass - the value only DRA in the list which is Draft



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.