适用于:
Oracle Receivables - Version: 12.0.0 and later [Release: 12.0 and later ]
Information in this document applies to any platform.
arxtrx.odf - AR_BOE_REMIT_RECEIPTS_CBUNR_V
症状:
当时图创建汇款时,收支无法显示在汇款栏。
在进行以下操作时会出现这样的问题:
1.创建一个订单
2.创建汇款,选择收据,并保存
3.关闭和打开窗体 - >重新查询批次 - >在收据上点击 - >收据 没有汇款订单
原因
Bug 12831629 - UNABLE TO SEE REMITTED RECEIPTS.
IBY tables are not having proper outer join and they have eq. join
解决方案
核实后,加入在视图定义“AR_BOE_REMIT_RECEIPTS_CBUNR_V”
select * from all_views where view_name i='AR_BOE_REMIT_RECEIPTS_CBUNR_V';
“x.payment_channel_code= p.payment_channel_code”应该替换为
x.payment_channel_code p.payment_channel_code(+)
做完调试后重新测试