Skip to Main Content
Forums

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

two statements on the same Debtor

PfunzoMar 22 2019 — edited Feb 9 2021

Hi

When our Accounts Receivables prints their statements on oracle it generates two statement on the same customer.

please advise what seems to be happening on oracle in Accounts Receivables when they are getting two statements on the same Debtor.

regards

Pfunzo

Comments

AL.

Have you checked the validation error tab?

BR,

Muhammad Jahanzeb

No error is displaying in the validation tab.

AL.

Have you set the Functional Currency at the specific location?

Muhammad Jahanzeb

Yes

N_Patel

"SQLException: java.sql.SQLException: ORA-12543: TNS:destination host unreachable"

This last line says, the jython execution script had gone into the exception.Your destination EBS GL is not (or no longer) reachable from FDMEE server.

Can you go to the respective source system and try to Test connection again?

Srini+K
Answer

This is oracle client install issue on your FDMEE server.

check using sqlplus if you can login.  if you can not login set the TNS_ADMIN variable to point to location where  TNSNAMES.ora  SQLNET.ora

https://www.ibm.com/support/pages/setting-tnsadmin-environment-variable-requisitepro-when-multiple-oracle-client-version…

Marked as Answer by Muhammad Jahanzeb · Jun 28 2021
1 - 6

Post Details

Added on Mar 22 2019
#general-ebs-discussion
4 comments
66 views