Search Results generate_schedule
Overview
APPS.JAI_RCV_RGM_CLAIMS_PKG is an Oracle E-Business Suite package body that supports the India localization (JAI – Java-based Advanced India) requirements for the Receiving (RCV) module, specifically around Return Goods Management (RGM) claims processing. The package handles the logic required to generate claims against receipts, link receiving transactions to inventory organizations and subinventories, correct receipt and return-to-vendor (RTV) transactions, apply taxes, generate accounting entries for RTV and RMA scenarios, and post results to the general ledger interface. The package is part of the broader JAI_RCV family that integrates receiving with tax, inventory, and payables subsystems, and is referenced by one other package within the localization layer.
Key Procedures and Functions
The documented procedures and functions cover the full claim lifecycle from schedule generation through accounting:
- GET_LOCATION – Resolves the correct location ID associated with a receiving transaction, navigating delivery subinventory records and organization-subinventory-location relationships.
- GENERATE_SCHEDULE – The procedure most relevant to the "generate_schedule" search; it produces the schedule driving claim generation, typically determining which receipt lines qualify for RGM claim processing.
- INSERT_RCV_LINES – Inserts claim-related receiving lines into the JAI_RCV_LINES structure.
- UPDATE_RCV_LINES – Updates existing claim receiving lines, for example to reflect corrected quantities or status changes.
- PROCESS_VAT – Applies VAT/tax computation logic to claim records using the JAI tax tables.
- PROCESS_CLAIM – Executes the main claim processing path when a claim is to be raised.
- PROCESS_NO_CLAIM – Handles the alternative path where no claim is raised, ensuring downstream records remain consistent.
- PROCESS_BATCH – Orchestrates batch execution of claim processing across multiple records.
- DO_RTV_ACCOUNTING – Generates accounting distributions for return-to-vendor transactions.
- DO_RMA_ACCOUNTING – Generates accounting distributions for return material authorization (RMA) transactions.
Tables Accessed
The package reads and writes a broad set of APPS synonyms:
- RCV_TRANSACTIONS, RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES – Source receiving transaction and shipment data driving claim eligibility and correction logic.
- JAI_RCV_LINES, JAI_RCV_TRANSACTIONS, JAI_RCV_RGM_LINES – India-localization tables holding the claim lines, transactions, and RGM records produced by this package.
- JAI_RGM_DEFINITIONS, JAI_RGM_TERMS – Configure the rules and terms governing Return Goods Management claims.
- JAI_CMN_TAXES_ALL, JAI_AP_MATCH_INV_TAXES – Supply tax setup and invoice-matching tax data used in VAT processing.
- HR_LOCATIONS_ALL, HR_ALL_ORGANIZATION_UNITS, JAI_INV_SUBINV_DTLS – Resolve location, organization, and subinventory relationships for receipt placement.
- AP_INVOICE_DISTRIBUTIONS_ALL – Referenced for payables-side validation/matching.
- GL_INTERFACE – Receives accounting lines generated by the RTV and RMA accounting procedures for transfer to the general ledger.
Usage Notes
This package is not an end-user-facing API; it is invoked internally by the JAI receiving localization layer and by one other package documented in ETRM. In practice it is triggered during receipt correction, RTV, and RMA processing within the India localization, often via concurrent programs or by forms that call the parent JAI_RCV processing routine (which in turn calls GENERATE_SCHEDULE and PROCESS_CLAIM/PROCESS_NO_CLAIM). Accounting procedures DO_RTV_ACCOUNTING and DO_RMA_ACCOUNTING are typically executed as part of batch or period-end processing to populate GL_INTERFACE. Because the package directly manipulates localization tables and the GL interface, customizations should call the published entry points rather than modifying the underlying records, and any integration should respect the batch-oriented PROCESS_BATCH flow to preserve schedule, tax, and accounting consistency across Oracle EBS 12.1.1 and 12.2.x releases.
-
APPS.JAI_RCV_RGM_CLAIMS_PKG SQL Statements
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG SQL Statements
12.1.1
-
PACKAGE BODY: APPS.JAI_RCV_RGM_CLAIMS_PKG
12.2.2
-
PACKAGE: APPS.JAI_RCV_RGM_CLAIMS_PKG
12.1.1
-
PACKAGE BODY: APPS.JAI_RCV_RGM_CLAIMS_PKG
12.1.1
-
PACKAGE: APPS.OKS_PM_PROGRAMS_PVT
12.2.2
-
PACKAGE: APPS.OKS_PM_PROGRAMS_PVT
12.1.1
-
PACKAGE: APPS.JAI_RCV_RGM_CLAIMS_PKG
12.2.2
-
PACKAGE: APPS.PA_SCHEDULE_OBJECTS_PVT
12.1.1
-
PACKAGE: APPS.PA_SCHEDULE_OBJECTS_PVT
12.2.2
-
APPS.PA_PROGRESS_PVT dependencies on PA_UTILS
12.2.2
-
APPS.PA_SCHEDULE_OBJECTS_PVT dependencies on FND_API
12.1.1
-
APPS.PA_PROGRESS_PVT dependencies on PA_UTILS
12.1.1
-
APPS.PA_SCHEDULE_OBJECTS_PVT dependencies on FND_API
12.2.2
-
APPS.OKS_PM_PROGRAMS_PVT dependencies on OKS_PM_PROGRAMS_PVT
12.2.2
-
APPS.OKS_PM_PROGRAMS_PVT dependencies on OKS_PM_PROGRAMS_PVT
12.1.1
-
APPS.PA_SCHEDULE_OBJECTS_PVT dependencies on FND_PROFILE
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RGM_TERMS
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RGM_TERMS
12.1.1
-
APPS.PA_SCHEDULE_OBJECTS_PVT dependencies on FND_MSG_PUB
12.1.1
-
PACKAGE BODY: APPS.OKS_PM_PROGRAMS_PVT
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RGM_TERMS
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RGM_TERMS
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_RGM_CLAIMS_PKG
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_RGM_CLAIMS_PKG
12.1.1
-
APPS.PA_SCHEDULE_OBJECTS_PVT dependencies on FND_MSG_PUB
12.2.2
-
PACKAGE BODY: APPS.OKS_PM_PROGRAMS_PVT
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on HR_LOCATIONS_ALL
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on HR_LOCATIONS_ALL
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_RGM_CLAIMS
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_RGM_CLAIMS
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_GENERAL_PKG
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_GENERAL_PKG
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_SHIPMENT_HEADERS
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on FND_FILE
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on FND_FILE
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_SHIPMENT_LINES
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_SHIPMENT_HEADERS
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_TRANSACTIONS
12.2.2
-
APPS.OKS_PM_PROGRAMS_PVT dependencies on OKC_API
12.2.2
-
APPS.OKS_PM_PROGRAMS_PVT dependencies on OKC_API
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_TRANSACTIONS
12.1.1
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_SHIPMENT_LINES
12.2.2
-
APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_CONSTANTS
12.1.1
-
APPS.PA_SCHEDULE_OBJECTS_PVT dependencies on PA_DEBUG
12.1.1
-
PACKAGE BODY: APPS.PA_PROGRESS_PVT
12.2.2