Blanket Purchase Agreement FBDI Process
bpa-word-document
Read MoreMultiple files upload in Oracle
External table Data load with Delimiter Introduction: to upload the data with the delimiter and special character. Cause of the issue: In the control file having issue to load…
Read MoreFeature Oracle Database 12c, 19c, 21c
Feature Oracle Database 12c, 19c, 21c Introduction: Oracle is by far the leader in all key leading research reports for On-prem and Cloud Database Management Systems. Oracle is…
Read MoreQuery to get project and task details – Fusion
Query to get Projects and Tasks Details – Fusion SELECT TO_CHAR(PPA.PROJECT_ID) PROJECT_ID ,TO_CHAR(PPA.SEGMENT1) PROJECT_NUMBER ,PPA.NAME PROJECT_NAME ,PPA.DESCRIPTION ,PPA.START_DATE ,PPA.COMPLETION_DATE ,PPA.CLOSED_DATE ,PTV.TASK_NUMBER ,TO_CHAR(PTV.TASK_ID) TASK_ID ,TO_CHAR(PPA.CARRYING_OUT_ORGANIZATION_ID) ORGANIZATION_ID ,HRU.NAME ORGANIZATION_NAME ,PPT.PROJECT_TYPE PROJECT_TYPE ,PPA.GROUP_SPACE_TEMPLATE_NAME…
Read MoreQueries to get Employee related information – Fusion
Query to Fetch Employee’s Legal Employer SELECT papf.person_number, hauft.NAME LegalEmployer FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft, per_all_assignments_m paam, per_all_people_f papf WHERE haouf.ORGANIZATION_ID = houcf.ORGANIZATION_ID…
Read MoreUpdate customer send statement and send dunning flag Using SOAP Webservice – Oracle Fusion
Introduction: This blog has the SOAP Webservice details that can be used to update the customer send statement and send dunning flag into Oracle Cloud application. Cause of the…
Read MoreUpdate customer statement delivery method Using SOAP Webservice – Oracle Fusion
Introduction: This blog has the SOAP Webservice details that can be used to update the customer statement delivery method into Oracle Cloud application. Cause of the issue: Business…
Read MoreCarrier Lookups
carrier-lookupsroles-and-role-types receive-item-into-inventory requisition-by-min-max-n-replenishment
Read MoreBack Date Sales order creation
Back Date Sales Order Creation, we generally come across this case during period closure, post period closure and starting of new month, we need to book AR invoice in previous…
Read More