Interface_GL通过gl_interface导入日记账（案例）

2014-06-17 BaoXinjian

一、基本参考

---

1. 接口表和错误信息

    (1).gl_interface: 数据会影响gl_je_batches, gl_je_header, gl_je_lines, gl_import_references

    (2).gl_interface_contorl: 控制那些Resource资料需要导入

    (3).gl_interface_status: 错误信息

2. 并发程式<Journal Import>

   

    ==>Program - Import Journals

3. Interface Form

   

4. 关键参数

 

二、案例实现

---

1. 代码简单例子

DECLARE
    rec_gl_journal gl_interface%ROWTYPE;
    l_group_id gl_interface.GROUP_ID%TYPE;
    l_interface_run_id gl_interface_control.interface_run_id%TYPE;
BEGIN
    SELECT gl_interface_control_s.NEXTVAL INTO l_group_id FROM DUAL;
    rec_gl_journal.status := 'NEW';
    rec_gl_journal.ledger_id := 1;
    rec_gl_journal.set_of_books_id := 1;
    rec_gl_journal.accounting_date := SYSDATE;
    rec_gl_journal.date_created := SYSDATE;
    rec_gl_journal.created_by := fnd_global.user_id;
    rec_gl_journal.actual_flag := 'A';
    rec_gl_journal.user_je_source_name := 'Purchasing';
    rec_gl_journal.user_je_category_name := 'Receiving';
    rec_gl_journal.reference1 := 'reference1';
    rec_gl_journal.reference2 := 'reference2';
    rec_gl_journal.reference10 := 'reference10';
    rec_gl_journal.currency_code := 'USD';
    --dr
    rec_gl_journal.code_combination_id := 17021;
    rec_gl_journal.entered_dr := 10;
    rec_gl_journal.accounted_dr := 10;
    rec_gl_journal.entered_cr := NULL;
    rec_gl_journal.accounted_cr := NULL;
    INSERT INTO gl_interface VALUES rec_gl_journal;
    --cr
    rec_gl_journal.code_combination_id := 16902;
    rec_gl_journal.entered_dr := NULL;
    rec_gl_journal.accounted_dr := NULL;
    rec_gl_journal.entered_cr := 10;
    rec_gl_journal.accounted_cr := 10;
    INSERT INTO gl_interface VALUES rec_gl_journal;
    SELECT gl_interface_control_s.NEXTVAL INTO l_interface_run_id FROM DUAL;
    INSERT INTO gl_interface_control
              (je_source_name, GROUP_ID, interface_run_id, set_of_books_id,status)
           VALUES ('Purchasing', l_group_id, l_interface_run_id, 1,'S');
    COMMIT;
END;

2.导入画面

    

3.Import Jounarl后运行的Output

    

4.产生的日记账明细及Batch

 

Thanks and Regards