Go to primary content
Oracle® Retail Fiscal Management/RMS Brazil Localization Implementation Guide
Release 14.1.3
E83329-02
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 Tax Web Tax Rules?
What is Synchro 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 Fiscal Download
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
4
Publication and Subscription API Designs
Secondary ASNOut Publication API
Business Overview
Functionality Checklist
Form Impact
Business Object Records
Package Impact
Business Object ID
Package Name: FM_SECONDARY_ASNOUT
Spec File Name: fm_secondary_asnout_sql_s.pls
Body File Name: fm_secondary_asnout_sql_b.pls
Package Specification – Global Variables
Function Level Description
Trigger Impact
Trigger Name
Trigger File Name
Table
Message XSD
Table Impact
Design Assumptions
POSchedule Publication API
Business Overview
Functionality Checklist
Form Impact
Business Object Records
Package Impact
Business Object ID
Package Name: FM_SCHED_SUBMIT
Spec File Name: fm_sched_submit_sql_s.pls
Body File Name: fm_sched_submit_sql_b.pls
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 Name: FM_SHIPINFO_SQL
Spec File Name: fm_shipinfo_sql_s.pls
Body File Name: fm_shipinfo_sql_b.pls
Package Specification - Global Variables
Function/Procedure Level Description
Trigger Impact
Trigger Name
Trigger File Name
Table
Message XSD
Table Impact
Design Assumptions
5
Integrating ORFM
ORFM Integration
Purchase Order Receiving
PO Receiving at a Warehouse
PO Receiving at a Store
Transfer Shipment and Receiving
Transfers
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
Interface Table-Based Integration for Synchro
Nota Fiscal – Receiving and Issuing
Nota Fiscal Receiving
Nota Fiscal Issuing
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
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
Integrating with Synchro Tax Engine – Integration Layer
Integration Overview
Retail Tax Data Model
Object Structure Overview
High Level Integration View
Logging
Data Mapping and Expected Output Results
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
9
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
10
Understanding NF-e and SPED
Nota Fiscal Eletrônica (NF-e)
NF-e Solution
NF-e Options
NF-e Events
NF-e Publishing
NF-e Subscription
Sistema Público de Escrituração Digital (SPED)
SPED File Structure
SPED Solution
Performance Optimization for SPED
11
Maintaining Tax Related Data - TaxWeb
Installing Rules from TaxWeb Tax Rules
Understanding the Integrated Batch Schedule
Fiscal item reclassification Retail
Fiscal item reclassification Cost
Item Cost for Non-Brazil Supplier
Tax Law Changes Retail
Tax Law Changes Cost
Program Flow
Maintaining External Tax Information (L10N_BR_T_EXTAX_MAINT)
l10n_br_fiscal_item_reclass_cost.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_fiscal_reclass_item_finish_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_fiscal_reclass_item_setup_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_fiscal_loc_reclass_cost.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_fiscal_reclass_item_process_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_fiscal_loc_reclass_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_exec_tax_recalc.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_refresh_extax_finish_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_refresh_extax_future_cost.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_refresh_extax_process_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_refresh_extax_setup_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
12
Maintaining Tax Related Data - Synchro
Installing Rules from Synchro Tax Engine
Understanding the Integrated Batch Schedule
Fiscal item reclassification Retail
Fiscal item reclassification Cost
Item Cost for Non-Brazil Supplier
Tax Law Changes Retail
Tax Law Changes Cost
Program Flow
Maintaining External Tax Information (L10N_BR_S_EXTAX_MAINT)
l10n_br_fiscal_item_reclass_cost.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_fiscal_reclass_item_finish_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_fiscal_reclass_item_setup_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
10n_br_fiscal_loc_reclass_cost.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_fiscal_reclass_item_process_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_fiscal_loc_reclass_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_exec_tax_recalc.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_refresh_extax_finish_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_refresh_extax_future_cost.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_refresh_extax_process_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
l10n_br_refresh_extax_setup_retail.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
13
Understanding Batch Processes
TaxWeb Tax Rules Integration Batch
Batch Design Summary
L10nbr_taxweb_fiscnld (Fiscal Download)
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Locking Strategy
Security Considerations
Performance Considerations
Key Tables Affected
I/O Specification
L10nbrfreclsprg (Fiscal Reclassification Purge)
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Locking Strategy
Security Considerations
Performance Considerations
Key Tables Affected
I/O Specification
Synchro Tax Engine Integration Batch
Batch Design Summary
L10nbr_synchro_fiscnld (Fiscal Download)
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Locking Strategy
Security Considerations
Performance Considerations
Key Tables Affected
I/O Specification
L10nbrfreclsprg (Fiscal Reclassification Purge)
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Locking Strategy
Security Considerations
Performance Considerations
Key Tables Affected
I/O Specification
Financial Postings Batch
Batch Design Summary
fmfinpost.pc
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
fmtrandata.pc
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
Deal Income Postings Batch
Batch Design Summary
fmdealinc.pc
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
Financial Postings for Tax Changes Batches
Batch Design Summary
fmprepost.pc
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
fmtaxupld.pc
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
Fmtaxchg.pc
Functional Area
Modules Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
Purging Process Batch
fmpurge.pc
Functional Area
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
Localization Purging Process Batch
l10npurge.pc
Functional Area
Design Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
I/O Specification
Localization Batch
refmvl10entity (Refresh MV MV_L10N_ENTITY)
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Locking Strategy
Security Considerations
Performance Considerations
Key Tables Affected
I/O Specification
Localization Purging Process Batch
fm_batch_clear_calc_stg_t.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Locking Strategy
Security Considerations
Performance Considerations
Key Table Affected
I/O Specification
SPED Batch
Import_sped
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Locking Strategy
Security Considerations
Performance Considerations
Key Tables Affected
I/O Specification
NF EDI Batch
fmedinf
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Restart/Recovery
Locking Strategy
Security Considerations
Performance Considerations
Key Tables Affected
I/O Specification
Tax Calculation - Legislation of MG State
Batch Design Summary
fm_batch_avg_sales_price.ksh
Functional Area
Module Affected
Design Overview
Scheduling Constraints
Key Tables Affected
14
Configuring Security for Web Services
Transport-Level Security
Message-Level Security
Access Control Security
Implementing Web Service Security
Testing Web Service Security
15
Oracle Retail Invoice Receiving Layer
IRL Architecture
Integration Overview
IRL Web Services
IRL Data Model
Object Structure Overview
Configuration
16
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
ORFM Foundation
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
