DOCUMENTRECEIVABLE section missing from XML extract after patch 19697061 (Doc ID 2073284.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

After running Create Settlement Batches, find that the DOCUMENTRECEIVABLE section is missing from the XML extract.  There is no transaction/invoice number in the output file.

After patch 19697061 is applied DOCUMENTRECEIVABLE section missing from XML extract .

In the Create Settlement Batches log file, for the XML extract, there is no occurrence of "DocumentID".  This is because ship_to_address_id is not populated in ra_customer_trx_all. Hence when Create Settlement Batches is run, the join to ship_to_address_id (i.e. WHERE inv_header.ship_to_address_id = hz.cust_acct_site_id) is not satisfied and hence the insert into IBY_AR_DOC_HEADER_GT selects 0 rows.

Changes

 In ibyfcxgb.pls version deployed by 19697061, the joins have been changed to "outer" joins, so when ship_to_address_id is not populated in ra_customer_trx_all, in the xml extract there will be no occurence of Document_id.

Cause

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