Posts

Showing posts from January, 2026

SIngle CUrrency XML

2026008 2026008-COM-20034-COM 2026008-COM-20034-COM USD 2026008 09/26/2025 20034 300000472449727 Enterprise: AE & ISR ACQ (IC_SA)-ISR A 08/02/2025 SEPFY26_NA_US_REGULAR_COM_20034 DELl_NA_US_20034_PAYGROUP 23.8012 59.5179 300000718852909 2142.8572 0.0111 83.3190 178.5714 Y 83.319 83.319 23.8012 59.5179 COMMISSION US 1309158 1 83.319 2HFY26 Final Payout ACQ & Non-ACQ (IC_SA) MAV_DIR_BB_ACTION_1000 MVA_DIR_BB_REASON_1018 Full BB is pre-approved by system as the rep is active sale rep within the defined threshold limits (BB % HR TI ≥ -5% and ≤ 5%). Pre-approved not applicable for Austria country. 88001 N 300002668033938 Jana Wynelle Frank 2026008--1244163-ALL 2026008--1244163-ALL PAB 2026008 09/26/2025 1244163 300000472474083 DFS: AI Specialist (IC_SA) A 08/02/2025 Panama- Sep DELL_LA_PA_PAYGROUP 0.0000 383.3333 24000.0000 0 0.0000 2000.0000 Y 383.3333 383.3333 0 383.3333 ALL PA 1309158 1 0 MAV_DIR_MPA_CODE_1008 0 Auto approved Y 52001 N 300001818003395 Juan Antonio Esquijar...

getorigiattribute

// Inside your logic block def originalVal = getOriginalAttributeValue("BBActionManual_c") setAttribute("BBActionManual_c", originalVal) throw new oracle.jbo.ValidationException("Invalid selection. Reverting to: " + originalVal)

fixed

// 1. Check the primary action code if (BBActionManual_c == 'MAV_DIR_BB_ACTION_1011') { // 2. Check the Incentive Type if (IncentiveType_c == 'COMMISSION' || IncentiveType_c == 'BONUS') { // Use a safe null check for CED_c def cedValue = CED_c ?: 0 // Define the two valid scenarios for clarity boolean isValidTerminated = (HRStatus_c == 'T' && EmploymentCountry_c != 'RO' && SalesRP_c == 'Y' && cedValue

code..

if (BBActionManual_c == 'MAV_DIR_BB_ACTION_1011') { if (IncentiveType_c == 'COMMISSION' || IncentiveType_c == 'BONUS') { if !(HRStatus_c == 'T' && EmploymentCountry_c != 'RO' && SalesRP_c == 'Y' && (CED_c ?: 0)

newPost

if (IncentiveType_c == 'BONUS' && ( BBReasonCode_c == 'MVA_DIR_BB_REASON_1011' || BBReasonCode_c == 'MVA_DIR_BB_REASON_1012' || BBReasonCode_c == 'MVA_DIR_BB_REASON_1013' || BBReasonCode_c == 'MVA_DIR_BB_REASON_1014' || BBReasonCode_c == 'MVA_DIR_BB_REASON_1015' || BBReasonCode_c == 'MVA_DIR_BB_REASON_1016' ) ) { throw new oracle.jbo.ValidationException ("This BB reason cannot be selected for incentive Type Bonus."); } if (IncentiveType_c == 'COMMISSION' && ( BBReasonCode_c == 'MVA_DIR_BB_REASON_1022' || BBReasonCode_c == 'MVA_DIR_BB_REASON_1023' || BBReasonCode_c == 'MVA_DIR_BB_REASON_1024' || BBReasonCode_c == 'MVA_DIR_BB_REASON_1025' || BBReasonCode_c == 'MVA_DIR_BB_REASON_1026' ) ) { thr...

wth debug

// 1. Log the checkbox status println("DEBUG: EmployeeConsent_c value is: " + EmployeeConsent_c) if (EmployeeConsent_c == true) { // 2. Access the Attachment collection // Note: If 'Attachment' fails, try 'Attachment_c' or check the object definition def attachmentRows = Attachment // 3. Log if the collection exists if (attachmentRows == null) { println("DEBUG: Attachment collection is NULL") return false // Trigger error: No collection found } // 4. Count the attachments attachmentRows.reset() // Start at the beginning int count = 0 while (attachmentRows.hasNext()) { attachmentRows.next() count++ } println("DEBUG: Total attachment count found: " + count) // 5. Trigger error if count is 0 if (count == 0) { println("DEBUG: Validation FAILED - No attachments found") return false } } println("DEBUG:...

mployeeconsetattachment validation

// 1. Check if the Consent checkbox is checked (true) if (EmployeeConsent_c == true) { // 2. Access the Attachments collection // Note: 'Attachment' is the standard internal name for the collection def attachmentRows = Attachment // 3. If there are no rows in the attachment collection, trigger the error if (attachmentRows == null || !attachmentRows.hasNext()) { return false // This triggers the validation message } } return true // Validation passes

child xml

This XML file does not appear to have any style information associated with it. The document tree is shown below. 2026008-REGULAR-500778-SPIF 2026008-REGULAR-500778-BBMC-INR 2026008-REGULAR-500778-BBMC-INR -184.9844 INR -184.9844 -184.9844 INR 1.0000 300003364971213 2026008 2026007 300000472470437 BB MC 2026008-COM-278788-SPIF 2026008-COM-278788-BBMC-USD 2026008-COM-278788-BBMC-USD 599.9994 USD 599.9994 52938.0095 INR 88.2301 300003354003417 2026008 2026007 300000472430771 BB MC 2026008--1315186-SPIF 2026008--1315186-BBMC-EUR 2026008--1315186-BBMC-EUR -6756.9163 EUR -6756.9163 -7432.6080 USD 1.1000 300003509654383 2026008 2026007 300000472435021 BB MC 2026008-COM-1289035-SPIF 2026008-COM-1289035-BBMC-USD 2026008-COM-1289035-BBMC-USD 66.6000 USD 66.6000 5876.1249 INR 88.2301 300002827421426 2026008 2026007 300000472435394 BB MC 2026008-COM-1034349-SPIF 2026008-COM-1034349-BBMC-USD 2026008-COM-1034349-BBMC-USD 3100....

Parent tags

This XML file does not appear to have any style information associated with it. The document tree is shown below. 2026008 2026008-REGULAR-500778-COM 2026008-REGULAR-500778-COM 300003364971213 2026008 09/26/2025 500778 300000472470437 08/17/2025 01/30/2026 SEPFY26_REGULAR_500778 DELL_500778_PG -182.8878 -2400.3668 INR 300000718852909 2000.0000 2.0966 -2.0966 N 0.0000 1309158 0 88.2301 2HFY26 Final Payout ACQ & Non-ACQ (IC_SA) Enterprise: AE & ISR ACQ (IC_SA)-ISR A IN -184.9844 2217.4790 -182.8878 24000.0000 -0.7708 COMMISSION 0.0000 2.0966 Y CONVERSION 1 MAV_DIR_BB_ACTION_1000 MVA_DIR_BB_REASON_1018 Full BB is pre-approved by system as the rep is active sale rep within the defined threshold limits (BB % HR TI ≥ -5% and ≤ 5%). Pre-approved not applicable for Austria country. 101001 Andre Luiz Loureiro 2026008-COM-278788-COM 2026008-COM-278788-COM 300003354003417 2026008 09/26/2025 278788 300000472430771 09/26/2025 01/30/...
Id RecordName MTQ_ICM_PPH_OBJ_Id_c ParentRecordName ParentRecordNumber RecordNumber CurrencyCode BBConversionFactorHCToLHC_c BBHomeCurrency_c BBInHomeCurrency_c BBInLatestHomeCurrency_c BBInMultiCurrency_c BBLatestHomeCurrency_c MultiCurrencyScenario_c PTDEarningsConversionFactorHCToLHC_c PTDEarningsHomeCurrency_c PTDEarningsInHomeCurrency_c PTDEarningsInLatestHomeCurrency_c PTDEarningsLatestHomeCurrency_c PTDInMulticurrency_c PayrunId_c PaymentBatchPeriod_c PeriodId_c

child columns2

Id RecordName MTQ_ICM_PPH_OBJ_Id_c ParentRecordName ParentRecordNumber RecordNumber CurrencyCode BBConversionFactorHCToLHC_c BBHomeCurrency_c BBInHomeCurrency_c BBInLatestHomeCurrency_c BBInMultiCurrency_c BBLatestHomeCurrency_c MultiCurrencyScenario_c PTDEarningsConversionFactorHCToLHC_c PTDEarningsHomeCurrency_c PTDEarningsInHomeCurrency_c PTDEarningsInLatestHomeCurrency_c PTDEarningsLatestHomeCurrency_c PTDInMulticurrency_c

CHild Columns

Name Display Name RecordName MultiCurrency Name CreationDate Creation Date BBConversionFactorHCToLHC_c BB Conversion factor (HC to LHC) BBHomeCurrency_c BB Home currency PTDEarningsHomeCurrency_c PTD Earnings Home currency PTDEarningsLatestHomeCurrency_c PTD Earnings Latest Home currency CurrencyCode Currency Code MTQ_ICM_PPH_OBJ_Id_c MTQ_ICM_PPH_OBJ_Id_c PTDEarningsInLatestHomeCurrency_c PTD Earnings in Latest Home Currency LastUpdatedBy Last Updated By BBInHomeCurrency_c BB in Home currency CreatedBy Created By BBInLatestHomeCurrency_c BB in Latest Home Currency BBInMultiCurrency_c BB in Multi currency PTDInMulticurrency_c PTD in Multicurrency PTDEarningsConversionFactorHCToLHC_c PTD Earnings Conversion factor (HC to LHC) MultiCurrencyScenario_c Multi Currency Scenario Id Record ID PTDEarningsInHomeCurrency_c PTD Earnings in Home currency RecordNumber Record Number BBLatestHomeCurrency_c BB Latest Home currency LastUpdateDate Last Update Date

Multicurrencylatest

select rules.* , -- BBAction_c DECODE(Rule_Number, 1, 'MAV_DIR_BB_ACTION_1000', 2, 'MAV_DIR_BB_ACTION_1003', 3, 'MAV_DIR_BB_ACTION_1001', 4, 'MAV_DIR_BB_ACTION_1003', 5, 'MAV_DIR_BB_ACTION_1003', 6, 'MAV_DIR_BB_ACTION_1003', 7, 'MAV_DIR_BB_ACTION_1003', 8, 'MAV_DIR_BB_ACTION_1003', 9, 'MAV_DIR_BB_ACTION_1003', 10, 'MAV_DIR_BB_ACTION_1003', 99, 'MAV_DIR_BB_ACTION_1002', 11 , 'MAV_DIR_BB_ACTION_1002', -- Pre-approved zero BB for active sale rep NULL ) AS "BBAction_c", -- BBReasonCode_c DECODE(Rule_Number, 1, 'MVA_DIR_BB_REASON_1018', 2, 'MVA_DIR_BB_REASON_1001', 3, 'MVA_DIR_BB_REASON_1018', 4, 'MVA_DIR_BB_REASON_1001', 5, 'MVA_DIR_BB_REASON_1001', 6, 'MVA_DI...

xml - actual

2026008 2026008--1244163-ALL 2026008--1244163-ALL PAB 2026008 09/26/2025 1244163 300000472474083 DFS: AI Specialist (IC_SA) A 08/02/2025 Panama- Sep DELL_LA_PA_PAYGROUP 0.0000 383.3333 24000.0000 0 0.0000 2000.0000 Y 383.3333 383.3333 0 383.3333 ALL PA 1309158 1 0 MAV_DIR_MPA_CODE_1008 0 Auto approved Y 52001 N 300001818003395 2026008-COM-20034-COM 2026008-COM-20034-COM USD 2026008 09/26/2025 20034 300000472449727 Enterprise: AE & ISR ACQ (IC_SA)-ISR A 08/02/2025 SEPFY26_NA_US_REGULAR_COM_20034 DELl_NA_US_20034_PAYGROUP 23.8012 59.5179 300000718852909 2142.8572 0.0111 83.3190 178.5714 Y 83.319 83.319 23.8012 59.5179 COMMISSION US 1309158 1 83.319 2HFY26 Final Payout ACQ & Non-ACQ (IC_SA) MAV_DIR_BB_ACTION_1000 MVA_DIR_BB_REASON_1018 Full BB is pre-approved by system as the rep is active sale rep within the defined threshold limits (BB % HR TI ≥ -5% and ≤ 5%). Pre-approved not applicable for Austria country. 88001 N 300002668033938 2026008--1244495-ALL 2026008--1244495...

ISO 8601 - YYYY-MM-DDThh:mm:ss.sss+/-hh:mm

PPH Columns

Name Display Name RecordName Record name CreationDate Creation Date TotalPaysheetAmountInLHC_c Total paysheet amount in LHC SCDReference_c SCDReference CurrencyCode Currency Code SubmittedBy_c Submitted By PrePayHubStatus_c PrePayHub Status EmploymentCountry_c Employment Country RecoverableFlagV1_c Recoverable Flag BBActionManual_c BB Action Manual ParticipantPayId_c ParticipantPayId LastUpdatedBy Last Updated By ConversionRateHomeToUSD_c Conversion Rate(Home to USD) CreatedBy Created By PayPeriodID_c Pay Period ID SCDEPAValue_c SCDEPAValue CEDUSD_c CED USD ParticipantName_c Participant Name Id Record ID ApprovedDate_c Approved Date PayrollSubmissionEndCST_c Payroll submission End CST RecordNumber Record Number Par...