gistfile1.txt

tws1e=# call xxbrk_import_gl_pkg.gl_import('Broker Receipts', 54872099);
NOTICE:  General Ledger Version:1.00
NOTICE:  Journal Import Process
NOTICE:  Current system time is 26-OCT-2022 09:08:37
NOTICE:  User:xxbrk
NOTICE:  Log file Created with Request ID:194924165
NOTICE:  Inserted Record in GL_INTERFACE_CONTROL for Group_ID:54872099 - Source Name:Broker Receipts
NOTICE:  GL_INTERFACE_CONTROL Interface Run ID:102594591
NOTICE:  GL_INTERFACE_RUN_ID:102594591
NOTICE:  Start validating the records from GL_INTERFACE for Group ID:54872099
NOTICE:  Processing record:(0,5)-Broker Receipts-Broker Receipts-CAD-2022-09-01 00:00:00-201010-HQ0GTT915CAD-0000000000000000000054872099
NOTICE:  Start validating the records from GL_INTERFACE for Group ID:54872099
NOTICE:  Processing record:(0,7)-Broker Receipts-Broker Receipts-USD-2022-09-01 00:00:00-120110-000000000000-0000000000000000000054872099
NOTICE:  Start validating the records from GL_INTERFACE for Group ID:54872099
NOTICE:  Processing record:(0,9)-Broker Receipts-Broker Receipts-CAD-2022-09-01 00:00:00-120110-000000000000-0000000000000000000054872099
NOTICE:  Start validating the records from GL_INTERFACE for Group ID:54872099
NOTICE:  Processing record:(0,11)-Broker Receipts-Broker Receipts-USD-2022-09-01 00:00:00-200100-AP00272P0USD-0000000000000000000054872099
NOTICE:  Start Importing the GLs for Group_ID 54872099
NOTICE:   
NOTICE:  -----------------------------------------------------------------------------------------------------------------------
NOTICE:  Start Creating Journal for Group_ID:54872099  Source:Broker Receipts
NOTICE:  Source            Batch ID            Batch Name                                    Number of Batches      Number of Headers      Number of Lines      Total Amount  DR      Total Amount CR
NOTICE:  Error: While Creating Journals - 23505 - duplicate key value violates unique constraint "gl_je_headers_u2"
NOTICE:  Error: Unable to load the Journal for Group_ID: 54872099 - Source:Broker Receipts