Could you please help me out.
we have one package, it will fetch the data from staging table and inserts data into Ra_interface_lines_all and Ra_interface_salescredits_all tables. once we submit the package in front end completed successfully, but no records in ra_interface_lines_all
I have submitted the Auto invoice master program(RAXMTR) from my custom package program. it is executed successfully with PHASE --> Completed and STATUS --> Normal. where as invoices are not created/populated in Base tables. here i submitted the below request from package program.
Auto invoice master program and Auto invoice import program did not create any output here can u kindly suggest me on this issuw
As you mentioned there is no data in table ra_interface_lines_all then obviously Auto invoice master program or Auto invoice import program will not be able to process and import invoices in AR.
First check if the program feeding the data from staging table to ra_interface_lines_all is working fine.