Welcome to iter21
Our Technical Journey through the 21st CenturyEBTax: Tax Architecture with/without Inventory Items
Considerations for Architecting a solution when Inventory items [are] or [are not] being leveraged. When considering a roll-out o EBTax one has to take special care to analyze the using, or not using, Inventory Items as part of...
FNDLOAD: Inventory Category Sets, Categories and Category Set Valid Categories
Load Category Sets (load first) Categories (load second) Category Set Valid Categories Using FNDLOAD in the usual manner one can download or upload the following Oracle Inventory Category related configurations. Naturally, some...
Mapping Sets Diagrammed
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
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
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
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
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...
GL Mass Maintenance
Creating accounts for a new CC based on a current CC is shown below: To do a move simply name the source accounts and map to target accounts. A move operation transfers balances from one or more source accounts to one or more target accounts. In the Mass Maintenance...
Document Sequencing in General Ledger
You can assign only one active document sequence scheme to each unique combination of: Application, CategorySet of BooksMethod (Auto or Manual entry) However, you can assign the same document sequence to more than one combination of Application, Category, Set of...
Setup/Enable Contracts and Deliverables in PO
The following describe the base setup for enabling Contracts. There are two ways to leverage Contracts. Using PO - "Purchasing Contracts" - Integrate contract terms with a Contract Purchase Agreement, PO, or Sourcing document.Using full blown Contracts -...
Property Management Key Process Flow
Process Flow The following list is a typical sequence of events that you might follow to abstract a lease in Oracle Property Manager: Set up service providers, and define locations, regions and office parks, milestones, and reporting currencies.Abstract the lease....
i-Expense Key Setups
Key Setup steps to get iExpense up and running LicenseAP already upDefault Exp Template iExpense enabled and set in Payable OptionsEmployeeIn iExpense, enable the OU Context that will use itSet Accounting for ledgers and which segments are visible/up-dateableSetup any...
Does Internet Expenses in Release 12 support MOAC feature?
In Release 12, Internet Expenses does not support MOAC. Operating Unit is derived based on "MO:Operating Unit" profile option only and there is no provision for the user to select operating units. In order to access the iExpense page and not get an "unexpected...
How to change Default “Enterprise Name” in iSupplier notifications?
Run scriptPOSENTUP.sql. "...before starting the registration process the following script needs to be run. $APPL_TOP/pos/11.5.0/patch/115/sql/POSENTUP.sql This script establishes the Enterprise Name that will be used in all of the notification emails used during the...
Services Procurement Setup
Setup Steps for Services Procurement Enable License: Purchasing Services Procurement Set Profile Option: PO: Enable Services Procurement (to be sure they are enabled set it to No and then back to Yes) Create a custom Style Sheet...
Project Accounting (Foundation) Express Setup Steps
Follow the following steps to put inplace a foundation/base for Projects Define Responsibilities with profiles set for the following:HRMOGLSet profiles for both the Calendar and Budget itemsUpdate/Add to Org the PA Org...
Available Sources for Sub-Ledger Accounting (SLA) by Oracle Module 12.1.3
The table below lists the available sources in SLA for each modules ModuleSLA SourcesGLNAAP973AR2137CST1221PN63OZF134FV351LNS131OKL345 ModuleSLA SourcesCE132FA380PA421AGIS65PO510GMA582PAY54ONTNASLA80 OZF=Trade Management; GMA=Process Manufacturing; OKL=Lease...
R12: CE: Understanding BANK ACCOUNT BALANCES
R12: CE: Understanding BANK ACCOUNT BALANCES functionality in Oracle's Cash Management application (Doc ID 814254.1) Q1: What are Bank Account Balances? Bank Account BalancesBank account balance maintenance and reporting is supported for all internal bank accounts in...
Create Documents Workflow FAQ (CREATEDOC / CREATEPO)
This FAQ document identifies the most frequently reported how-to questions relating to the Oracle Purchasing Approval functionality regarding to the CreatePO workflow. The articles below do not include bugs/patches or troubleshooting notes. 1. What is the setup needed...
Cash Management Key Setups
System Paramters: Set the Legal Entity and Ledgers (Simply hit new to add another LE and Ledger Combo) Banks should be setup up if they have not already Define Misc Transactions in AR for Set any pre-defined Transfer Templates as required Bank Transaction Codes...