1. Using Financials for EMEA
  2. Manage Standard Lookups

Manage Standard Lookups

You can manage the standard lookups for e-reporting for France.

Configurable Batch Size per ORA_JEFR_BATCH_SIZE File

Updates the configurable batch size for each file to improve performance.

The Payables Invoice and Life Cycle Status Extract for France process is generates in one batch file only number of invoices defined in the filed Meaning. If the number of selected invoices will exceed the number defined in the field Meaning the process will split extracts to multiple batch files.

This table displays the lookup code values and their details.

Lookup Code Display Sequence Enabled Start Date End Date Meaning Description
ORA_BATCH_SIZE 1 TRUE 1/1/00 1000 File Batch Size

Payables Holds Included in the ORA_JEFR_LC_REFUSED_INCLUDED Life Cycle Refused Extract

Identifies the Payables holds included in the life cycle Refused extract.

The Lookup Type ORA_JEFR_LC_REFUSED_INCLUDED is seeded and you can define those Refused Holds that should be extracted by the Payables Invoice and Life Cycle Status Extract for France process.

To set up the new Refused hold, you must define these fields and save your work:
  • Lookup Code - Short Hold Name = Short Refused Status Name. This value should be identical as Invoice Hold Name.
  • Display Sequence – Define Row sequence number.
  • Enable – Yes.
  • Start Date – Define start date for lookup code.
  • End Date – Leave it blank.
  • Meaning – Define Refusal reason code that will be reported in the file.
  • Description – Define Refusal reason description that will be reported in the file.

ORA_JEFR_EXTRACT_STATUS Extract Status

Determines the extract status for the Payables invoice and life cycle status extract for France. The Lookup Type ORA_JEFR_EXTRACT_STATUS and Lookup Codes are seeded. The Payables Invoice and Life Cycle Status Extract for France process is using these Lookup Code Meaning values to update status in the Invoice Extract Status and Extract Status GDfs.

This table displays the lookup code values and their details.

Lookup Code Display Sequence Enabled Start Date End Date Meaning
ORA_SUBMITTED 1 TRUE 1/1/00 Submitted
ORA_RECEIVED 1 TRUE 1/1/00 Received
ORA_OTHER 1 TRUE 1/1/00 Other
ORA_REJECTED 1 TRUE 1/1/00 Rejected