Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

FOREIGN_AMOUNT,MONETARY_AMOUNT are different for an Expense Report in Journal Ln

edited May 5, 2020 2:39PM in Enterprise Service Automation (ESA) - PSFT (MOSC) 1 commentAnswered ✓

Please review the sqls, TXN_AMOUNT,MONETARY_AMOUNT are same until they went into Journal Line. It is not happening for all the transactions, very selective.

SELECT TXN_AMOUNT,MONETARY_AMOUNT, * FROM PS_EX_SHEET_LINE WHERE SHEET_ID ='0000119627'

SELECT TXN_AMOUNT,MONETARY_AMOUNT,  * FROM PS_EX_SHEET_DIST WHERE SHEET_ID ='0000119627'

TXN_AMOUNT becomes FOREIGN_AMOUNT for EX_ACCTG_LINE

SELECT  FOREIGN_AMOUNT,MONETARY_AMOUNT,  * FROM PS_EX_ACCTG_LINE WHERE EX_DOC_ID ='0000119627' and JOURNAL_ID ='EXP0177281'

FOREIGN_AMOUNT <> MONETARY_AMOUNT for Journal Line

SELECT FOREIGN_AMOUNT,MONETARY_AMOUNT,* FROM PS_JRNL_LN

Tagged:

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