Journals are not being created after running journal generator process.
showing Unique Constraint error in message log.
there is issue becuase of Datetime stamp is different so refer the update statement and execute.
SELECT * FROM ps_dist_ln
WHERE business_unit=22000 AND journal_id=' ' AND asset_id IN( '000000013924' ,'000000013925','000000013926')
AND ACCOUNTING_DT ='30-MAR-2013' AND DTTM_STAMP =to_DATE('04/03/2013 13:13:28','MM/DD/YYYY HH24:MI:SS')
--12 rows selected
UPDATE ps_dist_ln SET ACCOUNTING_DT='31-MAR-2013' , DTTM_STAMP =to_DATE('04/03/2013 19:19:19','MM/DD/YYYY HH24:MI:SS')
WHERE business_unit=22000 AND journal_id=' ' AND asset_id IN( '000000013924' ,'000000013925','000000013926')
AND ACCOUNTING_DT ='30-MAR-2013' AND DTTM_STAMP =to_DATE('04/03/2013 13:13:28','MM/DD/YYYY HH24:MI:SS')
--12 rows updated
After exeution of update statement again run the generate journal process for the same date and you will gat message that 1 journal has been created in messgae log.
showing Unique Constraint error in message log.
there is issue becuase of Datetime stamp is different so refer the update statement and execute.
SELECT * FROM ps_dist_ln
WHERE business_unit=22000 AND journal_id=' ' AND asset_id IN( '000000013924' ,'000000013925','000000013926')
AND ACCOUNTING_DT ='30-MAR-2013' AND DTTM_STAMP =to_DATE('04/03/2013 13:13:28','MM/DD/YYYY HH24:MI:SS')
--12 rows selected
UPDATE ps_dist_ln SET ACCOUNTING_DT='31-MAR-2013' , DTTM_STAMP =to_DATE('04/03/2013 19:19:19','MM/DD/YYYY HH24:MI:SS')
WHERE business_unit=22000 AND journal_id=' ' AND asset_id IN( '000000013924' ,'000000013925','000000013926')
AND ACCOUNTING_DT ='30-MAR-2013' AND DTTM_STAMP =to_DATE('04/03/2013 13:13:28','MM/DD/YYYY HH24:MI:SS')
--12 rows updated
After exeution of update statement again run the generate journal process for the same date and you will gat message that 1 journal has been created in messgae log.
