Receivables - EBS (MOSC)

MOSC Banner

Refund Transactions not visible on Receipt Summry Form

edited Mar 21, 2019 12:07AM in Receivables - EBS (MOSC) 1 commentAnswered

Query a Receipt from UI

- Able to see Applied Transaction Lines

- Unable to see Refund Line

Ran Following Query:

select distinct SCE.Amount_applied, SCE.GL_DATE, account_number , application_type , HZ.category_code,SCE.APPLIED_PAYMENT_SCHEDULE_ID, sce.org_id, ps.org_id,

decode(PS.CLASS,'PMT','Receipt','CM','Credit Memo') Type,PS.TRX_NUMBER "Receipt/CM number"

from AR_RECEIVABLE_APPLICATIONS_ALL SCE ,HZ_PARTIES HZ , HZ_CUST_ACCOUNTS CUST , AR_PAYMENT_SCHEDULES_ALL PS

where

SCE.APPLIED_PAYMENT_SCHEDULE_ID = -8

SCE.DISPLAY='Y'

and SCE.GL_DATE between '01-SEP-2018' and '30-SEP-2019'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center