How SharePlex reports out-of-sync conditions For all objects except those involved in transformation, SharePlex verifies that the source and target data in a given operation are synchronized before posting the…
Read MoreIssue ; while closing the AR period we could see one receipt in in valid status in subledger period close exception report. Fix ; we have data fix for…
Read MoreIntroduction:- Oracle has a seeded API fnd_user_pkg which has a procedure to create new user login account. Below is the sample script to create user account, change the parameters as per your…
Read MoreIntroduction:- fnd_user_pkg.addresp is an Oracle Seeded API to add responsibilities from one user account to another user account.Below is the script to copy responsibilities of user “ORACLE_TEST_USER_12” to “ORACLE_TEST_USER_89”. API…
Read MoreIntroduction: Beginning with Oracle APEX 20.2, the only supported Web listener is Oracle REST Data Services (ORDS). What is ORDS? Oracle REST Data Services (ORDS) is a data service which…
Read MoreHere is an easy way to put all the Pending Concurrent requests in hold, if we are going through any situation(Mostly any Production Cutover/Go live scenarios). 1. First create a…
Read MoreSELECT hca.account_number, ( SELECT hp.party_name FROM apps.hz_parties hp WHERE hp.party_id = hca.party_id ) customer_name, jnb.creation_date notes_creation_date, jnb.note_type note_type, fls.meaning note_type_meaning, jnt.notes notes FROM apps.hz_cust_accounts hca, apps.jtf_notes_b jnb, apps.jtf_notes_tl jnt, apps.fnd_lookups…
Read MoreSELECT DISTINCT –gcck.concatenated_segments, gcck.segment1 company, gcck.segment2 location, gcck.segment3 product, gcck.segment4 function, gcck.segment5 account, gcck.segment6 intercompany, gcck.segment7 subaccount, gcck.segment8 future1, gcck.segment9 future2, rctld.gl_date, gjb.name batch_name, gjh.name journal_name, ( SELECT user_je_category_name FROM…
Read MoreSELECT hou.name operating_unit, xep.name legal_entity, ala.lockbox_number “NUMBER”, absa.name batch_source, cebb.bank_name, –cebb.bank_number, –cebb.bank_branch_name, –cebb.bank_branch_number, –cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA,…
Read MoreHow to Change MTU Size in Exadata Environment Issue: Having a larger value for MTU such as 65520 bytes = 64kb will require more memory pages to support IPoIB, the…
Read More