Unable To Reprocess Documents from REIM to Fusion - Data From im_ap_stage_head / im_ap_stage_detail (Doc ID 3036628.1)

Last updated on JULY 29, 2024

Applies to:

Goal

Need to reprocess documents from REIM to Fusion

The data is retrieved from the im_ap_stage_head_hist and im_ap_stage_detail_hist tables and inserted it again to im_ap_stage_head and im_ap_stage_detail tables.

insert into im_ap_stage_head values ('1441243','35002','STANDARD','91123541','79838','179838','EUR','1','User','12/18/2023','242.4','12/18/2023','101','330000','000000','00','0000','000','0','0','0','','05/28/2024','1/10_Net_30','101','1885946','101','','','','','','','','','','','','REIM||MRCHI||35002','','','','');
insert into im_ap_stage_detail values ('35002','124611','UNR','ITEM','193.19','101','330005','000000','00','0000','000','0','0','0','','05/28/2024','101','1885946','101','','','','','','','','','','','','REIM||MRCHI||35002','','','8618','N');
insert into im_ap_stage_detail values ('35002','124614','NMRCH','MISCELLANEOUS','10.5','101','580001','999999','00','0000','000','0','0','0','','05/28/2024','101','1885946','101','','','','','','','','','','','','REIM||MRCHI||35002','','','8639','N');
insert into im_ap_stage_detail values ('35002','124612','TAX','TAX','36.71','101','140600','000000','00','0000','000','0','0','0','','05/28/2024','101','1885946','101','','','','','','','','','','','','REIM||MRCHI||35002','DESTD','19','8618','Y');
insert into im_ap_stage_detail values ('35002','124613','TAXNDI','TAX','2','101','140600','000000','00','0000','000','0','0','0','','05/28/2024','101','1885946','101','','','','','','','','','','','','REIM||MRCHI||35002','DESTD','19','8639','Y');

Next the BDI_REIM_AP_TX_JOB is executed.

The data is consumed on REIM im_ap_stage_* tables and go to RFI im_ap_stage_* tables, but some times after it disappears and it isn't sent to Fusion or to the *_hist tables.

Also tried to restart the RFI adapter like Doc ID 2740323.1 describes, but nothing occurs?


 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.