FOREIGN_AMOUNT,MONETARY_AMOUNT are different for an Expense Report in Journal Ln
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