Sign Up

❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Ask Question
  • Write a Tutorial
  • Online Courses
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier
  • Ask Question
  • Write a Tutorial
  • Online Courses

Discy Latest Questions

Francois
Francois

Francois

  • 2 Questions
  • 0 Answers
  • 0 Best Answers
  • 30 Points
View Profile
  • 0
FrancoisContributor
Asked: February 23, 2022

Populate FORM table with Interactive Grid values

  • 0

Hi, I am trying to create a performance measurement capture form, so that various managers can capture their teams' monthly performance. To do so, I have created three tables (2 inputs (to populate pre-defined fields), and 1 that should store the form (output values). The inputs tables are something like: Table Name Department Column Department_Name (PK) Sales Procurement Logistics and KPI's Department_Name (FK) Team_Region Measurement Target Sales JHB New Sales 100000 Sales JHB Invoicing 100% Sales CT New Sales 90000 Sales DBN New Sales 80000 Procurement JHB Maintain stock levels 95% Procurement CT Maintain stock levels 85% Procurement DBN Maintain stock levels 70% Logistics JHB Order Delivery Within 2 days Logistics CT Order Delivery Within 2 days Logistics DBN Order Delivery Within 3 days With the output table being a combination of all the input (as well as additional values) Results Month Department_Name Team_Region Measurement Target Results Achieved Reason To store the output values, I have created a form based on the "Results" table, but I hid the fields that also exist in the "KPI's" table. I then created an Interactive Grid region to pre-populate the values from the KPI's table and created additional columns to capture the results per KPI and calculate if Achieved (in essence have all the values needed on the "Results" (my output) table, also in the interactive grid). Q1 - How to I set the values in the interactive grid to save to the Results (output) table. Q2 - As this is an interactive grid, if you select multiple Rows in the IG, it should create multiple Rows in the Results table for ...

apexformsig
  • 0
  • 22
  • 0
Answer
Ali Akbar
Ali Akbar

Ali Akbar

  • Faisalabad, Pakistan
  • 30 Questions
  • 16 Answers
  • 0 Best Answers
  • 185 Points
View Profile
  • 0
Ali AkbarProfessional
Asked: September 18, 2021

How Can We Call Apex Page from oracle forms

  • 0

How Can We Call Apex Page with authentication from oracle forms.?

apexforms
  • 2
  • 197
  • 0
Answer
Chaitanya
Chaitanya

Chaitanya

  • 31 Questions
  • 42 Answers
  • 0 Best Answers
  • 195 Points
View Profile
  • 0
ChaitanyaProfessional
Asked: July 3, 2021

Oracle form migration to oracle apex

  • 0

I want to migrate my oracle forms into oracle apex as Shown in some blogs i converted my (.fmb) into (.xml) and i uploded into my oracle apex throught oracle forms migration. Now what to do ? i cannot find any application how to use it  

formsmigrationoracle apex
  • 0
  • 106
  • 0
Answer
Advertisement

Sidebar

Ask Question
Write a Tutorial
Advertisement

Recent Blog Posts

  • Vinish

    Oracle LENGTH()

  • Vinish

    Oracle INSTR() Function

  • Vinish

    Oracle INITCAP() Function

  • Vinish

    Oracle Concat

  • Vinish

    Oracle CHR Function

Advertisement
Advertisement

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2021 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us