ORA-01861: Text and format strings do not match error handling

ORA-01861: Text and format strings do not match error handling

An error is returned when the following materialized view is created.
Create materialized view BBB
Refresh complete on demand
As
Select a. vbillcode,
B. invname,
Del. exchdate
From AA @ AA
Inner join BB @ BB B on a. id = B. id
Left join CC @ CC del on a. id = del. id
Where a. dbilldae> = '2017-06-15 'and a. vdef7 is not null;

Error:
ORA-01861: Text and format strings do not match
ORA-02063: followed by line (starting from TES)

Analysis:
Query part of the Materialized View

Select a. vbillcode,
B. invname,
Del. exchdate
From AA @ AA
Inner join BB @ BB B on a. id = B. id
Left join CC @ CC del on a. id = del. id
Where a. dbilldae> = '2017-06-15 'and a. vdef7 is not null;

The same error is still reported. Because this query involves four databases (three remote and one local), it may be caused by Environment inconsistency or SQL Execution Environment configuration problems.

Solution
By setting

Alter session set nls_language = 'American ';

Alter session set NLS_LANGUAGE = 'simplified CHINESE ';

The problem is not solved when the query is initiated. Set the time format to try:

Alter session set nls_date_format = 'yyyy-MM-DD HH24: MI: ss ';

When the SQL query is successfully executed, the statement cannot be executed due to a time format problem. It seems that everything may happen.

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or missing Handling Methods

Solution to ORA-00257 archive logs being too large to store