Allocation Formula Rules

Use the following definition rules when creating your allocation formulas. The allocation validation program checks that your formulas adhere to these rules.

For formula lines A, B and C (operand lines):
• You can enter either an amount or an account in lines A, B and C.
• If you enter an account, child values must have a Constant segment type.
• Parent values may have a Constant, Looping or Summing segment type.
• You can use a Constant segment type with a parent value only if it references a summary account.
• If you use a Looping segment type on the same segment in more than one of the operand lines, you must use the same parent.
• If you use a Looping segment type in your Target line, you must use a Looping segment type on the same segment using the same parent in lines A, B or C.
• To use summary accounts, all segments in your formula must be assigned a segment type of Constant.

For target and offset lines (lines T and O)
• You must enter an account in the Target and Offset lines.
• Detail values must have a Constant segment type.
• Parent values must have a Looping segment type.
• Your Target account must be different from your Offset account.

Validation Business Rules
If you choose to use Full Cost Pool Allocation, below are the business rules used to validate your Allocation Formula Rules for lines A, B, and C. If your full cost pool allocation contains violations of the business rules, the execution report will detail the errors.
1. Line A is account or constant based.
2. Line B is account based.
3. Line B has at least one looping segment.
4. Line C is account based and has the same segment values as line B.
5. Line C uses Constant or Summing segment type if line B uses Constant or Summing segment type.
6. At least one Summing or Constant segment in line C corresponds to a looping segment in line B.

Oracle Applications Fusion Cloud - Inventory

Oracle Cloud/Fusion Procurement training will help you develop the fundamental skills required to set up and use the Procurement module. This training covers all the tasks, setups, forms and reports used in Procurement and related modules