To update the invoice distribution accounting date. The business mistakenly entered the GL accounting date Jun-26 instead of Nov-23 and the invoice is cancelled. We are updating the invoice distribution…
Read MoreIntroduction/ Issue: Cash Management data security is NOT partitioned by Business Unit, therefore its security policies allow access to all BUs. Why we need to do We noticed that when…
Read MoreTo create a new check payment template Prerequisites setup to create a new check payment template: Create a new “payment document” in bank account Create a new “Payment Process Profile” …
Read MoreFor Example, two countries the Natural account for Cash Clearing account should hit 1460020, this is to identify the TnE Cash Reimbursements. The following configurations needs to be updates Manage…
Read MoreCash Management Reconciliation Error (Trying to match the lines and reconcile. However, system throws an error as it exceeds the limit of 10000.) Below attached error screenshot Solution Create…
Read MoreIntroduction/ Issue: Unable to Generate Accounting for Receipt GRNs Why we need to do / Cause of the issue: Unable to Generate Accounting for Receipt Accounting. Create Accounting for Receiving…
Read MoreIntroduction/ Issue: Employees Forced to Include At least One Aged Corporate Card Transactions. Why we need to do / Cause of the issue: Employee unable to claim expense due to…
Read MoreIntroduction: This blog has the script to get the Non po invoice details in Oracle Cloud application for Audit purpose. Cause of the issue: Auditor wanted to see the Non-PO…
Read MoreIntroduction: This blog has the script to get the credit memo application details in Oracle Cloud application for Audit purpose. Cause of the issue: Auditor wanted to see the credit…
Read More1. Overview This blog explains about, How to Set Current Record Color -Multi Color. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle FORMS 3. Use Case Create a Simple Tabular Block Create Visual Attribute with color Gray -Name it as ODD Create Visual Attribute with color Blue -Name it as Event In When-New-Record-InstanceCreate a Procedure 4. Architecture Oracle FORMS FORM Builder 5. Examples Step 1: Create one procedure in forms. Code: PROCEDURE Visual_attribute_dis_alt_rec IS cur_itm VARCHAR2 (80); cur_block VARCHAR2 (80) := :SYSTEM.Cursor_Block; curr_record NUMBER; BEGIN cur_itm := GET_BLOCK_PROPERTY (cur_block, FIRST_ITEM); WHILE (cur_itm IS NOT NULL) LOOP cur_itm := cur_block || ‘.’ || cur_itm; Curr_record := :SYSTEM.Cursor_Record; IF MOD (curr_record, 2) = 1 THEN SET_ITEM_INSTANCE_PROPERTY (cur_itm,…
Read More