Payables Transfer to General Ledger程序报错

michaelr

Default value for parameter “include_reporting_sob” as below:

select l.meaning from fnd_lookups l,ap_system_parameters asp where l.lookup_type = 'YES_NO' and (( l.lookup_code = 'N' and 'N' = (select asp.include_reporting_sob from ap_system_parameters asp)) OR ( l.lookup_code = 'Y' and 'Y' = (select asp.include_reporting_sob from ap_system_parameters asp ) and ap_gl_transfer_pkg.ap_mc_check(:$FLEX$.set_of_books_id) <> 'R') OR ( l.lookup_code = 'N' and ap_gl_transfer_pkg.ap_mc_check(:$FLEX$.set_of_books_id) = 'R'))

可能还是跟权限的环境变量设置有关，应该从report sob方面查
或者是设置中有启用reporting功能了

Harry_shan

原帖由 michaelr 于 2009-12-12 19:15 发表
Default value for parameter “include_reporting_sob” as below:

select l.meaning from fnd_lookups l,ap_system_parameters asp where l.lookup_type = 'YES_NO' and (( l.lookup_code = 'N' and 'N' = (select asp.include_reporting_sob from ap_system_parameters asp)) OR ( l.lookup_code = 'Y' and 'Y' = (select asp.include_reporting_sob from ap_system_parameters asp ) and ap_gl_transfer_pkg.ap_mc_check(:$FLEX$.set_of_books_id)  'R') OR ( l.lookup_code = 'N' and ap_gl_transfer_pkg.ap_mc_check(:$FLEX$.set_of_books_id) = 'R'))

可能还是跟权限的环境变量设置有关，应该从report sob方面查
或者是设置中有启用reporting功能了

设置中有启用reporting功能
这个哪里看啊？

Harry_shan

原帖由 michaelr 于 2009-12-12 19:15 发表
Default value for parameter “include_reporting_sob” as below:

select l.meaning from fnd_lookups l,ap_system_parameters asp where l.lookup_type = 'YES_NO' and (( l.lookup_code = 'N' and 'N' = (select asp.include_reporting_sob from ap_system_parameters asp)) OR ( l.lookup_code = 'Y' and 'Y' = (select asp.include_reporting_sob from ap_system_parameters asp ) and ap_gl_transfer_pkg.ap_mc_check(:$FLEX$.set_of_books_id)  'R') OR ( l.lookup_code = 'N' and ap_gl_transfer_pkg.ap_mc_check(:$FLEX$.set_of_books_id) = 'R'))

可能还是跟权限的环境变量设置有关，应该从report sob方面查
或者是设置中有启用reporting功能了

有什么建议如何去查看？
两个环境应该设置是一样的