RMA orders stuck in Awaiting Billing in Oracle Fusion
Summary:
Hi Team,
We have RMA orders and processed the same.
Even after creation of credit memo, RMA order line stuck in Awaiting Billing.
Attaching the screenshots;
Invoice screenshot:
we identified some privilages missing who ran Auto Import Invoice and got the docs to run Notify feeded receivables transaction ESS job with requesti id.
Ran below SQL:
SELECT distinct
rctla.request_id
FROM fusion.ra_customer_trx_all rcta ,
fusion.ra_customer_trx_lines_all rctla,
fusion.doo_fulfill_lines_all dfla
WHERE rcta.customer_trx_id = rctla.customer_trx_id
AND rctla.interface_line_attribute5 = TO_CHAR(dfla.fulfill_line_id)
Tagged:
0