Difference between interface and conversion in oracle apps

legacy system:
****************
System other than oracle is legacy system.
Ex:Spread sheet.

Interface:
***********
1)It is a program to transfer the data from one location to another location.
2)Interface is used to transfer the data from legacy system to oracle system.

Interfaces  are 2 types
1)Inbound interface: These interfaces are used to transfer the data from external system to oracle applications.
2)outbound interface:These interfaces are used to transfer the data from oracle applications to external systems.

Conversion:
************
Conversion is to bring the data from other(non-oracle apps) system to oracle application system.
Conversion is receiving the data from legacy system.


difference between interface and conversion in oracle apps
**************************************************************
INTERFACE:-
***********
IT IS A PROGRAM TO TRANSFER THE DATA FROM ONE LOCATION TO ANOTHER
LOCATION.
-->Interface is post production which is performed once before process.
-->interface is the integration of only(one way process)two systems.
-->interface is periodical process...
->IT IS SCHEDULED CONCURRENT PROCESS TO EXECUTED MULTIPLE TIMES
->WE WILL NOT BE KNOWING FLAT FILE VOLUME
->WE NEED TO HANDLE ALL EXPECTED EXCEPTIONS
->USED IN ENHANCEMENT,CUSTOMIZATION PROJECTS.


CONVERSION :-
****************
IT IS A PROGRAM
->IT IS ONE TIME DATA TRANSFER
-->it is one-time process.
-->data comes into oracle applications.
->WE WILL BE KNOWING THE VOLUME OF THE FLAT FILE
->NO NEED KNOW ALL EXCEPTIONS
->THIS IS USED IN UPGRADING,MIGRATION PROJECTS.


1)Open Interface: If the interface logic is provided by oracle applications,it is called Open interface.
******************
2)Custom Interface: If the interface logic is need to be developed by the implementation team, it is called Custom Interface.
********************

ORA-01861: literal does not match format string

ORA-01861: literal does not match format string

For any Concurrent Program date parameter in Oracle Apps, we assign FND_STANDARD_DATE Value Set having length 11. This value set always pass date in below format to your program

YYYY/MM/DD

If the date format of your program (Report or PL/SQL Procedure) does not matches with above format, it will always throw below error in log file

ORA-01861: literal does not match format string

Below are the steps to resolve this error with different Program Type

Oracle Reports Type Program

Define user parameter for Date in RDF with below property details

Datatype- Date
Width- 20
Input Mask- RRRR/MM/DD HH24:MI:SS


PL/SQL Stored Procedure Type Program

1) Always use errbuf and retcode as first two OUT parameters in your procedure

2) Define the Date parameters with datatype VARCHAR2 in procedure

3) Use fnd_date.canonical_to_date to convert varchar2 format to oracle date format (DD-MON-YY) and then use it anywhere in a program

Below is an example for the same

CREATE OR REPLACE PROCEDURE APPS.TEST_TRANSFER
( p_errbuf OUT VARCHAR2
,p_retcode OUT VARCHAR2
,p_from_date VARCHAR2
,p_to_date VARCHAR2 )
IS
v_from_date DATE;
v_to_date DATE;
BEGIN
v_from_date := fnd_date.canonical_to_date (p_from_date);
v_to_date := fnd_date.canonical_to_date (p_to_date);