Oracle Payables Integration

Based on the customer’s requirement DATABASICS can integrate reimbursable Expense records with the Payables module in E-Business Suite, creating multiple line invoices.

After a completed workflow in DATABASICS, per customer requirements, a tailored posting is batched and presented to Payables with a Header Record, and one or many Line records.

Bi-directional dataflow ensures the validity of data in the posting, e.g. that the user selects an assigned project / task if applicable, and the charge is associated with the correct account.

Mapping to GL Accounts

Mapping to the appropriate GL account(s) will be according to the customer’s requirement:
Expense Types in DATABASICS will be mapped to Expense Accounts in E-Business Suite. Multiple Expense types can be mapped to the same expense account to support the customer’s requirement: e.g Taxi/Rideshare and Mileage can both be associated with the Ground Transportation Account.

Post Approved Transactions to E-Business Suite

Data in the extract file created by DATABASICS will be provided according to the customer requirement, including special instructions provided related to their specific process requirement as outlined in an agreed design.

Data can include Project and Task as well as other Extra and Segment elements to fulfill the accounting requirement in a posting for reimbursement and accounting.

Example DATABASICS Post to Payables profile:

Example DATABASICS Post to Payables

001~1057~612075~000~00~0000~00~000~0~0000~0000~000~0000 - $27.64

001~1041~612075~000~00~0000~00~000~0~0000~0000~000~0000 - $795.70

001~1021~612075~000~00~0000~00~000~0~0000~0000~000~0000 - $5.67

~0000005~HEADER~1234~~~~~~~~~~~~~~10013013~829.01~DB PAYMENT ~53887~GRP SUPPLIER-1~~~~~~~~~~~~~~~~~WORK COMPLETED DECEMBER 2020~29012013~~~STANDARD~~AT RETURN TO REQUESTOR~~~~~~~~~75~~~~~~~~~~~~~~

~0000005~LINE~1234~001~1057~612075~000~00~0000~00~000~0~0000~0000~000~0000~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~27.64~~~~~~~~~~~~~~~~~~~~~

~0000005~LINE~1234~001~1041~612075~000~00~0000~00~000~0~0000~0000~000~0000~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~795.70~~~~~~~~~~~~~~~~~~~~~

~0000005~LINE~1234~001~1021~612075~000~00~0000~00~000~0~0000~0000~000~0000~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~5.67~~~~~~~~~~~~~~~~~~~~~

NOTE: DATABAICS has the ability to rollback a posted batch as long as it is not processed in ADP yet. You may need to contact support@data-basics.com or submit a ticket online to request a rollback to posted expense batch.