Mapping Sets Diagrammed

Mar 7, 2020 | GL, Oracle

Mapping Sets Diagrammed Essentially Mapping Sets are Hash Maps (Key == Value) Source column values are mapped to Segment Values in Mapping Sets Mapping Sets are then placed in Account Derivation Rules(ADR) to map the value in the source column to the corresponding...

EBTax: Tax Determining Factors

Mar 7, 2020 | EBTax, Oracle

Tax Determining Factors These are set by Oracle and cannot be extendedDetermine:Tax RulesTax RegimeTax Basis FormulaDetermining Factor Classes:AccountingDocumentParty Fiscal ClassificationLegal Party Fiscal Classification Product – Inventory LinkedProduct...

FAH Sub-Ledger Accounting (SLA) Setup Steps

Mar 7, 2020 | GL, Oracle

Register the External SystemRESP: System AdministratorApplication RegisterCreate Custom ResponsibilityAdd new Responsibility to a UserDefine Journal Source for the External System entriesDefine the Subledger ApplicationDefine the Event Model (Most Important...

Load Categories with Java for Oracle iProcurement

Mar 7, 2020 | Oracle, P2P

The code below can be used to pull in a text file that contains the Category information and then it writes an XML file that Oracle can pull in to load (or delete categories that are not used) categories in Oracle iProcurement. import java.io.File; import...

Oracle Receivables (AR) Set the Party Number Next Number

Mar 7, 2020 | AR, Oracle

The database sequence that handles the creation of customer numbers is defined in HZ_PARTY_NUMBER_S. select max(party_number) from ar.hz_parties; Then using the number returned above, define the sequence to start with a higher value. If for example the above returns...

Let's set up a call?

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Let's set up a call

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Let's get on a call!

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch