Go to primary content
Oracle® Retail Fiscal Management/RMS Brazil Localization Implementation Guide
Release 14.2
F29404-01
Next
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Documentation Accessibility
Related Documents
Customer Support
Review Patch Documentation
Improved Process for Oracle Retail Documentation Corrections
Oracle Retail Documentation on the Oracle Technology Network
Conventions
1
Oracle Retail Fiscal Management Overview
What is Oracle Retail Fiscal Management?
System Setup
System Options
Fiscal Number
Tolerances
Requisition Types
Fiscal Configuration
Fiscal Document Type
Fiscal Utilization Code
ORFM Functional Assumptions
What is Nota Fiscal (NF)?
What is Nota Fiscal Eletrônica (NF-e)?
What is Retail Tax Integration Layer?
What is TaxWeb Tax Engine?
What is Sistema Público de Escrituração Digital (SPED)?
2
Understanding ORFM Implementation Checklists
Prerequisites
Implementation Checklist for Legacy Systems
Implementation Checklist for Standard Systems
3
Setting up RMS for ORFM and Brazil Localization
Decoupling RMS and ORFM Batch
Dynamic Function Calls
PL/SQL Package Calls
PL/SQL Type Inheritance
Localization Layer
Accomplishing Decoupling
Decoupling Batch Programs
Set up Item Fiscal Attributes
Set up Fiscal Attributes for other Entities
Set up Utilization
Set up Document Types
Set up System Options
Set up Reason Codes
Set up Partner
Set Primary Country
Set VAT Indicator
Set Default Tax Type
Verify Localized Indicator
Set up Tax Codes
Set up Flex Field Attribute
Set up Fiscal Document Chunk Size
Set up FM Tran Code
Set up Set Of Books
Set up Chart of Account
Set up GL Options
Dynamic Segments Set up for Chart of Accounts
Account Set up for Chart of Account
Set up GL Cross Reference
Including Balance to RTV Balance Control
Transfer Ownership
PO Receiving at a Warehouse
PO Receiving at a Warehouse
4
Integrating ORFM
Purchase Order Receiving
PO Receiving at a Warehouse
PO Receiving at a Store
Transfer Shipment and Receiving
Transfers
Transfer Creation
Return to Vendor (RTV) Shipments
RTV Shipped from Warehouse
RTV Shipped from Store
Balance Control for RTV
Retail Merchandise Authorization
Inventory Adjustment
Finishers/Repairing Flow (Two-Legged Transfer)
Two-Legged Transfer Shipping from RWMS
Two-Legged Transfer Receiving at RWMS
Two-Legged Transfer Shipping from SIM
Two-Legged Transfer Receiving at SIM
RIB-Based Integration
HTTP-Based Integration for TaxWeb
Nota Fiscal – Receiving and Issuing
Nota Fiscal Receiving
Inbound Process Flow
Nota Fiscal Issuing
Outbound Process Flow
Triangulation
EDI NF
ORFM and RWMS
PO Receiving
Transfer Receiving
ORFM and SIM
ORFM Integration with Financial Application
Supplier Set up and Integration
ORFM AP Integration Stage Head and Detail
5
Publication and Subscription API Designs
Secondary ASNOut Publication API
Functionality Checklist
Form Impact
Business Object Records
Package Impact
Business Object ID
Package Specification – Global Variables
Function Level Description
Trigger Impact
Trigger Name
Trigger File Name
Table
Message XSD
Table Impact
Design Assumptions
POSchedule Publication API
Functionality Checklist
Form Impact
Business Object Records
Package Impact
Business Object ID
Package Specification - Global Variables
Function Level Description
Trigger Impact
Trigger Name
Trigger File Name
Table
Message XSD
Table Impact
Design Assumptions
Shipment Information Subscription API
Business Overview
Assumptions
Functionality Checklist
Form Impact
Business Object Records
Package Impact
Package Specification - Global Variables
Function/Procedure Level Description
Trigger Impact
Trigger Name
Trigger File Name
Table
Message XSD
Table Impact
Design Assumptions
6
Archiving and Purging Data
7
Integrating with TaxWeb Tax Rules– Retail Tax Integration Layer
Integration Overview
Retail Tax Data Model
Object Structure Overview
Retail Tax Data Model to TaxWeb Tax Rules Data Model Object Mapping
RTIL Architecture
High Level Integration View
RTIL Integration Architecture
Components Deployment View
Client Components
RTIL Configuration
Logging/Audit
LoggerAspect
ObjectLoggerAspect
TimerLoggerAspect
User-friendly Exception Messages
Input Parameters Data Mapping and Expected Output Results
Concurrent Processing in RTIL
Tax. Calculation Scenarios
Scenario 1 - Inbound NF through User Entry
Scenario 2 - Inbound PO NFs through EDI
Scenario 3 - PO Receiving
Scenario 4 - Outbound NF Issuing
Scenario 4 - PO Tax Calculation
Scenario 5 - Item Creation
8
Working with RTIL
Operational Considerations
RTIL Log File Monitoring
Log File Archive and Purge
Time-out Configurations
Inventory Adjustment
URLInvoker Time-out
RIB Transaction Time-out
RTIL WorkManager Configurations
Maximum Threads Constraint
Capacity Constraint
General Troubleshooting for RTIL/TaxWeb Tax Rules
RMS/ORFM is configured with an incorrect RTIL URL (Service Access Point)
RTIL Service is not responding
RTIL URL Configuration is correct but insufficient privileges in RMS database for RMS/ORFM to access RTIL
Incomplete Deployment of TaxWeb Tax Rules libraries
How do I know if RTIL is installed correctly?
Recovery in case of RTIL Compensation API failure
RTIL and TaxWeb Tax Rules Outage Sequence/Start and Stop
Probable Systemic Failure Scenarios in Tax Flows and Recovery
TaxWeb Failures and Associated RIB Impacts
Deploying RTIL
9
Understanding NF-e and SPED
NF-e Solution
NF-e Options
NF-e Events
Webservices
Sistema Público de Escrituração Digital (SPED) Solution
Block K - Stock Position
Main Flow
Performance Optimization for SPED
10
Maintaining Tax Related Data - TaxWeb
Installing Rules from TaxWeb Tax Rules
Item Cost for Non-Brazil Supplier
Program Flow
Maintaining External Tax Information (L10N_BR_T_EXTAX_MAINT)
11
Maintaining Tax Related Data - TaxWeb
TaxWeb Tax Rules Integration and Maintaining Batches
fmtaxchg (Tax Changing Process)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
fmtaxupld (Tax Change Upload)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
Input File
l10n_br_exec_tax_recalc
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10n_br_fiscal_item_reclass_cost
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10n_br_fiscal_loc_reclass_cost
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10n_br_fiscal_loc_reclass_retail
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10n_br_fiscal_reclass_item_finish_retail
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10n_br_fiscal_reclass_item_process_retail
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10n_br_fiscal_reclass_item_setup_retail
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10n_br_refresh_extax_finish_retail
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10n_br_refresh_extax_future_cost
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10n_br_refresh_extax_process_retail
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10n_br_refresh_extax_setup_retail
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10nbr_taxweb_fisdnld (Taxweb Fiscal Download)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
Financial Posting Batches
fmtrandata (FM Transaction Data)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
fmfinpost (FM Financial Posting)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
import_SPED (SPED Batch)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
Deal Income Postings Batch
fmdealinc (Deal Income Posting)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
ORFM Utility Batches
fm_async_queue_cleanup (cleanup queues from async ORFM batches)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
fm_batch_avg_sales_price (Tax Calculation of Legislation of MG state)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
fm_batch_freclass_sql (ORFM Reclassification Process)
Design Overview
Scheduling Constraints
Key Tables Affected
fm_generate_nf_stkcount (Stock Count)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
fm_reprocess_nf_status_f (Reprocess NF-e with status F)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
fm_stock_position (Stock Position)
Design Overview
Stock Owner (Retailer) - Stock Possession (Retailer)
Stock Owner (Retailer) - Stock Possession (Third-Party)
Scheduling Constraints
Restart/Recovery
Key Tables Affected
fmedinf (NF EDI Batch)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
fmmanifest (FM Manifest Batch)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
fmprepost (Pre/Post processsing)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10n_ld_iindfiles (Load data into template tables for item induction)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
Localization Purge Batch Process
fm_batch_clear_calc_stg_t (Purge localization stage tables)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
fmpurge (Purging Process Batch)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10nbrfreclsprg (Fiscal Reclassification Purge)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
l10npurge (Localization Purging)
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
12
Configuring Security for Web Services
Transport-Level Security
Message-Level Security
Access Control Security
Implementing Web Service Security
Testing Web Service Security
13
Oracle Retail Invoice Receiving Layer
IRL Architecture
Integration Overview
IRL Web Services
IRL Data Model
Object Structure Overview
Configuration
14
Tax Burden Display at POS and Sales NF
Overview
Tax Burden Induction Framework
Manual Upload
Template Maintenance
Template Header
Worksheet Definition
Column Definition
Spreadsheet Formatting
Template Definition Examples
IBPT Source Template Example
A
Understanding RTIL WorkManager Settings
Configuring RTIL WorkManager
B
ORFM and Brazil Configuration Checklist
Setting up ORFM
Setting up RMS (Brazil-On) System Options
Setting up Set-Of-Books ID
Setting up General Ledger
Setting up GL Account
Setting up Chart of Account
Setting up GL Cross-Reference
System Setup
System Options
Fiscal Number Setup:
Tolerances
Commerce Anywhere
Setting up SIM System Options for ORFM
Setting up RWMS System Options for ORFM
Configuring Printer
RMS/ORFM
RWMS
SIM
