Accounts Payable (Refund Adjustments) Extraction

Oracle Revenue Management and Billing enables you to extract the accounts payable (i.e. refund adjustments) in the following formats:

  • Comma-Separated Values (CSV)

  • Pipe-Separated Values (PSV)

  • Tilde-Delimited File (TILD)

  • Extensible Markup Language (XML)

  • JavaScript Object Notation (JSON)

A new batch named C1-APEXT is introduced in this release. You need to set the A/P Batch Code field to C1-APEXT in the Financial Transaction tab of the Installation Options screen. On creating a refund adjustment, the system will then stamp the C1-APEXT batch control and batch run number whenever records are added in the CI_​ADJ_​APREQ table.

The C1-APEXT batch enables you to extract the accounts payable (i.e. refund adjustments) in a flat file. It considers all the adjustments created using the adjustment types where the A/P Request Type Code field is set to REFUND and whose corresponding record in the CI_​ADJ_​APREQ table has the latest batch run number. It then extracts the data in a flat file in the given format.

This batch is a multi-threaded batch. The multi-threading is based on adjustment ID and chunks for multi-threading are created based on numerical distribution of adjustment ID. It contains the following parameters:

Parameter Name Mandatory (Yes or No) Description
DIST-THD-POOL No Used to specify the thread pool on which you want to execute the batch.
File Name Yes Used to specify the name which you want to use for the flat file.
Note: By default, the file name is set to DummyRecords.
File Path Yes Used to specify the directory where you want to store the extracted file. If the application environment is an On Premise or Cloud Service environment, you can specify the directory name along with the following relative path:

  • @SHARED_​DIR – Used when you want to store the extracted file in the shared directory on the server.

For example, you can set the value to @SHARED_​DIR/output.
File Format Yes Used to specify the format in which you want to extract the data. The valid values are:
  • CSV – Used when you want to extract the data in the Comma-Separated Values (CSV) format.
  • PSV - Used when you want to extract the data in the Pipe-Separated Values (PSV) format.
  • TILD - Used when you want to extract the data in the Tilde-Delimited File (TILD) format.
  • XML - Used when you want to extract the data in the Extensible Markup Language (XML) format.
  • JSON - Used when you want to extract the data in the JavaScript Object Notation (JSON) format.
Header Date Format Yes Used to specify the format in which the date should printed in the header of the extracted file. The header date indicates when the flat file was extracted in ORMB.
Note: By default, the date format is set to DD-MM-YYYY.

Once the data is extracted in the given format at the specified location, the status of the accounts payable request in the CI_​ADJ_​APREQ table is changed from N (i.e. Not Ready) to R (i.e. Ready for Payment). You can then share the flat file with an external system (i.e. Accounts Payable Processing System). The external system will then accordingly make the refund payments to the customers as appropriate.