Wednesday, 20 November 2013

Collection Plan Interface in R12 Oracle Apps

DECLARE
v_request_id NUMBER;
BEGIN

INSERT INTO qa_results_interface (
                                        organization_code
                                        ,plan_name
                                        ,process_status
                                        ,insert_type
                                        ,collection_id
                                        ,last_update_date
                                        ,last_updated_by
                                        ,qa_last_updated_by
                                        ,transaction_date
                                        ,character1
                                        ,character2
                                        ,character3
                                        ,character4
                                        ,character5                          
                                        ,character6
                                        ,character7
                                        ,quantity
                                        ,ITEM_ID
                                        ,wip_entity_id
                                        ,item
                                        ,job_name                   
                                        )
VALUES (
          'XX' -- organization_code
          ,'XX_JOB COMPLETION PLAN' -- plan_name
          ,1 -- process_status
          ,1 -- insert_type = INSERT
          ,QA_COLLECTION_ID_S.NEXTVAL
          ,SYSDATE
          ,fnd_global.user_id
          ,fnd_global.user_id
          ,SYSDATE
          ,'1'
          ,'1'
          ,'1'
          ,'1'
          ,'1'
          ,'1'
          ,'1',
          1,
          1001,
          132189,
          'Test Item',
          '1234'
          );         
         
COMMIT;         
fnd_global.apps_initialize (user_id, resp_id, appl_id);
v_request_id :=
      fnd_request.submit_request('QA',
                                  'QLTTRAMB',              -- Program short name
                                  '',             -- description (Not require)
                                  '',        -- start_time (start immediately)
                                  FALSE,          --sub_request (default FALSE)
                                  '200',
                                  '1',
                                  '1133',
                                  'YES'
                                 );

COMMIT;
dbms_output.put_line(v_request_id);
END;

1 comment:

  1. The above approach throwing critical error in QA_INTERFACE_ERRORS

    ReplyDelete