运行Retrieve time from OTL（RCVOTLR） 请求时，出现错误RCV_OTL_GNRET_PROCESS_RUNNING

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
+---------------------------------------------------------------------------+
Purchasing: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

RCVOTLR module: Retrieve Time from OTL
+---------------------------------------------------------------------------+

Current system time is 24-DEC-2013 12:58:45

+---------------------------------------------------------------------------+

**Starts**24-DEC-2013 12:58:45
**Ends**24-DEC-2013 12:58:46
Your request could not complete because an earlier request is still being processed. Either submit your request later, or contact your system administrator.


+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+

1
2
3
SELECT * 
FROM fnd_new_messages 
WHERE message_text LIKE 'Your request could not complete because an earlier request is still being processed%'

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
        BEGIN
            g_generic_start := SYSDATE;

            HXC_INTEGRATION_LAYER_V1_GRP.Execute_Retrieval_Process(
                        P_Process          => 'Purchasing Retrieval Process',
                        P_Transaction_code => NULL,
                        P_Start_Date       => l_start_date,
                        P_End_Date         => l_end_date,
                        P_Incremental      => 'Y',
                        P_Rerun_Flag       => 'N',
                        P_Where_Clause     => l_where_clause,
                        P_Scope            => 'DAY',
                        P_Clusive          => 'EX');

            g_generic_stop := SYSDATE;
            g_generic_time := g_generic_time + (g_generic_stop - g_generic_start);
        EXCEPTION
            WHEN OTHERS THEN
                RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
                              , module => l_log_head
                              , message => 'Generic Retrieval failed: ' || SQLERRM
                              );
                IF SQLERRM like 'ORA-20001: HXC_0013_GNRET_NO_BLD_BLKS%' OR
                   SQLERRM like 'ORA-20001: HXC_0012_GNRET_NO_TIMECARDS%' THEN
                    G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_GNRET_NO_TIMECARDS')
                                             || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
                    RAISE SUCCESS_SHORT_CIRCUIT;
                ELSIF SQLERRM like 'ORA-20001: HXC_0017_GNRET_PROCESS_RUNNING%' THEN
                    G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_GNRET_PROCESS_RUNNING')
                                             || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
                END IF;

                RAISE GENERIC_RETRIEVAL_FAILED;
        END;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
   EXCEPTION
      WHEN e_retrieval_not_registered
      THEN
         fnd_message.set_name ('HXC', 'HXC_0011_GNRET_NOT_REGISTERED');
         fnd_message.raise_error;
      WHEN e_process_already_running
      THEN
         fnd_message.set_name ('HXC', 'HXC_0017_GNRET_PROCESS_RUNNING');
         fnd_message.raise_error;
      WHEN e_no_ranges
      THEN
         fnd_message.set_name ('HXC', 'HXC_0012_GNRET_NO_TIMECARDS');
         fnd_message.raise_error;
      WHEN OTHERS

1
2
3
4
5
6
7
8
9
10
               IF NOT check_concurrency_ok
                                  (p_process_id             => g_retrieval_process_id,
                                   p_retrieval_process      => g_params.p_process,
                                   p_where_clause           => g_params.p_where_clause,
                                   p_unique_params          => g_params.p_unique_params
                                  )
               THEN
                  RAISE e_process_already_running;
               END IF;

1
2
3
4
5
         SELECT rtr.retrieval_process_id, rtr.time_recipient_id,
                rtr.mapping_id
           FROM hxc_retrieval_processes rtr
          WHERE rtr.NAME = 'Purchasing Retrieval Process'

1
2
3
4
5
6
7
8
         CURSOR chk_transaction
         IS
            SELECT transaction_id
              FROM hxc_transactions tx
             WHERE transaction_process_id = p_process_id
               AND status = 'IN PROGRESS';