Oracle GL Document Sequence Copy From Old Year

最新推荐文章于 2025-07-17 14:38:53 发布
最新推荐文章于 2025-07-17 14:38:53 发布
阅读量235 收藏
点赞数
文章标签： 数据库
本文介绍了一个用于将GL文档序列从一个财年复制到另一个财年的过程，包括处理完整年度记录和非完整年度记录的情况。通过定义特定的参数和执行相应的程序，可以实现自动化的文档序列复制。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

CREATE OR REPLACE PACKAGE GLGENSEQ_BG_1 AS
/**********************************************************/
/** This package is used for Copy GL document sequence to New Fin year
  P_COPY_FR_YEAR and P_COPY_TO_YEAR are FIN period year
  Exp:Copy from 2011 --&gt2012
  2011 year :01-APR-2011 to 31-MAR-2012  ,
  2012 year :01-APR-2012 to 31-MAR-2013  ,
**/
/**********************************************************/
/**                                                      **/
/**********************************************************/
    V_COPY_FR_YEAR VARCHAR2(10); --2012
    V_COPY_TO_YEAR VARCHAR2(10); --2013
    v_count_defin  number := 0;
    v_count_assig  number := 0;
    v_count        number;
    v_year         number;
    v_use_id  number:=fnd_profile.value('USER_ID');
PROCEDURE MAIN(ERRBUF         OUT varchar2,
                                          RETCODE        OUT number,
                                          P_COPY_FR_YEAR in VARCHAR2,
                                          P_COPY_TO_YEAR in VARCHAR2);
PROCEDURE COPY_NORMAL_SEQ(
                                          P_COPY_FR_YEAR in VARCHAR2,
                                          P_COPY_TO_YEAR in VARCHAR2);
PROCEDURE COPY_SPEC_SEQ(
                                          P_COPY_FR_YEAR in VARCHAR2,
                                          P_COPY_TO_YEAR in VARCHAR2);
End GLGENSEQ_BG_1;
 
CREATE OR REPLACE PACKAGE BODY GLGENSEQ_BG_1 AS
  PROCEDURE MAIN(ERRBUF         OUT varchar2,
                 RETCODE        OUT number,
                 P_COPY_FR_YEAR in VARCHAR2,
                 P_COPY_TO_YEAR in VARCHAR2) is
  begin
    V_COPY_FR_YEAR := P_COPY_FR_YEAR;
    V_COPY_TO_YEAR := P_COPY_TO_YEAR;
    v_year         := to_number(P_COPY_TO_YEAR) - to_number(P_COPY_FR_YEAR);
    --check data--
    SELECT count(*)
      into v_count
      FROM FND_DOCUMENT_SEQUENCES
     WHERE START_DATE = (select p.start_date
                           from GL_LEDGERS sob, GL_PERIODS_V p
                          where sob.ledger_id = 302
                            and p.period_set_name = sob.period_set_name
                            and p.period_year = P_COPY_TO_YEAR
                            and p.period_num = 1)
     order by name;
    if v_count = 0 then
      --check data--
      
      COPY_SPEC_SEQ(V_COPY_FR_YEAR, V_COPY_TO_YEAR);
      dbms_output.put_line('The year ' || P_COPY_TO_YEAR || '''' ||
                           's Document Sequence was Finished, It copy from ' ||
                           P_COPY_FR_YEAR || '!');
      dbms_output.put_line('Created Document Sequence: ' || v_count_defin ||
                           ' rows!');
      dbms_output.put_line('Assigned Document Sequence: ' || v_count_assig ||
                           ' rows!');
      fnd_file.put_line(fnd_file.output,
                        'The year ' || P_COPY_TO_YEAR || '''' ||
                        's Document Sequence was Finished, It copy from ' ||
                        P_COPY_FR_YEAR || '!');
      fnd_file.put_line(fnd_file.output,
                        'Created Document Sequence: ' || v_count_defin ||
                        ' rows!');
      fnd_file.put_line(fnd_file.output,
                        'Assigned Document Sequence: ' || v_count_assig ||
                        ' rows!');
    else
      dbms_output.put_line('The year ' || P_COPY_TO_YEAR || '''' ||
                           's Document Sequence already exists, Pls enter other year!');
      fnd_file.put_line(fnd_file.output,
                        'The year ' || P_COPY_TO_YEAR || '''' ||
                        's Document Sequence already exists, Pls enter other year!');
    end if;
    commit;
  EXCEPTION
    WHEN others THEN
      fnd_file.put_line(fnd_file.output,
                        'The year ' || P_COPY_TO_YEAR || '''' ||
                        's Document Sequence Creating with error!');
      dbms_output.put_line('The year ' || P_COPY_TO_YEAR || '''' ||
                           's Document Sequence Creating with error!');
      ROLLBACK;
  end;
  PROCEDURE COPY_NORMAL_SEQ(P_COPY_FR_YEAR in VARCHAR2,
                            P_COPY_TO_YEAR in VARCHAR2) is
    /**This procedure used for get whole year records */
    --declare  --
    CURSOR C_GL_DOC_SEQ(x_year varchar2) is
      select F.NAME,
             REGEXP_REPLACE(f.NAME, SUBSTR(f.NAME, -4, 4), null, 1, 1) seq_prefix,
             F.START_DATE,
             F.END_DATE,
             F.TYPE,
             F.MESSAGE_FLAG,
             F.INITIAL_VALUE,
             F.AUDIT_TABLE_NAME,
             F.DB_SEQUENCE_NAME,
             F.TABLE_NAME,
             F.DOC_SEQUENCE_ID,
             F.DOC_SEQUENCE_ID OLD_DOC_SEQUENCE_ID,
             F.LAST_UPDATE_DATE,
             F.LAST_UPDATED_BY,
             F.CREATION_DATE,
             F.CREATED_BY,
             F.LAST_UPDATE_LOGIN,
             F.APPLICATION_ID,
             (select p.period_num
                from GL_LEDGERS sob, GL_PERIODS_V p
               where sob.ledger_id = 302
                 and p.period_set_name = sob.period_set_name
                 and p.period_year = x_year
                 and p.START_DATE = F.START_DATE) period_num
        from FND_DOCUMENT_SEQUENCES f
       where F.DOC_SEQUENCE_ID in
             (SELECT distinct A.DOC_SEQUENCE_ID
                FROM FND_DOC_SEQUENCE_ASSIGNMENTS A
               WHERE A.START_DATE between
                     (select p.start_date
                        from GL_LEDGERS sob, GL_PERIODS_V p
                       where sob.ledger_id = 302
                         and p.period_set_name = sob.period_set_name
                         and p.period_year = x_year
                         and p.period_num = 1)
                 and (select p.START_DATE
                        from GL_LEDGERS sob, GL_PERIODS_V p
                       where sob.ledger_id = 302
                         and p.period_set_name = sob.period_set_name
                         and p.period_year = x_year
                         and p.period_num = 12)
                 and a.end_DATE = last_day(a.START_DATE)
                 and a.end_DATE <> a.START_DATE)
         and REGEXP_REPLACE(f.NAME, SUBSTR(f.NAME, -4, 4), null, 1, 1) in
             (select seq_prefix
                from (SELECT NAME,
                             REGEXP_REPLACE(NAME,
                                            SUBSTR(NAME, -4, 4),
                                            null,
                                            1,
                                            1) seq_prefix,
                             START_DATE,
                             END_DATE,
                             TYPE,
                             MESSAGE_FLAG,
                             INITIAL_VALUE,
                             AUDIT_TABLE_NAME,
                             DB_SEQUENCE_NAME,
                             TABLE_NAME,
                             DOC_SEQUENCE_ID OLD_DOC_SEQUENCE_ID,
                             LAST_UPDATE_DATE,
                             LAST_UPDATED_BY,
                             CREATION_DATE,
                             CREATED_BY,
                             LAST_UPDATE_LOGIN,
                             APPLICATION_ID
                        FROM FND_DOCUMENT_SEQUENCES
                       WHERE DOC_SEQUENCE_ID in
                             (SELECT distinct A.DOC_SEQUENCE_ID
                                FROM FND_DOC_SEQUENCE_ASSIGNMENTS A
                               WHERE A.START_DATE between
                                     (select p.start_date
                                        from GL_LEDGERS sob, GL_PERIODS_V p
                                       where sob.ledger_id = 302
                                         and p.period_set_name =
                                             sob.period_set_name
                                         and p.period_year = x_year
                                         and p.period_num = 1)
                                 and (select p.START_DATE
                                        from GL_LEDGERS sob, GL_PERIODS_V p
                                       where sob.ledger_id = 302
                                         and p.period_set_name =
                                             sob.period_set_name
                                         and p.period_year = x_year
                                         and p.period_num = 12)
                                 and a.end_DATE = last_day(a.START_DATE)
                                 and a.end_DATE <> a.START_DATE --add_months(a.START_DATE, 1) - 1
                              )
                      -- and NAME like 'BTCLR AR CHECK%'
                       order by name) seq
               where 1 = 1
               group by seq.seq_prefix
              having count(seq.seq_prefix) = 12)
       order by f.name;
    /*
    CURSOR C_GL_DOC_ASSIG(x_year varchar2, X_OLD_DOC_SEQUENCE_ID number) is
          SELECT A.ROWID,
                 A.METHOD_CODE,
                 A.START_DATE,
                 A.END_DATE,
                 A.SET_OF_BOOKS_ID,
                 A.CREATION_DATE,
                 A.CATEGORY_CODE,
                 A.CREATED_BY,
                 A.LAST_UPDATE_DATE,
                 A.LAST_UPDATED_BY,
                 A.LAST_UPDATE_LOGIN,
                 -- DOC_SEQUENCE_ID,
                 A.APPLICATION_ID,
                 A.DOC_SEQUENCE_ASSIGNMENT_ID
            FROM FND_DOC_SEQUENCE_ASSIGNMENTS A
           WHERE A.Doc_Sequence_Id = X_OLD_DOC_SEQUENCE_ID
             and A.START_DATE between
                 (select p.start_date
                    from GL_LEDGERS sob, GL_PERIODS_V p
                   where sob.ledger_id = 302
                     and p.period_set_name = sob.period_set_name
                     and p.period_year = x_year
                     and p.period_num = 1)
             and (select p.START_DATE
                    from GL_LEDGERS sob, GL_PERIODS_V p
                   where sob.ledger_id = 302
                     and p.period_set_name = sob.period_set_name
                     and p.period_year = x_year
                     and p.period_num = 12)
             and a.END_DATE = last_day(a.START_DATE)
             and a.END_DATE <> a.START_DATE
          -- AND SET_OF_BOOKS_ID=502
           order by APPLICATION_ID,
                    SET_OF_BOOKS_ID,
                    CATEGORY_CODE,
                    METHOD_CODE,
                    START_DATE;
      */
    ----
    CURSOR c_3(x_year varchar2, x_seq_prefix varchar2) is
      select seq_prefix,
             METHOD_CODE,
             SET_OF_BOOKS_ID,
             CATEGORY_CODE,
             APPLICATION_ID
        from (SELECT A.METHOD_CODE,
                     A.START_DATE,
                     A.END_DATE,
                     A.SET_OF_BOOKS_ID,
                     A.CREATION_DATE,
                     A.CATEGORY_CODE,
                     A.CREATED_BY,
                     A.LAST_UPDATE_DATE,
                     A.LAST_UPDATED_BY,
                     A.LAST_UPDATE_LOGIN,
                     -- DOC_SEQUENCE_ID,
                     F.NAME,
                     REGEXP_REPLACE(F.NAME,
                                    SUBSTR(F.NAME, -4, 4),
                                    null,
                                    1,
                                    1) seq_prefix,
                     A.APPLICATION_ID,
                     A.DOC_SEQUENCE_ASSIGNMENT_ID
                FROM FND_DOC_SEQUENCE_ASSIGNMENTS A,
                     FND_DOCUMENT_SEQUENCES       F
               WHERE A.Doc_Sequence_Id = F.DOC_SEQUENCE_ID
                 and REGEXP_REPLACE(F.NAME,
                                    SUBSTR(F.NAME, -4, 4),
                                    null,
                                    1,
                                    1) = x_seq_prefix --'BITLR AR RMA BEWX '
                 and A.START_DATE between
                     (select p.start_date
                        from GL_LEDGERS sob, GL_PERIODS_V p
                       where sob.ledger_id = 302
                         and p.period_set_name = sob.period_set_name
                         and p.period_year = x_year
                         and p.period_num = 1)
                 and (select p.START_DATE
                        from GL_LEDGERS sob, GL_PERIODS_V p
                       where sob.ledger_id = 302
                         and p.period_set_name = sob.period_set_name
                         and p.period_year = x_year
                         and p.period_num = 12)
                 and a.END_DATE = last_day(a.START_DATE)
                 and a.END_DATE <> a.START_DATE
               order by F.name) Seq
       where 1 = 1
       group by seq_prefix,
                METHOD_CODE,
                SET_OF_BOOKS_ID,
                CATEGORY_CODE,
                APPLICATION_ID
      /*having count(seq.seq_prefix) = 12*/
      ;
    --Assgin templete with 12 records --
    CURSOR C_GL_DOC_ASSIG(x_year            varchar2,
                          x_seq_prefix      varchar2,
                          x_METHOD_CODE     varchar2,
                          x_SET_OF_BOOKS_ID number,
                          x_CATEGORY_CODE   varchar2,
                          x_APPLICATION_ID  number,
                          x_START_DATE      date,
                          x_END_DATE        date) is
      select nvl(Seq.METHOD_CODE, x_METHOD_CODE) METHOD_CODE,
             nvl(seq.START_DATE, period.START_DATE) START_DATE,
             nvl(seq.END_DATE, period.END_DATE) END_DATE,
             nvl(Seq.SET_OF_BOOKS_ID, x_SET_OF_BOOKS_ID) SET_OF_BOOKS_ID,
             nvl(Seq.CATEGORY_CODE, x_CATEGORY_CODE) CATEGORY_CODE,
             nvl(seq.LAST_UPDATE_DATE, sysdate),
             nvl(seq.LAST_UPDATED_BY, 1),
             nvl(seq.CREATION_DATE, sysdate),
             nvl(seq.CREATED_BY, 1),
             nvl(seq.LAST_UPDATE_LOGIN, 1),
             nvl(seq.APPLICATION_ID, x_APPLICATION_ID) APPLICATION_ID,
             Seq.DOC_SEQUENCE_ASSIGNMENT_ID
        from (select p.period_num, p.START_DATE, p.end_DATE
                from GL_LEDGERS sob, GL_PERIODS_V p
               where sob.ledger_id = 302
                 and p.period_set_name = sob.period_set_name
                 and p.period_year = x_year
                 and p.period_num <> 13) period,
             (SELECT A.ROWID,
                     A.METHOD_CODE,
                     A.START_DATE,
                     A.END_DATE,
                     A.SET_OF_BOOKS_ID,
                     A.CREATION_DATE,
                     A.CATEGORY_CODE,
                     A.CREATED_BY,
                     A.LAST_UPDATE_DATE,
                     A.LAST_UPDATED_BY,
                     A.LAST_UPDATE_LOGIN,
                     -- DOC_SEQUENCE_ID,
                     F.NAME,
                     REGEXP_REPLACE(F.NAME,
                                    SUBSTR(F.NAME, -4, 4),
                                    null,
                                    1,
                                    1) seq_prefix,
                     A.APPLICATION_ID,
                     A.DOC_SEQUENCE_ASSIGNMENT_ID
                FROM FND_DOC_SEQUENCE_ASSIGNMENTS A,
                     FND_DOCUMENT_SEQUENCES       F
               WHERE A.Doc_Sequence_Id = F.DOC_SEQUENCE_ID
                 and A.START_DATE between
                     (select p.start_date
                        from GL_LEDGERS sob, GL_PERIODS_V p
                       where sob.ledger_id = 302
                         and p.period_set_name = sob.period_set_name
                         and p.period_year = x_year
                         and p.period_num = 1)
                 and (select p.START_DATE
                        from GL_LEDGERS sob, GL_PERIODS_V p
                       where sob.ledger_id = 302
                         and p.period_set_name = sob.period_set_name
                         and p.period_year = x_year
                         and p.period_num = 12)
                 and a.END_DATE = last_day(a.START_DATE)
                 and a.END_DATE <> a.START_DATE
                 and REGEXP_REPLACE(F.NAME,
                                    SUBSTR(F.NAME, -4, 4),
                                    null,
                                    1,
                                    1) = x_seq_prefix
                 and A.SET_OF_BOOKS_ID =
                     nvl(X_SET_OF_BOOKS_ID, A.SET_OF_BOOKS_ID)
                 and A.APPLICATION_ID =
                     nvl(x_APPLICATION_ID, A.APPLICATION_ID)
                 and A.METHOD_CODE = nvl(x_METHOD_CODE, A.METHOD_CODE)
                 and A.CATEGORY_CODE = nvl(x_CATEGORY_CODE, A.CATEGORY_CODE)) Seq
       where seq.start_date(+) = period.START_DATE
         and period.START_DATE = x_START_DATE
         and period.END_DATE = x_END_DATE
       order by period.period_num;
    --Assgin templete with 12 records --
    V_DOC_SEQUENCE_ID  FND_DOCUMENT_SEQUENCES.DOC_SEQUENCE_ID%type;
    V_SEQUENCE_NAME    FND_DOCUMENT_SEQUENCES.NAME%type;
    V_DB_SEQUENCE_NAME FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%type;
    v_Start_Date    FND_DOCUMENT_SEQUENCES.START_DATE%type;
    v_end_Date      FND_DOCUMENT_SEQUENCES.END_DATE%type;
    v_INITIAL_VALUE FND_DOCUMENT_SEQUENCES.Initial_Value%type;
    V_DOC_SEQUENCE_ASSIGNMENT_ID FND_DOC_SEQUENCE_ASSIGNMENTS.Doc_Sequence_Assignment_Id%type;
    V_CATEGORY_CODE FND_DOC_SEQUENCE_ASSIGNMENTS.CATEGORY_CODE%type;
    V_SOB_ID        FND_DOC_SEQUENCE_ASSIGNMENTS.SET_OF_BOOKS_ID%type;
    GL_DOC_SEQ   C_GL_DOC_SEQ %rowtype;
    cur_3        C_3 %rowtype;
    GL_DOC_ASSIG C_GL_DOC_ASSIG %rowtype;
  begin
    dbms_output.put_line('Part1:Processing that with whole year define records document!');
    fnd_file.put_line(fnd_file.output,
                      'Part1:Processing that with whole year define records document!');
    for GL_DOC_SEQ in C_GL_DOC_SEQ(V_COPY_FR_YEAR) loop
      EXIT WHEN C_GL_DOC_SEQ%NOTFOUND;
      v_count_defin := v_count_defin + 1;
      /*  dbms_output.put_line('Part1:Processing that with whole year records document,Seq prefix:'||GL_DOC_SEQ.seq_prefix);
         fnd_file.put_line(fnd_file.output,
                           'Part1:Processing that with whole year records document,Seq prefix:'||GL_DOC_SEQ.seq_prefix);
      */
      select FND_DOCUMENT_SEQUENCES_S.nextval,
             REGEXP_REPLACE(GL_DOC_SEQ.NAME,
                            SUBSTR(GL_DOC_SEQ.NAME, -4, 2),
                            to_char(add_months(GL_DOC_SEQ.START_DATE,
                                               v_year * 12),
                                    'YY'),
                            1,
                            1),
             add_months(GL_DOC_SEQ.START_DATE, v_year * 12),
             add_months(GL_DOC_SEQ.END_DATE, v_year * 12),
             SUBSTR(GL_DOC_SEQ.INITIAL_VALUE, 1, 1) ||
             to_char(add_months(GL_DOC_SEQ.START_DATE, v_year * 12), 'YY') ||
             to_char(add_months(GL_DOC_SEQ.START_DATE, v_year * 12), 'MM') ||
             SUBSTR(GL_DOC_SEQ.INITIAL_VALUE, 6)
        into V_DOC_SEQUENCE_ID,
             V_SEQUENCE_NAME,
             V_START_DATE,
             V_END_DATE,
             v_INITIAL_VALUE
        from SYS.DUAL;
      V_DB_SEQUENCE_NAME := 'FND_DOC_SEQ_' ||
                           /*app_number.number_to_canonical*/
                            (V_DOC_SEQUENCE_ID) || '_S';
      -- Calls FND_SEQNUM.create_db_seq routine to create DB sequences
        -- new automatic Doc_Seq numbers.
        FND_SEQNUM.create_db_seq( V_DB_SEQUENCE_NAME, v_INITIAL_VALUE );
      --Bug--
      INSERT INTO FND_DOCUMENT_SEQUENCES
        (NAME,
         START_DATE,
         END_DATE,
         TYPE,
         MESSAGE_FLAG,
         INITIAL_VALUE,
         AUDIT_TABLE_NAME,
         DB_SEQUENCE_NAME,
         TABLE_NAME,
         DOC_SEQUENCE_ID,
         LAST_UPDATE_DATE,
         LAST_UPDATED_BY,
         CREATION_DATE,
         CREATED_BY,
         LAST_UPDATE_LOGIN,
         APPLICATION_ID)
      VALUES
        (V_SEQUENCE_NAME,
         V_START_DATE,
         V_END_DATE,
         GL_DOC_SEQ.TYPE,
         GL_DOC_SEQ.MESSAGE_FLAG,
         V_INITIAL_VALUE,
         GL_DOC_SEQ.AUDIT_TABLE_NAME,
         V_DB_SEQUENCE_NAME,
         GL_DOC_SEQ.TABLE_NAME,
         V_DOC_SEQUENCE_ID,
         SYSDATE,
         v_use_id,
         SYSDATE,
         v_use_id,
         v_use_id,
         GL_DOC_SEQ.APPLICATION_ID);
      /*dbms_output.put_line('OLD ID:' || GL_DOC_SEQ.OLD_DOC_SEQUENCE_ID);
      dbms_output.put_line('NEW ID:' || v_DOC_SEQUENCE_ID);*/
      /*---2. Assign Doc--
      for GL_DOC_ASSIG in C_GL_DOC_ASSIG(V_COPY_FR_YEAR,
                                         GL_DOC_SEQ.OLD_DOC_SEQUENCE_ID) loop
        EXIT WHEN C_GL_DOC_ASSIG%NOTFOUND;
        v_count_assig := v_count_assig + 1;
        select FND_DOC_SEQUENCE_ASSIGNMENTS_S.NEXTVAL,
               add_months(GL_DOC_ASSIG.START_DATE, v_year * 12),
               add_months(GL_DOC_ASSIG.END_DATE, v_year * 12)
          into V_DOC_SEQUENCE_ASSIGNMENT_ID, V_START_DATE, V_END_DATE
          from SYS.DUAL;*/
      ---2. Assign Doc--
      for cur_3 in C_3(V_COPY_FR_YEAR, GL_DOC_SEQ.seq_prefix) loop
        EXIT WHEN C_3%NOTFOUND;
        for GL_DOC_ASSIG in C_GL_DOC_ASSIG(V_COPY_FR_YEAR,
                                           cur_3.seq_prefix,
                                           cur_3.METHOD_CODE,
                                           cur_3.SET_OF_BOOKS_ID,
                                           cur_3.CATEGORY_CODE,
                                           cur_3.application_id,
                                           GL_DOC_SEQ.START_DATE,
                                           GL_DOC_SEQ.END_DATE) loop
          EXIT WHEN C_GL_DOC_ASSIG%NOTFOUND;
          v_count_assig := v_count_assig + 1;
          select FND_DOC_SEQUENCE_ASSIGNMENTS_S.NEXTVAL,
                 add_months(GL_DOC_ASSIG.START_DATE, v_year * 12),
                 add_months(GL_DOC_ASSIG.END_DATE, v_year * 12)
            into V_DOC_SEQUENCE_ASSIGNMENT_ID, V_START_DATE, V_END_DATE
            from SYS.DUAL;
          --  dbms_output.put_line('Assign Category Code:'||GL_DOC_ASSIG.CATEGORY_CODE);
          insert into FND_DOC_SEQUENCE_ASSIGNMENTS
            (METHOD_CODE,
             START_DATE,
             END_DATE,
             SET_OF_BOOKS_ID,
             CREATION_DATE,
             CATEGORY_CODE,
             CREATED_BY,
             LAST_UPDATE_DATE,
             LAST_UPDATED_BY,
             LAST_UPDATE_LOGIN,
             DOC_SEQUENCE_ID,
             APPLICATION_ID,
             DOC_SEQUENCE_ASSIGNMENT_ID)
          VALUES
            (null,
             V_START_DATE,
             V_END_DATE,
             GL_DOC_ASSIG.SET_OF_BOOKS_ID,
             sysdate,
             GL_DOC_ASSIG.CATEGORY_CODE,
             v_use_id,
             sysdate,
             v_use_id,
             v_use_id,
             v_DOC_SEQUENCE_ID,
             GL_DOC_ASSIG.APPLICATION_ID,
             V_DOC_SEQUENCE_ASSIGNMENT_ID);
        END LOOP;
      END LOOP;
    END LOOP;
  end;
  ---
  PROCEDURE COPY_SPEC_SEQ(P_COPY_FR_YEAR in VARCHAR2,
                          P_COPY_TO_YEAR in VARCHAR2) is
    /**This procedure used for get without whole year records
    Some companies not created whole year records when
    copy to new year we need creat whole year 's document records,
    */
    CURSOR c_1(x_year varchar2) is
    select seq_prefix,
       TYPE,
       value_type,
       AUDIT_TABLE_NAME,
       MESSAGE_FLAG,
       APPLICATION_ID
  from (SELECT NAME,
               REGEXP_REPLACE(NAME, SUBSTR(NAME, -4, 4), null, 1, 1) seq_prefix,
               START_DATE,
               END_DATE,
               TYPE,
               MESSAGE_FLAG,
               INITIAL_VALUE,
               substr(INITIAL_VALUE, 1, 1) value_type,
               AUDIT_TABLE_NAME,
               DB_SEQUENCE_NAME,
               TABLE_NAME,
               DOC_SEQUENCE_ID OLD_DOC_SEQUENCE_ID,
               LAST_UPDATE_DATE,
               LAST_UPDATED_BY,
               CREATION_DATE,
               CREATED_BY,
               LAST_UPDATE_LOGIN,
               APPLICATION_ID
          FROM FND_DOCUMENT_SEQUENCES
         WHERE DOC_SEQUENCE_ID in
               (SELECT distinct A.DOC_SEQUENCE_ID
                  FROM FND_DOC_SEQUENCE_ASSIGNMENTS A
                 WHERE A.START_DATE =
                       (select p.START_DATE
                          from GL_LEDGERS sob, GL_PERIODS_V p
                         where sob.ledger_id = 302
                           and p.period_set_name = sob.period_set_name
                           and p.period_year = x_year
                           and p.period_num = 12)
                   and a.end_DATE = last_day(a.START_DATE)
                   and a.end_DATE <> a.START_DATE
                )--Get Last month 's Sequence ID
         order by name) seq
 where 1 = 1
 group by seq_prefix,
          TYPE,
          value_type,
          AUDIT_TABLE_NAME,
          --TABLE_NAME,
          MESSAGE_FLAG,
          APPLICATION_ID;
      
---Define Seq
    CURSOR C_2(x_year             varchar2,
               x_seq_prefix       varchar2,
               x_AUDIT_TABLE_NAME varchar2,
               -- x_TABLE_NAME       varchar2,
               x_type           varchar2,
               x_value_type     varchar2,
               x_MESSAGE_FLAG   varchar2,
               x_application_id number) is
      select period.period_num,
             nvl(seq.NAME,
                 x_seq_prefix ||
                 to_char(nvl(seq.START_DATE, period.START_DATE), 'YY') ||
                 to_char(nvl(seq.START_DATE, period.START_DATE), 'MM')) name,
             nvl(seq.seq_prefix, x_seq_prefix) seq_prefix,
             nvl(seq.START_DATE, period.START_DATE) START_DATE,
             nvl(seq.END_DATE, period.END_DATE) END_DATE,
             nvl(seq.TYPE, x_type) TYPE,
             nvl(seq.MESSAGE_FLAG, x_MESSAGE_FLAG) MESSAGE_FLAG,
             nvl(seq.INITIAL_VALUE,
                 x_value_type ||
                 to_char(nvl(seq.START_DATE, period.START_DATE), 'YY') ||
                 to_char(nvl(seq.START_DATE, period.START_DATE), 'MM') ||
                 '0001') INITIAL_VALUE,
             --
             nvl(seq.AUDIT_TABLE_NAME, x_AUDIT_TABLE_NAME) AUDIT_TABLE_NAME,
             seq.DB_SEQUENCE_NAME,
             seq.TABLE_NAME,
             seq.OLD_DOC_SEQUENCE_ID,
             --
             nvl(seq.LAST_UPDATE_DATE, sysdate),
             nvl(seq.LAST_UPDATED_BY, 1),
             nvl(seq.CREATION_DATE, sysdate),
             nvl(seq.CREATED_BY, 1),
             nvl(seq.LAST_UPDATE_LOGIN, 1),
             nvl(seq.APPLICATION_ID, x_APPLICATION_ID) APPLICATION_ID
        from (select p.period_num, p.START_DATE, p.end_DATE
                from GL_LEDGERS sob, GL_PERIODS_V p
               where sob.ledger_id = 302
                 and p.period_set_name = sob.period_set_name
                 and p.period_year = x_year
                 and p.period_num <> 13) period,
             (SELECT F.NAME,
                     REGEXP_REPLACE(F.NAME,
                                    SUBSTR(F.NAME, -4, 4),
                                    null,
                                    1,
                                    1) seq_prefix,
                     F.START_DATE,
                     F.END_DATE,
                     F.TYPE,
                     F.MESSAGE_FLAG,
                     F.INITIAL_VALUE,
                     F.AUDIT_TABLE_NAME,
                     F.DB_SEQUENCE_NAME,
                     F.TABLE_NAME,
                     F.DOC_SEQUENCE_ID OLD_DOC_SEQUENCE_ID,
                     F.LAST_UPDATE_DATE,
                     F.LAST_UPDATED_BY,
                     F.CREATION_DATE,
                     F.CREATED_BY,
                     F.LAST_UPDATE_LOGIN,
                     F.APPLICATION_ID
                FROM FND_DOCUMENT_SEQUENCES F
               WHERE F.DOC_SEQUENCE_ID in
                     (SELECT distinct A.DOC_SEQUENCE_ID
                        FROM FND_DOC_SEQUENCE_ASSIGNMENTS A
                       WHERE A.START_DATE between
                             (select p.start_date
                                from GL_LEDGERS sob, GL_PERIODS_V p
                               where sob.ledger_id = 302
                                 and p.period_set_name = sob.period_set_name
                                 and p.period_year = x_year
                                 and p.period_num = 1)
                         and (select p.START_DATE
                                from GL_LEDGERS sob, GL_PERIODS_V p
                               where sob.ledger_id = 302
                                 and p.period_set_name = sob.period_set_name
                                 and p.period_year = x_year
                                 and p.period_num = 12)
                         and a.end_DATE = last_day(a.START_DATE)
                         and a.end_DATE <> a.START_DATE
                      )
                 and REGEXP_REPLACE(F.NAME,
                                    SUBSTR(F.NAME, -4, 4),
                                    null,
                                    1,
                                    1) = x_seq_prefix /*'BITLR AR OE INV BEWX '*/
                 and F.APPLICATION_ID =
                     nvl(x_APPLICATION_ID, F.APPLICATION_ID)
                 and F.AUDIT_TABLE_NAME =
                     nvl(x_AUDIT_TABLE_NAME, F.AUDIT_TABLE_NAME)
                 and F.type = nvl(x_type, F.type)
                 and F.MESSAGE_FLAG = nvl(x_MESSAGE_FLAG, F.MESSAGE_FLAG)) Seq
       where seq.start_date(+) = period.START_DATE
       order by period.period_num;
   
    ---Assign Sequence--
    CURSOR c_3(x_year varchar2, x_seq_prefix varchar2) is
      select seq_prefix,
             METHOD_CODE,
             SET_OF_BOOKS_ID,
             CATEGORY_CODE,
             APPLICATION_ID
        from (SELECT A.METHOD_CODE,
                     A.START_DATE,
                     A.END_DATE,
                     A.SET_OF_BOOKS_ID,
                     A.CREATION_DATE,
                     A.CATEGORY_CODE,
                     A.CREATED_BY,
                     A.LAST_UPDATE_DATE,
                     A.LAST_UPDATED_BY,
                     A.LAST_UPDATE_LOGIN,
                     -- DOC_SEQUENCE_ID,
                     F.NAME,
                     REGEXP_REPLACE(F.NAME,
                                    SUBSTR(F.NAME, -4, 4),
                                    null,
                                    1,
                                    1) seq_prefix,
                     A.APPLICATION_ID,
                     A.DOC_SEQUENCE_ASSIGNMENT_ID
                FROM FND_DOC_SEQUENCE_ASSIGNMENTS A,
                     FND_DOCUMENT_SEQUENCES       F
               WHERE A.Doc_Sequence_Id = F.DOC_SEQUENCE_ID
                 and REGEXP_REPLACE(F.NAME,
                                    SUBSTR(F.NAME, -4, 4),
                                    null,
                                    1,
                                    1) = x_seq_prefix --'BITLR AR RMA BEWX '
               /*  and A.START_DATE between
                     (select p.start_date
                        from GL_LEDGERS sob, GL_PERIODS_V p
                       where sob.ledger_id = 302
                         and p.period_set_name = sob.period_set_name
                         and p.period_year = x_year
                         and p.period_num = 1)
                 and (select p.START_DATE
                        from GL_LEDGERS sob, GL_PERIODS_V p
                       where sob.ledger_id = 302
                         and p.period_set_name = sob.period_set_name
                         and p.period_year = x_year
                         and p.period_num = 12)*/
                  ---
                  and  A.START_DATE =
                       (select p.START_DATE
                          from GL_LEDGERS sob, GL_PERIODS_V p
                         where sob.ledger_id = 302
                           and p.period_set_name = sob.period_set_name
                           and p.period_year = x_year
                           and p.period_num = 12)
                  ----
                 and a.END_DATE = last_day(a.START_DATE)
                 and a.END_DATE <> a.START_DATE
               order by F.name) Seq
       where 1 = 1
       group by seq_prefix,
                METHOD_CODE,
                SET_OF_BOOKS_ID,
                CATEGORY_CODE,
                APPLICATION_ID;
               
    --Assgin templete with 12 records --
    CURSOR C_GL_DOC_ASSIG(x_year            varchar2,
                          x_seq_prefix      varchar2,
                          x_METHOD_CODE     varchar2,
                          x_SET_OF_BOOKS_ID number,
                          x_CATEGORY_CODE   varchar2,
                          x_APPLICATION_ID  number,
                          x_START_DATE      date,
                          x_END_DATE        date) is
      select nvl(Seq.METHOD_CODE, x_METHOD_CODE) METHOD_CODE,
             nvl(seq.START_DATE, period.START_DATE) START_DATE,
             nvl(seq.END_DATE, period.END_DATE) END_DATE,
             nvl(Seq.SET_OF_BOOKS_ID, x_SET_OF_BOOKS_ID) SET_OF_BOOKS_ID,
             nvl(Seq.CATEGORY_CODE, x_CATEGORY_CODE) CATEGORY_CODE,
             nvl(seq.LAST_UPDATE_DATE, sysdate),
             nvl(seq.LAST_UPDATED_BY, 1),
             nvl(seq.CREATION_DATE, sysdate),
             nvl(seq.CREATED_BY, 1),
             nvl(seq.LAST_UPDATE_LOGIN, 1),
             nvl(seq.APPLICATION_ID, x_APPLICATION_ID) APPLICATION_ID,
             Seq.DOC_SEQUENCE_ASSIGNMENT_ID
        from (select p.period_num, p.START_DATE, p.end_DATE
                from GL_LEDGERS sob, GL_PERIODS_V p
               where sob.ledger_id = 302
                 and p.period_set_name = sob.period_set_name
                 and p.period_year = x_year
                 and p.period_num <> 13) period,
             (SELECT A.ROWID,
                     A.METHOD_CODE,
                     A.START_DATE,
                     A.END_DATE,
                     A.SET_OF_BOOKS_ID,
                     A.CREATION_DATE,
                     A.CATEGORY_CODE,
                     A.CREATED_BY,
                     A.LAST_UPDATE_DATE,
                     A.LAST_UPDATED_BY,
                     A.LAST_UPDATE_LOGIN,
                     -- DOC_SEQUENCE_ID,
                     F.NAME,
                     REGEXP_REPLACE(F.NAME,
                                    SUBSTR(F.NAME, -4, 4),
                                    null,
                                    1,
                                    1) seq_prefix,
                     A.APPLICATION_ID,
                     A.DOC_SEQUENCE_ASSIGNMENT_ID
                FROM FND_DOC_SEQUENCE_ASSIGNMENTS A,
                     FND_DOCUMENT_SEQUENCES       F
               WHERE A.Doc_Sequence_Id = F.DOC_SEQUENCE_ID
                 and A.START_DATE between
                     (select p.start_date
                        from GL_LEDGERS sob, GL_PERIODS_V p
                       where sob.ledger_id = 302
                         and p.period_set_name = sob.period_set_name
                         and p.period_year = x_year
                         and p.period_num = 1)
                 and (select p.START_DATE
                        from GL_LEDGERS sob, GL_PERIODS_V p
                       where sob.ledger_id = 302
                         and p.period_set_name = sob.period_set_name
                         and p.period_year = x_year
                         and p.period_num = 12)
                 and a.END_DATE = last_day(a.START_DATE)
                 and a.END_DATE <> a.START_DATE
                 and REGEXP_REPLACE(F.NAME,
                                    SUBSTR(F.NAME, -4, 4),
                                    null,
                                    1,
                                    1) = x_seq_prefix
                 and A.SET_OF_BOOKS_ID =
                     nvl(X_SET_OF_BOOKS_ID, A.SET_OF_BOOKS_ID)
                 and A.APPLICATION_ID =
                     nvl(x_APPLICATION_ID, A.APPLICATION_ID)
                 and A.METHOD_CODE = nvl(x_METHOD_CODE, A.METHOD_CODE)
                 and A.CATEGORY_CODE = nvl(x_CATEGORY_CODE, A.CATEGORY_CODE)) Seq
       where seq.start_date(+) = period.START_DATE
         and period.START_DATE = x_START_DATE
         and period.END_DATE = x_END_DATE
       order by period.period_num;
    --Assgin templete with 12 records --
    V_DOC_SEQUENCE_ID  FND_DOCUMENT_SEQUENCES.DOC_SEQUENCE_ID%type;
    V_SEQUENCE_NAME    FND_DOCUMENT_SEQUENCES.NAME%type;
    V_DB_SEQUENCE_NAME FND_DOCUMENT_SEQUENCES.DB_SEQUENCE_NAME%type;
    v_Start_Date    FND_DOCUMENT_SEQUENCES.START_DATE%type;
    v_end_Date      FND_DOCUMENT_SEQUENCES.END_DATE%type;
    v_INITIAL_VALUE FND_DOCUMENT_SEQUENCES.Initial_Value%type;
    V_DOC_SEQUENCE_ASSIGNMENT_ID FND_DOC_SEQUENCE_ASSIGNMENTS.Doc_Sequence_Assignment_Id%type;
    V_CATEGORY_CODE FND_DOC_SEQUENCE_ASSIGNMENTS.CATEGORY_CODE%type;
    V_SOB_ID        FND_DOC_SEQUENCE_ASSIGNMENTS.SET_OF_BOOKS_ID%type;
    cur_1      C_1 %rowtype;
    GL_DOC_SEQ C_2 %rowtype;
    cur_3        C_3 %rowtype;
    GL_DOC_ASSIG C_GL_DOC_ASSIG %rowtype;
  begin
    dbms_output.put_line('Processing GL Document Sequence!');
    fnd_file.put_line(fnd_file.output,'Processing GL Document Sequence!');
    for cur_1 in C_1(V_COPY_FR_YEAR) loop
      EXIT WHEN C_1%NOTFOUND;
    --  dbms_output.put_line('Seq prefix:' || cur_1.seq_prefix);
      fnd_file.put_line(fnd_file.output, 'Seq prefix:' || cur_1.seq_prefix);
      for GL_DOC_SEQ in C_2(V_COPY_FR_YEAR,
                            cur_1.seq_prefix,
                            cur_1.AUDIT_TABLE_NAME,
                            cur_1.TYPE,
                            cur_1.value_type,
                            cur_1.message_flag,
                            cur_1.application_id) loop
        EXIT WHEN C_2%NOTFOUND;
        v_count_defin := v_count_defin + 1;
        select FND_DOCUMENT_SEQUENCES_S.nextval,
               REGEXP_REPLACE(GL_DOC_SEQ.NAME,
                              SUBSTR(GL_DOC_SEQ.NAME, -4, 2),
                              to_char(add_months(GL_DOC_SEQ.START_DATE,
                                                 v_year * 12),
                                      'YY'),
                              1,
                              1),
               add_months(GL_DOC_SEQ.START_DATE, v_year * 12),
               add_months(GL_DOC_SEQ.END_DATE, v_year * 12),
               SUBSTR(GL_DOC_SEQ.INITIAL_VALUE, 1, 1) ||
               to_char(add_months(GL_DOC_SEQ.START_DATE, v_year * 12), 'YY') ||
               to_char(add_months(GL_DOC_SEQ.START_DATE, v_year * 12), 'MM') ||
               SUBSTR(GL_DOC_SEQ.INITIAL_VALUE, 6)
          into V_DOC_SEQUENCE_ID,
               V_SEQUENCE_NAME,
               V_START_DATE,
               V_END_DATE,
               v_INITIAL_VALUE
          from SYS.DUAL;
        V_DB_SEQUENCE_NAME := 'FND_DOC_SEQ_' ||
                             /*app_number.number_to_canonical*/
                              (V_DOC_SEQUENCE_ID) || '_S';
        -- Calls FND_SEQNUM.create_db_seq routine to create DB sequences
        -- new automatic Doc_Seq numbers.
        FND_SEQNUM.create_db_seq( V_DB_SEQUENCE_NAME, v_INITIAL_VALUE );
        --Bug--

        INSERT INTO FND_DOCUMENT_SEQUENCES
          (NAME,
           START_DATE,
           END_DATE,
           TYPE,
           MESSAGE_FLAG,
           INITIAL_VALUE,
           AUDIT_TABLE_NAME,
           DB_SEQUENCE_NAME,
           TABLE_NAME,
           DOC_SEQUENCE_ID,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_LOGIN,
           APPLICATION_ID)
        VALUES
          (V_SEQUENCE_NAME,
           V_START_DATE,
           V_END_DATE,
           GL_DOC_SEQ.TYPE,
           GL_DOC_SEQ.MESSAGE_FLAG,
           V_INITIAL_VALUE,
           GL_DOC_SEQ.AUDIT_TABLE_NAME,
           V_DB_SEQUENCE_NAME,
           GL_DOC_SEQ.TABLE_NAME,
           V_DOC_SEQUENCE_ID,
           SYSDATE,
           v_use_id,
           SYSDATE,
           v_use_id,
           v_use_id,
           GL_DOC_SEQ.APPLICATION_ID);
       -- dbms_output.put_line('Assign Doc:' || V_SEQUENCE_NAME);
        fnd_file.put_line(fnd_file.output,
                          'Assign Doc:' || V_SEQUENCE_NAME);
        ---2. Assign Doc--
        for cur_3 in C_3(V_COPY_FR_YEAR, cur_1.seq_prefix) loop
          EXIT WHEN C_3%NOTFOUND;
          for GL_DOC_ASSIG in C_GL_DOC_ASSIG(V_COPY_FR_YEAR,
                                             cur_3.seq_prefix,
                                             cur_3.METHOD_CODE,
                                             cur_3.SET_OF_BOOKS_ID,
                                             cur_3.CATEGORY_CODE,
                                             cur_3.application_id,
                                             GL_DOC_SEQ.START_DATE,
                                             GL_DOC_SEQ.END_DATE) loop
            EXIT WHEN C_GL_DOC_ASSIG%NOTFOUND;
            v_count_assig := v_count_assig + 1;
            select FND_DOC_SEQUENCE_ASSIGNMENTS_S.NEXTVAL,
                   add_months(GL_DOC_ASSIG.START_DATE, v_year * 12),
                   add_months(GL_DOC_ASSIG.END_DATE, v_year * 12)
              into V_DOC_SEQUENCE_ASSIGNMENT_ID, V_START_DATE, V_END_DATE
              from SYS.DUAL;
           /* dbms_output.put_line('Assign Category Code:' ||
                                 GL_DOC_ASSIG.CATEGORY_CODE);*/
            insert into FND_DOC_SEQUENCE_ASSIGNMENTS
              (METHOD_CODE,
               START_DATE,
               END_DATE,
               SET_OF_BOOKS_ID,
               CREATION_DATE,
               CATEGORY_CODE,
               CREATED_BY,
               LAST_UPDATE_DATE,
               LAST_UPDATED_BY,
               LAST_UPDATE_LOGIN,
               DOC_SEQUENCE_ID,
               APPLICATION_ID,
               DOC_SEQUENCE_ASSIGNMENT_ID)
            VALUES
              (null,
               V_START_DATE,
               V_END_DATE,
               GL_DOC_ASSIG.SET_OF_BOOKS_ID,
               sysdate,
               GL_DOC_ASSIG.CATEGORY_CODE,
               v_use_id,
               sysdate,
               v_use_id,
               v_use_id,
               v_DOC_SEQUENCE_ID,
               GL_DOC_ASSIG.APPLICATION_ID,
               V_DOC_SEQUENCE_ASSIGNMENT_ID);
          END LOOP;
        end loop;
      end loop;
    end loop;
  end;
end GLGENSEQ_BG_1;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9182041/viewspace-719698/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9182041/viewspace-719698/

cs888800
关注
ImportError: cannot import name ‘MultiModalData‘ from ‘vllm.sequence‘解决方案
weixin_43178406的博客
07-27 10万+
 本文主要介绍了ImportError: cannot import name ‘MultiModalData’ from 'vllm.sequence’解决方案，希望能对使用Python的同学们有所帮助。 文章目录 1. 问题描述 2. 解决方案
Oracle创建Sequence序列
Ezreal的学习之路
01-20 4057
202-01-19 Oracle学习之创建序列 一、Oracle版本 Oracle 11.2.0.1.0 - 64bit Tool SQLPlus
销售订单头表的订单编号生产规则
EBS学习杂记
03-18 4767
销售订单头表是 ont.oe_order_headers_all . order number 是系統設定產生的流水號碼，設定 order mangager respobibility---》setup--> document-->define Header_id 是用序列 OE_ORDER_HEADERS_S產生的， Line_id 是用序列  OE_ORDER_LINES_S產生的，
Oracle EBS R12经验谈（二）
yy5512的专栏-Oracle ERP 经验累计
08-04 1万+
作者: jianping.ni    时间: 2009-2-13 12:52     标题: Oracle EBS R12经验谈（二）OAF页面:银行帐户开户人LOV值列表无值   在输入 应付超级用户职责/Setup : Payment/银行帐户/创建银行帐户：帐户开户人和用途 中的银行帐户开户人字段时,不要选择边上的LOV值列表(选了也白选,因为没有值可选,是bug),直接在该字段
APP-FND-01706: Error Updating TABLE_NAME In FND_DOCUMENT_SEQUENCES (文档 ID 338026.1)
weixin_33720078的博客
07-06 652
In this Document Symptoms Cause Solution Applies to: Oracle Order Management - Version 11.5.10.0 and laterInformation in this document applies to any platform.***Checked for relevance on 10-JUN-2...
EBS_FND_单据序列和序列分配API开发
08-22
EBS_FND_单据序列和序列分配API开发，包括详细的代码（建表/验证数据/塞入正是表等）。
深入浅出Oracle EBS之核心功能(FIN)
04-06
深入浅出Oracle EBS之核心功能(FIN)
Oracle序列sequence cache nocache、RAC
开着奥迪卖小猪
01-03 4408
一、问题描述：新增了个表，上了生产环境之后，发现ID跳号且穿插，如图1所示。 而测试环境只是跳号，如图2所示。 图1 生产环境 图2 ...
oracle表增加序列字段,oracle sequence的简单介绍(自增加字段)
weixin_31058323的博客
04-02 1791
例子 ：create sequence S_A_EventID increment by 1 start with 34 maxvalue 999999999;在oracle中sequence就是所谓的序列号，每次取的时候它会自动增长，通常用在须要按序列号排序的地方。一、Create Sequence你首先要有CREATE SEQUENCE或者CREATE ANY SEQUENCE权限，CREAT...
Oracle Sequence 实现自增主键
You can't stand me now
06-19 1519
由于Oracle不支持MySql的auto_increment，为了实现自动生成主键的操作在Oracle上，之前写了一篇文章是借助了 Oralce Sequence（序列）+ Oracle Trigger（触发器）来实现的：https://blog.youkuaiyun.com/libertine1993/article/details/54705928但是触发器不可靠且耗性能，于是有了这篇文章，我们利用序列...
oracle ebs csi,oracle ebs Order Management Tables.
weixin_35648264的博客
04-05 299
Enteredoe_order_headers_all 1 record created in header tableoe_order_lines_all Lines for particular recordsoe_price_adjustments When discount gets appliedoe_order_price_attribs If line has price attri...
Order Management Useful Scripts
田攀的日志
04-08 1万+
Listed some useful queries scripts for Oracle Order Management Flow.(For Order Management Detailed Flow, You may check my previous post: Oracle EBS订单的流程(Order->AR): http://blog.youkuaiyun.com/pan_tian/artic
System Error Codes
热门推荐
snail8384的专栏
08-13 9万+
From: http://msdn.microsoft.com/en-us/library/windows/desktop/ms681382%28v=vs.85%29.aspx Applies to: desktop apps only Note   The information on this page is intended to be used by programm
Daily Rates: APP-FND-01206: This Record Already Exists When Entering New Rate (文档 ID 1414117.1)
kikiwhq的专栏
03-01 1369
摘自：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=531328226859367&amp;id=1414117.1&amp;_afrWindowMode=0&amp;_adf.ctrl-state=g7my1suo2_80 Daily Rates: APP-FND-01206: This Record Alrea...
Oracle EBS OM 主要API示例
wangcheng8699的专栏
12-25 506
1, Book order Oe_Order_Pub.Process_Order ( 1 , Fnd_Api.G_FALSE , Fnd_Api.G_FALSE , Fnd_Api.G_FALSE , x_return_status , x_msg_count , x_msg_data –IN PARAMET...
OM销售设置
cherryzhao的专栏
12-30 1128
2013-12-30
Oracle EBS 基础概念：单据序号@销售订单号
weixin_42683386的博客
08-13 1795
单据序号是基于特定表的事务处理的一种内部管理记录。无论事务处理成功与否，使用 序号都可以彻底跟踪所有的事务处理。 下面通过新建订单型态并指定序号说明一下如何创建和实施单据序号。 当建立一个销售订单型态时，系统自动建立相应的单据分类，将单据分类和序号相关联，就可以确定销售订单型态与序号的对应关系。 步骤1. 新建订单型态行 ...
[RAG] 文档格式化 | 知识库摄入 | VectorDB.faiss | BM25索引.pkl
最新发布
一个人知道自己为什么而活，他就能够接收任何一种生活
07-17 713
向量数据库擅长"含义"搜索，但有时我们只需要快速查找`精确关键词`。这时**==BM25索引==**就派上用场。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值