3 Replies Latest reply on Feb 14, 2018 9:10 AM by Beauty_and_dBest

    Our EBS 11i can not insert data to EBS 12.2


      EBS 11i and 12.2

      Databases  9i, 11g, 12c



      Hi ALL,


      We are doing program interface between EBS 11i and EBS 12.2.7

      EBS 11i has 9i database and EBS 12.2.7 has 12c  so we need a bridge 11g database.


      We created dblinks between 9i and 11g;   and  betweeen  11g and 12c.

      When  login to Apps 11i  call a package  to insert data to  12c table via a view which was created in 11g.


      We encountered Error this on the interface program in 9i, 11g, 12c:


      **Starts**14-FEB-2018 01:27:46
      ORACLE error 2069 in FDPSTP

      Cause:  FDPSTP failed due to ORA-02069: global_names parameter must be set to TRUE for this operation
      ORA-06512: at "APPS.XXR11_R12_AP_IFACE_PKG", line 752
      ORA-06512: at "APPS.XXR11_R12_AP_IFACE_PKG", line 700


      When I checked the program, the line with error is inserting data into the ap_invoice_interface of R12 via dblink.

      INSERT INTO R12_ap_invoices_interface_v@o9i_to_o11g



      Please help...



      Kind regards,