Thursday 22 June 2017

What’s the functionality of Auto invoice master program?



It will insert the data from interface tables to invoice base tables.
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
AR_PAYMENT_SCHEDULES_ALL

What’s the functionality of workflow background process?



It will move the data from OM base tables to AR Interface tables (RA_Interface_lines_all) in case of “Line – Flow Generic Workflow”

Saturday 3 June 2017

How we can skip header records while loading?



By using the "SKIP=n" keyword. "n" specifies the number of logical rows to skip.
i.e. SKIP=1