Results for “initialize_batch”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CN_PREPOST_PVT is a private PL/SQL package body in the Oracle EBS Incentive Compensation (CN) module. It encapsulates the core preposting engine used to transform commission and bonus earnings into preposting detail records prior to final posting to Oracle Payables and Oracle General Ledger. Within the Oracle EBS 12.1.1 and 12.2.2 code lines, this package belongs to the APPS schema and follows the _PVT naming convention reserved for internal, non-public APIs that are not intended for direct customer invocation.

The package defines a rich set of package-level constants that drive its logic. Posting status values include POSTED, UNPOSTED, and REVERTED, while the default posting detail status is UNLOADED. Incentive type codes cover COMMISSION, BONUS, and MANUAL. Critically for the search term non_rec, the package declares posting type constants C_NON_REC ('NON_REC'), C_REC ('REC'), C_TO_REC ('TO_REC'), and C_EXPENSE ('EXPENSE'), along with corresponding transaction type codes such as COMM_NREC, COMM_REC, COMM_TO_REC, BONUS_REC, BONUS_TO_REC, and MANUAL_EXPENSE. These constants distinguish non-recoverable (NON_REC) from recoverable earnings, ensuring each incentive is posted to the correct accounting treatment.

Key Procedures and Functions

• INITIALIZE_BATCH — A public procedure that obtains the posting batch ID for the current session. If no batch exists, one is initialized privately, with the batch name derived from the date and session ID.
• TERMINATE_BATCH — Closes out the session-level posting batch, releasing the batch context established by INITIALIZE_BATCH.
• CREATE_FROM_COMMLINE — Builds preposting detail records by reading commission lines and converting them into the preposting structure used for downstream posting.
• CREATE_PREPOSTDETAILS — The central procedure that generates preposting detail rows, applying posting type classification (including NON_REC, REC, TO_REC, and EXPENSE) and transaction type mapping.
• PREPOST_PAYWORKSHEETS — Drives preposting across payment worksheets, aggregating payee earnings for subsequent posting runs.

Tables Accessed

• CN_COMMISSION_LINES / CN_COMMISSION_LINES_ALL — Source commission line data converted into preposting details.
• CN_PAYMENT_WORKSHEETS — Worksheet records processed during preposting.
• CN_PAYRUNS — Payrun context linking earnings to specific payment cycles.
• CN_PERIOD_STATUSES — Determines whether a period is open for posting.
• CN_POSTING_BATCHES — Stores the batch ID created and terminated by the batch procedures.
• CN_QUOTAS_ALL and CN_SRP_PAYEE_ASSIGNS_ALL — Quota and payee assignment data influencing incentive calculation.
• CN_WORKSHEET_BONUSES — Bonus records included in the preposting scope.
• PLITBLM — A standard EBS PL/SQL table-of-rows type used for bulk processing.

Usage Notes

CN_PREPOST_PVT is invoked indirectly by the Incentive Compensation preposting concurrent programs and by other CN module internals; the metadata indicates it is referenced by zero other packages directly, confirming its role as a lower-level engine called through the standard preposting workflow rather than a widely reused API. The C_SYS_POST_PROCESS constant ('SYS_PREPOST_PROCESS') designates rows created by this system process. Practitioners encountering the non_rec value in CN posting data should recognize it as the NON_REC posting type constant emitted by CREATE_PREPOSTDETAILS for non-recoverable commission transactions.