SELECT * FROM user_errors;

SQL>
SQL> SELECT * FROM user_errors where name='CEE_EFACTS_PIE_ORDER_V';

NAME                           TYPE           SEQUENCE       LINE   POSITION
------------------------------ ------------ ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE MESSAGE_NUMBER
--------- --------------
CEE_EFACTS_PIE_ORDER_V         VIEW                  1          0          0
ORA-01775: looping chain of synonyms
ERROR                  0

SQL> CREATE OR REPLACE FORCE VIEW jam.cee_efacts_pie_order_v (cenumber,
  2    2                                                           installationid,
  3    3                                                           areanumber,
  4    4                                                           clli,
  5    5                                                           servicedate,
  6    6                                                           forecasttype,
  7    7                                                           jobid,
  8    8                                                           shippriority,
  9    9                                                           installationcomment,
 10   10                                                           shippingnotes,
 11   11                                                           action,
 12   12                                                           ceitemnumber,
 13   13                                                           heci,
 14   14                                                           quantity,
 15   15                                                           frc,
 16   16                                                           shippingnoticenumber,
 17   17                                                           requestdate,
 18   18                                                           shipmentdate,
 19   19                                                           receiveddate,
 20   20                                                           status,
 21   21                                                           action_heci
 22   22                                                          )
 23   23  AS
 24   24     SELECT ord.ord_nbr, NVL (oa.efacts_ticket, 0),
 25   25            ord.eg_gloc_lent_id || ord.eg_gloc_code, oa.clli, oa.req_srvc_date,
 26   26            oa.forecast_type, ord.opeds_job_nbr,
 27   27            NVL (frcoi.premium_transport, 'N'), oa.scope_of_work, NULL,
 28   28            DECODE (oa.efacts_ticket, NULL, 'A', 'C'), frcoi.frcoi_nbr,
 29   29            nm.mt_pid_segment3, frcoi.qty,
 30   30            frcoi.frc_asset_type_code || frcoi.frc_wrkt_kow, 'UNKNOWN', SYSDATE,
 31   31            oa.matl_ship_date, NULL, 'FORECAST', od.work_id_act
 32   32       FROM jam_orders ord,
 33   33            jam_order_appendixes oa,
 34   34            jam_frc_order_items frcoi,
 35   35            jam_nh_materials nm,
 36   36            cee_ospcm_details od,
 37   37            cee_ord_bb_items obi
 38   38      WHERE ord.ord_nbr = oa.ord_nbr
 39   39        AND ord.current_appndx = oa.ord_appndx
 40   40        AND frcoi.ord_nbr = oa.ord_nbr
 41   41        AND frcoi.ord_appndx = oa.ord_appndx
 42   42        AND frcoi.ord_nbr = od.ord_nbr
 43   43        AND frcoi.ord_appndx = od.ord_appndx
 44   44        AND frcoi.frcoi_nbr = od.frcoi_nbr
 45   45        AND nm.mt_pid = frcoi.mt_pid
 46   46        AND frcoi.ord_nbr = obi.ord_nbr
 47   47        AND frcoi.ord_appndx = obi.ord_appndx
 48   48        AND frcoi.frcoi_nbr = obi.frcoi_nbr
 49   49        AND obi.efacts_sent IS NULL
 50   50        AND UPPER (nm.material_type) = 'PLUG-IN';
  2                                                           installationid,
  *
ERROR at line 2:
ORA-00904: : invalid identifier